You’re offline. This is a read only version of the page.
2
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
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.
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
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.
#1
Michael E. Gernaey
497
Super User 2025 Season 1
#2
David_MA
436
Super User 2025 Season 1
#3
Riyaz_riz11
244
Super User 2025 Season 1
Share
Report
All responses (
Answers (
