Unanswered

Apply to Each object/string in a union (Compose)

(0) Share

Report

Posted on by dwalker97

I have got unique rows from column 'InquiryID' by a union expression in Compose step.

I now want to loop through each of these unique ID's by using the output of this compose, but I have not found the correct way to.

This is what my steps look like, when ran they work correct and give the correct output -

I would like to reference each individual ID in a for-each loop as I will be cross-referencing these with another table. How do i reference each item of this union?

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Paulie78 8,422 Moderator on at

Like (1)

Report
create a for each loop with your union as the source and you can reference it within the loop using:

item()['InquiryID']

As you only have one property in your array, you can make it even easier by putting the select action into text mode, and the put the InquiryID into the map. Then you will have a plain array of InquiryIDs, then perform your union again.

If you do that, in your apply/each, it will simply be item()

Was this reply helpful? Yes No
dwalker97 82 on at

Like (0)

Report

Perfect, that worked.

Thanks!

Was this reply helpful? Yes No