I am using the Order Capture App (Customer, Orders, Orders Details, Products) as the template for my own App. After structuring the fields of my need and developing several actions and workflows, I wrote an Action that could “migrate” some Order Ids (Ref Column) from Order Details Worksheet to another one, already registered for same customer. In other words, I need to consolidate some Order Ids by changing the “donors” Order Id to the "receivers’ Order Id.
The problem that I’ve been facing is that this Action “Data: sets a value in a column”, when I use Expressions for the Value such as " TEXT(SELECT(Orders[Order Id], [Order Status]=“Destiny”)) ", the test verifies the Order Id of the receiver correctly, but when is submitted to the App, it returns the assignment blank for the correspondent rows. I tried to set the text value manually (both in the action with text characters and/or in the worksheet) and the App runs it perfectly. .
Is there something I’m missing out?