Filter array not working

[Bosgraj]

Hello,

I have a problem with my Flow. This Flow sends an email to the Managers so that they receive a list of which employees are undergoing training at the time they are taking the training.

When compiling this list, the participants are selected and placed in an Array.

Then I want to filter this Array by location. Then I always get an empty Output.

It says that it cannot find the property.

What am I doing wrong and can you help me with this?

Regards,

Jacob

[VictorIvanidze]

Use item()?['location'] in the Filter array action.

[creativeopinion]

@Bosgraj I wouldn't recommend nesting a Get Items action inside an Apply to Each action. Instead, you should run the Get Items action outside of the Apply to Each. This way you aren't calling the Get Items action on the same SP List multiple times in your flow. Call it once, then use the Filter Array action to filter the items you need.

Can you share a full screenshot of your flow? In the meantime, please refer to this YT Tutorial for more information on the Filter Array action: Are you using the Microsoft Power Automate Filter Action wrong?

You might also find this tutorial helpful: 3 Mistakes YOU 🫵 are Making with the Apply to Each Action in your Microsoft Power Automate Flow

In this video tutorial I’ll go over how to avoid these common mistakes when using the Apply to Each action in a Power Automate flow:

1️⃣ Looping through a Single Item

2️⃣ Creating Unnecessary Nested Loops

3️⃣ Looping through an Unfiltered Array

At the end of the video I share a few helpful insights when it comes to using the Apply to Each action in your flow.

I'll also cover:

✅ How to avoid the Apply to Each action with a single item array

✅ How to use the item() function to access dynamic content in an array

✅ How to prevent unnecessary nested Apply to Each action loops

✅ How to use the Select action

✅ How to convert an array to a string with the Select action

✅How to use the Filter Query field

✅ How to count the number of items in an array

✅ How to use a condition control

✅ How to use the concurrency control

✅ How to set a top count

✅ How to use Compose actions for troubleshooting

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

[Bosgraj]

Thank you for the answer. But that did not solve the problem.

I stil get the error that it cannot find the location poperty.

[Bosgraj]

Thank you for you reply. I looked quick to you YT channel. Quit intresting.

In my Flow I must need info from 4 SPlists. That is why I got several Apply Each tot make the search smaller.

I made a ful screen shot from my Flow. 

I hope you can help me further.

[creativeopinion]

@Bosgraj That's an awful lot of variables you are using in your flow. I'm unclear on the purpose of the Get File Content action in your flow. Can you clearly outline your requirements in your flow? It looks like you are trying to return values from a 3 different SP lists. Can you provided more insights on how each list is connected to each other?

[Bosgraj · Accepted solution]

Hello,

That is certainly a lot of variables, but it is a flow in development.

I have now got the filtering working. I have added an extra Apply to each. This gives me a correct Array containing all participants and their location. This way I can send a letter to the managers of the different location so that they know which employees at this location are undergoing training.

I will definitely watch your videos to optimize this flow.

In any case, thanks for your advice.