Power Platform Community Forum Thread Details

Setting up recurring flow so that it only sends emails to new additions

I am working through the Microsoft training modules and went through the training module that covers setting up a recurring flow.

Exercise - Create recurring flows - Training | Microsoft Learn

What I am looking to do is create a recurring flow that refers to a table and sends emails,, but ONLY to newly added users. The notes in the training module seem to imply that this is how recurring flows work. Per the instructions:

This flow will now run once a day. It will:

Get the new rows from the Excel worksheet
Grab the email address and name from each row

In my testing, it sends to every email on the table with every recurrence. Not just the newly added ones. Is there an easy way to set up the flow to only send to new additions?

@BKayMDOT Do you have a column in your Excel table that indicates when the new row was added? You will need a way to filter out the newly added rows.

You might find this YT Tutorial helpful:How to Send a SINGLE EMAIL ✉️ with multiple SharePoint list items | Build THIS Power Automate Flow

In this tutorial I cover:

✅ 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

Although this tutorial covers how to send a single email with multiple SP list items—the same concept can be applied when working with the List Rows Present in a table option. Please note that the List Rows Present in a table option can only take a single Filter Query argument. If you require more than one argument you will need to use a Filter Array action. To learn more about how to use the Filter Array action, please refer to this YT Tutorial I uploaded.

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! If you're feeling generous— ☕️ Buy me a coffee: https://www.buymeacoffee.com/acreativeopinion

👉 Watch my tutorials on YouTube
👉 Tips and Tricks on TikTok

Quick Links

Leaderboard > Power Automate