web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Automate
Suggested Answer

Multiple Filters

(1) ShareShare
ReportReport
Posted on by 14
I am trying to create a flow that starts with listing rows present in an excel table and then filters the information multiple times. The flow will end by sending an email on Mondays with a list of the tasks that are due that coming week AND the person(s) responsible are Person A, Person B, AND/OR Person C.
 
I am having issue with the multiple layers of filtering. Specifically, filtering for items that occur over the course of a week. And I am also having difficulty filtering for lines that are completed by for any of three people.
 
I am specifically having a hard time with using AND in Filter Query and Filter Array.
Categories:
I have the same question (0)
  • creativeopinion Profile Picture
    10,502 Super User 2025 Season 2 on at
    You might be interested in these YT Tutorials linked below. Although the tutorials cover how to send SharePoint List items, the concepts covered in the tutorials can be applied to your flow. 
     
    If you still run into issues with your flow after reviewing these tutorials, upload a screenshot of your full flow. If you are using the new designer, toggle it off and click each action to expand it. Upload a screenshot of your flow in edit mode, it would help to provide more insight.
     
     
    Building a Power Automate flow that will send an email with multiple SharePoint items can be a bit complex. In this video tutorial I’ll cover how to build a flow that will send a single email to each user with tasks that have been assigned to them. The logic in this flow can be applied to many different scenarios.
    First, I’ll show you how to use a Filter Query to return items from your SharePoint list that meet your criteria. Then I’ll show you how to return a list of unique email addresses so that each user receives a single email. Lastly I’ll show you how to compose an email that will contain an HTML table with a list of tasks for each user.
     
    IN THIS VIDEO:
    ✅ How to send multiple list items in a single email with a Power Automate Flow
    ✅ How to create a dynamic date range
    ✅ How to use the Convert Time Zone action
    ✅ How to use a Filter Query in the Get Items action
    ✅ How to count number of items in an array
    ✅ How to use the Select action to extract a users display name and email address
    ✅ How to create a unique list of email addresses
    ✅ How to use the Create HTML Table action
    ✅ How to customize the HTML Table with CSS styles
    ✅ How to use the Send an email (V2) action
    ✅ How to use the Append to String Variable action
    ✅ How to create a custom list of items for an email
    ✅ How to use the Send an email (V2) action
    ✅ How to display singular or plural text based on the number of items returned
     
    ----

    Do you want to know how to send an email to all users assigned to a SharePoint item? If so—this Power Automate tutorial is for YOU 🫵.
    However, that tutorial only covered a scenario where each task is assigned to a single user. What if your task is assigned to more than one user?
     
    In this Microsoft Power Automate tutorial I’ll cover how to create a flow that is triggered by selecting an item. This automation will send an email to all assigned users for the selected task. I’ll also show you how to adjust your flow so that you can send a message in Teams. Then I’ll show you how to collect a list of unique users that have been assigned to multi-person tasks. Using this concept, we’ll edit the flow from the previous tutorial so that it works with a multi-person column.
     
    IN THIS VIDEO:
    ✅  How to trigger a flow from a selected file
    ✅  How the multi-person column data outputs
    ✅  How to use the Select action to get all assigned to users of a SharePoint item
    ✅  How to use the Join action to convert an array of email addresses into a string
    ✅  How to send a single email to all assigned to users of a SharePoint item
    ✅  How to send an email to each assigned to user of a SharePoint item
    ✅  How to send a Teams message to each user assigned to a SharePoint item
    ✅  How to return a list of unique users from the multi-person column in a SharePoint list
    ✅  How to use a Filter Array action to return all SharePoint list items assigned to each user
    ✅  How to group Power Automate actions together with the Scope action
    ✅  How to edit a previous flow
     
     
    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
  • Suggested answer
    abc 123 Profile Picture
    784 Moderator on at
    Filter Array is one of the most difficult things to use, because the little advanced window is mostly useless.  With that, I craft the syntax in Notepad, copy it into the advanced window, and then hope.
     
    The and() function only accepts two parameters, so if more are needed, then you have to nest them. 
     
    x AND y
    and(x,y) 
     
    x AND y AND z
    and(z, and(x,y) )
     
    x AND y AND z AND r1
    and( and(z, r1), and(x,y) )
     
    Your desire for "Person A, Person B, AND/OR Person C". Is ambiguous, as I can't tell if only Person C has an OR condition, or if the OR applies to all. This is probably why you're having trouble resolving, because you're not properly defining it. 
     
    So, assuming that the use case is:
     
    Person A AND Person B OR Person C, then it would look like this:
    Or(Person C, and(Peraon A, Person B) )
     
    ---
     
    Sending a weekly email requires using a Recurrence trigger. Pretty simple. When I use them, I then use a Run a Child Flow to call the flow that need to execute each week. This way, you can trigger the child flow as needed, without having to force a change on the Recurrence.
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 501 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 323 Moderator

#3
abm abm Profile Picture

abm abm 237 Most Valuable Professional

Last 30 days Overall leaderboard