You’re offline. This is a read only version of the page.
164
I have the below flow which compares sheets, pulls an array of items, filter out the nulls and then send me an email after it has been formatted in a table.
I'm trying to use a Select action like the one below to return the referenced row number where the item(s) was/were returned from.
Any ideas of a formula that would work in the Ref_Row value field which would allow me to return the placement number of the value(s) returned?
I managed to resolve this myself by implementing the steps below:
1. Initializing an integer variable set to 0.
2. Add a key column to the table (action) which creates the column.
3. Used an increment variable with the varName from step 1 and value set to 1.
4. Added an Update row action with Key Column and and Key Value set to another column with values, and add increment variable action to Row_Ref.
5. Added steps 3 and 4 in an Apply to each loop.
Share
Report
All responses (
Answers (
