@KM-03121436-0 You might be interested in the YT Tutorial down below. Although I cover how to email multiple SharePoint items, you can apply the concepts covered in the tutorial to your flow as the
List Rows Present in a Table will return an array of items (similar to the
Get Items action).
The List Rows Present in a Table action can accept a single condition in the Filter Query field. You'll just need to ensure that the column header in your Excel file does not include spaces. If you need to filter by more than one condition, you can use a Filter Array action. I've linked a couple of videos on that action below.
If you still run into issues while you are building your flow, ensure you upload a screenshot of your flow. Toggle off the New Designer and click each action to expand it. Upload a screenshot of your flow in edit mode.
How to Send a SINGLE EMAIL ✉️ with multiple SharePoint list items
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
----
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
---
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
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
Share
Report
All responses (
Answers (
10,502
