Power Platform Community Forum Thread Details

Hi!

My team and I maintain certain Legal Entity Identifier (LEI) records and have been trying to automate email reminders to our shared inbox when it's time to renew them. I've tried following other tutorials which either fails or doesn't work as intended (sends 1 row per email).

Our records are listed in an excel spreadsheet with the table name - "ActiveLEIs" with column names - "FundName", "EntityName", "LEI", "LEIRegistrationExpires", "AdditionalComments", 'FirstReminder", "RenewalDate".

We'd like to set up the reminders to automatically send one big email to our "sharedmailbox@outlook.com" with an ODATA filter for "FirstReminder" field so that we can see all records that have the same date in this column without receiving separate emails for each. Whenever I use a subject line that reads " Upcoming LEI Renewal - ["LEIRegistrationExpires"] " , I find it immediately changes to "Apply to each".

May I please see a detailed step-by-step way to fix these reminders?

Categories:

Building flows

Hey,

the "apply to each" action automatically gets added if you want to use a variable that comes from an array of values. So because there are multiple rows in your excel file, Power Automate automatically adds the looping function (apply to each) for those rows for you. You can not change this behaviour...

What you can do is create a variable and store all the values from each row inside that variable and then when the Flow has finished looping all your rows, you can then add the variable to your email. So you have 1 email but all the data because it's all in the variable.

To do this, use the Initialize variable action and give the variable a name (for example AllInfos, but it doesn't matter what you call it) and select string as Type. Don't enter a value yet.

Then use the Append to string variable action and select the variable Name AllInfos from before and in the Value field, select the dynamic content ["LEIRegistrationExpires"] and a normal comma. This should automatically wrap the Append to string variable action in a Apply to each action. Now this loops and adds all LEIRegistrationExpires values to your variable.

Now just add the Send email action below! the apply to each, not inside it. And in the email you use the dynamic content variable AllInfos instead of the the ["LEIRegistrationExpires"].

This will then send only one email with all information.

cheers