Answered

Output of a filter array in a apply to each

Like (1) Share

Report

Posted on 18 Apr 2023 09:54:30 by Scherodan

Hi All,

sry but I struggel how to use the filter array output in my apply to each loop. The filter array at least showing me the right results but how do I loop through them to check if an item exist and if yes add information to this.

Thx you in advance (sorry screenshot parily in German)

All responses (6)

Answers (1)

Scherodan on 18 Apr 2023 at 15:28:56

Like (1)

Report

Re: Output of a filter array in a apply to each

@abm now I got it and it really works very well! Thx a lot! You make my day!
Verified answer

abm abm 32,506 Most Valuable Professional on 18 Apr 2023 at 12:11:49

Like (1)

Report

Re: Output of a filter array in a apply to each

See above Body
Scherodan on 18 Apr 2023 at 11:42:54

Like (0)

Report

Re: Output of a filter array in a apply to each

@abm thx you.

But may I ask if I understand it right. In the dynamic content I only see two values to choose for filter array - Element and Text. Which should I use?

And afterwards you mentioned to set a compose action and use the expression item() to get a single Array to run through?
abm abm 32,506 Most Valuable Professional on 18 Apr 2023 at 10:52:32

Like (0)

Report

Re: Output of a filter array in a apply to each

Hi @Scherodan

Thanks for your reply. After the filter array add an apply to each and map the output body of the filter array step.

Then inside the array add a compose action step then use expression item() to get each value from the filter array.
Scherodan on 18 Apr 2023 at 10:45:32

Like (1)

Report

Re: Output of a filter array in a apply to each

@abm thx for your reply.

At least the apply to each steps in the screenshots now comes from power automate when I try to run an apply to each on teh dynamic content "element" of the filter array. PA add automatically an apply to each above contain "body" of filter array.

What I "simple" like to archive is - list rows in present table - filter the listet rows on a specific date logic (using filter array - which works) - than run a apply to each on the output to check and update sharepoint list items.

Thx Martin
abm abm 32,506 Most Valuable Professional on 18 Apr 2023 at 10:19:33

Like (0)

Report

Re: Output of a filter array in a apply to each

Hi @Scherodan

Could you please explain your second step filter array? What you trying to filter and what you want to do with the results after?

Thanks