Creating a Distinct Value List from a Local Reccord List Column Values


I'm having a problem trying to create a new list based on a column of a existing record list. 

I couldn't find a function or widget that would help me, so I tried to create it myself but I'm having a problem:

Invalid Preparation Flow
Ambiguous paths to For Each in Preparation.

Any idea on how to create this feature?



Hi Filipe.

Im not sure what you are trying to accomplish, but i think it might be easier if you create an user action where you put the second "for each" logic. Then you can pass a record(from the first "for each") as an input parameter, and then retrieve a record or recordList as a result of the user action, and append it to the list.

There might be an easier way to do it, but you would have to explain better what is inside the logic of the two "for each". Ideally you should try to avoid using a for each inside another for each performance-wise.

Best regards,

Bruno Guedes



I am not sure what you are trying to accomplish, but the error occurs because the 2nd For Each is interrupted (via the true path of the if statement). If you adjust your logic so the second For Each is completed, than the error will disappear (see example image below).