Unanswered

Email on Date - Excel

(0) Share

Report

Posted on by Scott_Pullen

Afternoon,

I am trying to get a spreadsheet to send an email on a due date and then everyday if the date is not changed, I have looked around but this has multiple worksheets for different depots and for the life of me i cant get it to work.

If you could help or point me in the right direction that would be amazing.

Thank you

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

schwibach 2 Moderator on at

Like (0)

Report

You can build a flow with daily recurrence.

Then add an action "list rows in table".

Once you get the rows you can loop through each one and compare the ticks (it's a function that you can put into an expression that will give you an integer that you can compare) with the ticks of utcnow()

And for each line where ticks(utcnow()) is greater than ticks(yourdateinexcel), you send that email.

If it gives you trouble, feel free to post some screenshots of where you're having issues.

Was this reply helpful? Yes No
Scott_Pullen 2 on at

Like (0)

Report

Thank you for a fast reply, I am pretty new to this part of the kit. I have gone through a small amount and for some reason on the "table" section it is blank

Was this reply helpful? Yes No
David_MA 12,966 Super User 2025 Season 2 on at

Like (0)

Report

The first thing I would do is to make sure that your data is in an Excel table. If you are not sure how, just click on any row of your data. If you do not see the Table Design tab, then your data is not in a table, which is required for this action to work. If it is in a table, then go to the Table Design tab and on the far left, copy the table name under Table Name. You can then enter this as a custom value in the connection and it should work.

Was this reply helpful? Yes No