Power Platform Community Forum Thread Details

Hi,

I am trying to set up a manually triggered flow where I want to send out a notification email to certain email-adresses based on document metadata in a sharepoint library. These email-adresses correspond to tags I have set up in a multiple choice column in that sharepoint library. The flow should work if a document only has one tag in the multiple choice column as well as multiple tags.

I can trigger the notification E-Mail if I only set up one condition (yes/no) to be true, but when I add one more, referring to the value(s) in the multiple choice column it doesn't work.

I tried some solutions but none of them worked. I will attach screenshots that show from where I started.

Any help is appreciated!

Dominique

Categories:

Building flows

The logic of your flow needs to be adjusted. You have two Apply to Each loops that are independent of each other. To see the full flow and the logic behind it—toggle off the new designer and in edit mode, click on each action to expand it. Upload a screenshot of your full flow.

Fun fact. The Get Files (properties only) returns folders as well. You need to use a Filter Query to return Files only. Refer to this YT Short. This action will return a max of 100 files and folders unless you toggle on pagination.

It's also inefficient to use an Apply to Each action (aka For Each) to loop through each file and folder and run a condition check. Use a Filter Array action instead to filter out the files that you want to loop through first.

In the meantime, might be interested in these YT Tutorials:

Are you using the Microsoft Power Automate Filter Array Action wrong?

In this video tutorial I’ll show you 3 practical ways to use the Filter Array action and how to use it properly.
1️⃣ Cross-Referencing Data
2️⃣ Filtering by Key
3️⃣ Substring Matching

Did you know that the Condition action has a limit of 10 conditions? Although it might look like the Filter Array action can only accept one condition—this is not true. By using the advanced mode you can enter multiple conditions into a Filter Array action with an expression.

IN THIS VIDEO:
✓ 3 Ways to Use the Filter Array Action
✓ How to use the Scope Action to Group Actions
✓ How to Check the Number of Items returned from a Filter Array Action
✓ How to Cross-Reference Data in Excel with a SharePoint List
✓ How the Filter Array Action Works
✓ How to Access the Dynamic Content from a Filter Array Action
✓ How to Filter Items by a Key
✓ How to Filter Items by Matching a Substring
✓ How to Use Multiple Conditions in a Filter Array Action

---

Filter Array + Apply to Each: The Best Tip You Need to Know

In this tutorial—I’m going to show you a quicker way to get the dynamic content from your Filter Array action—and it doesn’t require writing an expression.

IN THIS VIDEO:
✓ How to Loop Through Filter Array Results in Power Automate
✓ Using Apply to Each with Filtered Arrays
✓ The Easiest Way to Access Dynamic Content from Filter Array
✓ Fixing Nested Apply to Each Actions
✓ When to Use Value vs. Body Dynamic Content
✓ Simplifying Power Automate Flows with Filter Array
✓ Troubleshooting Filter Array and Apply to Each Issues

---

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.

IN THIS VIDEO:
✓ 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!

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