How to automatically change other sheets when multiple selections are made in ENUMLIST

[suzukixxx]

This app has a "Voucher" sheet that represents transitions and a "Status" sheet that represents product states. It has an automation function that changes the "status" of the product when you add the "voucher" when the product is shipped. However, while it works for one product, this automation does not work for multiple selections of products of type ENUMLIST.
The content of the current automation is
When a "voucher" sheet is added, the call process calls the "status" sheet and the lookup changes the cells.

Please let me know if there is a good way to automatically change the status of multiple rows on other sheets when multiple selections are made in ENUMLIST.

[WillowMobileSys]

You need to create an expression that selects the Status tables rows based on the Products listed in the EnumList column:

SELECT(Status[Row ID], IN([Product], [_THISROW].[EnumList Column]))

 Of course you will need to replace [Row ID], [Product] and [EnumList Column] with the actual names of the columns from your app.

Also note, this is a generalization of how you would use an EnumList to select rows for processing.  What you may need to actually implement could differ based on your specific use case - which we don't know.

[suzukixxx]

Thank you for your reply.I see, I understand up to the place where the value is returned with the select syntax. But I don't understand where to fill it in.

Currently, we are using automation, and the bot is set to move when the data of the "Voucher" is changed, and the "state" table is called by call a process and changes are made by Lookup. I put the select syntax you gave me in its place, but it didn't work.
Publish the app that cuts out the corresponding issue. Please let me know if anything is wrong or unclear.
https://www.appsheet.com/start/a80e0a5b-62ed-46cd-a404-c70f43f7ffec?refresh=1

[WillowMobileSys]

Your bot would call an action.  That action would be of type "execute an action on a set of rows".  In this action set the Referenced rows property to the SELECT(), The Reference table to "Status" and then create another action to add to the Referenced action property.  This second action will be the one that updates the Status row.

This is high-level steps so just respond id you still have questions.

[suzukixxx]

Thanks for the reply anyway. I didn't know where to enter it and ended up confused and unable to move forward. Please give me a little more time.

[WillowMobileSys]

I recommend reviewing this article to start a better understanding of hoe to create a Bot.

Bots: The Essentials