cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Thyrome
Regular Visitor

Multiple scheduled emails from excel sheet by date time with email, subject and text

Hello everybody,

any help leading to realize the following flow is much appreciated.

 

Goal: send emails according to date and time listed in a spreadsheet with email address, subject and body as in same row of date and time

 

Input basis: excel spreadsheet with the column date, time, email adress, subject, text  -> located on onedrive

Thyrome_0-1618423939619.png

 

Thyrome_4-1618423806181.png

sending an email at the according time

including information from the same row like email adress subject and text

 

would be happy if anyone could steer my thoughts in the right directions 🙂

 

stay safe and sane,

Christian

 

3 REPLIES 3
Pstork1
Dual Super User
Dual Super User

You look like you are close, but I would suggest a couple changes.

1) Don't run the recurrence every minute.  I would extend that out to 5 or 10 minutes.  A slightly slower schedule will actually make it work better without overwhelming the system.

2) Use a filter array to filter out any rows where the time is less than the start time of the flow or greater than the start time of the flow plus 5-10 minutes (whatever you set the recurrence to)

3) Now the output of the filter array will have only the records where emails need to be sent by this run of the flow. 

4) Run the output through a Parse JSON action to gain access to the individual fields in the output.

5) Use apply to each to send one email for each remaining row.



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Thyrome
Regular Visitor

somehow managed to do it:

Thyrome_0-1618849702473.png

Solution:

I split date and time in the excel spreadsheed

and for the conditions I used these two in an AND connection

formatDateTime(utcnow(),'dd.MM.yyyy')
formatDateTime(utcnow(),'HH:mm')

 

hope this helps others too

 

 

thank you for your hints. they gave me the momentum to continue on this project.

my skills are beginnger so I was unable to do it via parse JSON action

 

 

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (3,161)