Unanswered

Apply to each by Filter Array output

(0) Share

Report

Posted on by KarimMomo

Hi,

I have trouble with a workflow. My workflow currently retrieves all the taxes from a table (List rows). It then filters the array based on the state/province retrieved earlier in the flow (Filter Array). One of the output is a state Province: "mis_taxstateprovince": 913210010 and the tax mis_federaleffectiverate": 0.05

Now, I want to apply the tax of this specific state/province in the Quote table. Here's the issue, It applies all the tax I have in my filter array condition. It goes through row by row and applies it until it reaches the last row of the table.

How can I make it so it applies only the specific state/province I've returned in the Ouput of my array instead of the input.

Thank you

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

creativeopinion 10,502 Super User 2025 Season 2 on at

Like (0)

Report

You are looping through the items returned from the List Rows action. Instead, you should be looping through the items returned from the Filter Array action.

In the Apply to Each action you need to insert the body outputs from the Filter Array action. Those are the items you need to loop through.

To access the content in the Filter Array, you need to use an expression.

I have a TikTok I recently uploaded that covers how to properly use the Filter Array action.

Hope this helps!

If I helped you solve your problem—please mark my post as a solution ✅.
Consider giving me a 👍 if you liked my response!

👉Watch my tutorials on YouTube
👉Tips and Tricks on TikTok

Was this reply helpful? Yes No
KarimMomo 32 on at

Like (0)

Report

Hi,

Thanks for this !! I'm at the point where I'm getting the appropriate outputs and the flow runs successfully: mis_cpqfederaltax": 0.05

However, the value is not updating the value in the Form is not updating accordingly:
What would cause this issue ?

Thank you

Was this reply helpful? Yes No
creativeopinion 10,502 Super User 2025 Season 2 on at

Like (0)

Report

Can you please upload a screenshot from the part of your flow that isn't working. It would be helpful to see a screenshot of the flow in edit mode as well as the outputs from your last run.

Was this reply helpful? Yes No
PoopOnMyShoe 2 on at

Like (0)

Report

If anyone else is looking for an answer to this without visiting TikTok.

After the Filter array action
Add an Apply to each action -
body('Filter_array')
In the Apply to each, add a Compose action and use this expression:
items('Apply_to_each')?['Your Field']

not-tiktok-virus.png

Was this reply helpful? Yes No