I have a Sliced Table named โDeliveryโ from the Table โTransactionโ based on a columnโs condition [Status] = In Delivery, and an Action is triggered on this Sliced Table to change the [Status] to Delivered.
What I wanted to do is to have a filtered table to filter out all delivery transactions with [Status] = In Delivery. User will have to press โReceivedโ button and change the [Status] to Delivered. When [Status] is change to Delivered, a workflow will be triggered to update those Item locations accordingly by copying the latest delivery transaction.
However, a problem will appear: While the Action is being triggered, an error would show:
"Errors": "Error: โExecute an Action on a Set of Rowsโ Data action โ โUpdate Item Locationโ for table 'Transaction failed with exception ReadRow failed because row having key โ09/24/2020 13:35:43โ not found in table โDeliveryโ. ",
From my understanding, after the [Status] is changed, it no longer shows on the โDeliveryโ Slice Table, so the Action cannot be executed. What can I do?
Why donโt you use the original table as a reference rather than the slice?
Actually, I donโt even know how Iโve selected the Slice. I donโt see it anywhere in the Workflow or Action. I donโt think I can select the Slice Table there?
Where else could I possibly select a Slice Table for the workflow or action?
You can find that Reference table option from the โExecute an Action on a Set of Rowsโ actionโs definition.
I donโt see the Sliced Table being selectable there
What is your account ID and app & Wokflow name if I check the app directly?
Account ID: 831910
App: ๆฉๆขฐ่ชฟๅ็ณป็ตฑ_V2 (Sorry itโs in Chinese)
Workflow name: Update Item Location
Action Name: Update Item Location
If I understood your Chinese table and column names correctly, you are trying to read key values from a table/column with the SPLIT([็ทจ่], ", "). Please read correct list with a SELECT() expression. Something likeโฆ
SELECT( ้ ็ฎ[็ทจ่],IN([็ทจ่],[_THISROW].[็ทจ่]))
I seem to still receiving that error about the action being executed on a slice table. How do I change that?
User | Count |
---|---|
43 | |
30 | |
26 | |
14 | |
14 |