Sending one email per person even with multiple entries

[juma_99]

Hello everyone,

I have created a recurring flow in which an end date is compared with today's date in an Excel and if they match, an email is automatically sent to the contact person from the Excel. However, some people receive several emails on the same day and I only want to send one email per person on each day with all data from Excel. In excel there are several lines listed with the respective end date, which is compared with today's date and several important dates that should be included in the emails. In the following you can see how I built my flow:

length(body('In_Tabelle_vorhandene_Zeilen_auflisten_3')?['value'])

For one thing, I now get an error message when I try to test the flow and I don't know what that means.

And on the other hand, I don't know yet what to enter in the email. Because I want it in the format as it is shown in the text and the date is in the correct format as I programmed it and on the other hand all contents should be listed in the email (output).

Can somebody help me here?

[tom_riha]

Hello @juma_99 ,

take a look on this article, it explains how to do it over SharePoint list. You'll have to use use 'List rows...' instead of 'Get items', but from then on it's the same approach.

[juma_99]

Hello @tom_riha,

thanks for your answer: I did it as described in the article, however I still get the error message:

Let me show you how I created my flow:

Do you know how I can solve this error?

[tom_riha · Accepted solution]

Hello @juma_99 ,

you should never have 2 inputs in the 'Apply to each', it should always be just 1 array, in your case the output from 'Verfassen'.