Unanswered

Apply to Each Filter Array or?

(0) Share

Report

Posted on by PepZ

I have a flow where I get a list from a table and then filter it out per team and then send that filtered table to the team leader via Teams.

However, I do this one-by-one and filter it out by team leader name and then manually enter the recipients name(email address). So, if I have 5 team leaders, I have 5 flows working to cater to each.

Is there a way to only have 1 flow running for all team leaders by using "Apply to Each" on the "Filter Array" or any other way?

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (0)

Sort by

creativeopinion 10,508 Moderator on at

Like (0)

Report
Copy link

Link copied!

@PepZ You are using the When an item or file is modified trigger. Can you provide more insights on why you are using this particular trigger? I can't tell from your flow where you are using the dynamic content from this flow trigger in the rest of your actions.

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!

👉 Level up your Power Automate skills by checking out my tutorials on YouTube
👉 Tips and Tricks on TikTok and Instagram

Was this reply helpful? Yes No
PepZ 10 on at

Like (0)

Report
Copy link

Link copied!

I'm not sure if it matters but it is a shared file where it's updated bi-hourly and the data that is used in the flow is dependent on what's on that file.

Was this reply helpful? Yes No
creativeopinion 10,508 Moderator on at

Like (0)

Report
Copy link

Link copied!

@PepZ Okay no worries. Could you pls expand all the actions and add a screenshot of that. I'd like to review what you have so far.

Was this reply helpful? Yes No
PepZ 10 on at

Like (0)

Report
Copy link

Link copied!

Was this reply helpful? Yes No
creativeopinion 10,508 Moderator on at

Like (0)

Report
Copy link

Link copied!

@PepZ The Filter Array doesn't look like it's necessary in your flow. You should be able to use the Filter Query field in the List Rows present in a table action instead. Tip: Rename your actions to keep your flow organized.

Return Count

Whenever I use a Filter Query in a List Rows Present in a Table action, I always like to return the count of items returned in a Compose action. This is helpful when building a flow and can also be used to troubleshoot your flow.

Insert a Compose action. Add an Expression. Use the length() function.

Select the Dynamic content tab and insert the body dynamic content from the Filter Array action into the length() function.

Condition Check

Add a Condition action to your flow. If items have returned (aka there is number stored in the Compose action—that is not equal to 0), add the rest of your actions to the Yes branch. If not, do nothing.

... more to come..

Does the Excel table contain the email of the team lead? Or is there another table or SharePoint list where this information is stored?

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!

👉 Level up your Power Automate skills by checking out my tutorials on YouTube
👉 Tips and Tricks on TikTok and Instagram

Was this reply helpful? Yes No
PepZ 10 on at

Like (0)

Report
Copy link

Link copied!
I'll try your suggested solutions today however...
I tried using the filter query field but it will just show the value that is filtered(e.g. only Team A will be shown). On my original question, I want it to be dynamic and be filtered per team and send it to each team leader. Hence, my solution to first make a filter array and try to apply to each team/team leader(which I'm still not successful).
I don't get the point of the return count/condition check. Can you expound on that?
Apologies, I'm just a newbie on Power Automate and this is actually overwhelming.

Was this reply helpful? Yes No