hi
I am struggling to create a flow that will do the following:
- send an email daily by scanning the online Excel spreadsheet (specific date column) and sending it to the cells containing the same date as today's date.
thanks in advance
Hi @N53,
1). You refer to the Date here, however you refer to date in the filter query of the list rows present in a table, please pay attention here to troubleshoot.
2). The DateField in my excel table named Date, and it is a Date column format using "/" as below:
So I formate it to match to the ISO8601 as:
formatDateTime(utcNow(),'yyyy/MM/dd')
Here you should compare it with your scenario, if you use "-", you should modify it as formatDateTime(utcNow(),'yyyy-MM-dd')
Hi @N53,
Please show me the configuration of the list rows present in a table and show me the completed formula you write for the filter query in this action.
thanks, I have followed all your steps but having no luck
Hi @N53,
@N53 wrote:
hi
formatting in the spreadsheet (source data) is same as 'yyyy-MM-dd'.
how does the flow know which column to look for the date to match the todays date?
We need to hard code it, which means you should enter the following in the filter query:
DateField eq <date_formula>
What's more, I don't know how you write the formula.
Please DO check my first reply and write the filter query as I mentioned in the list rows present in a table.
hi
formatting in the spreadsheet (source data) is same as 'yyyy-MM-dd'.
how does the flow know which column to look for the date to match the todays date?
Hi @N53,
Please post a clear scrrenshot, I could not capture the error from this blurred one.
Further, if the error is related to the date format, please do check my formula and keep the date format as ISO8601, which expects the date as 'yyyy-MM-dd'.
this was the error code when i used your flow
Michael E. Gernaey
497
Super User 2025 Season 2
David_MA
436
Super User 2025 Season 2
Riyaz_riz11
244
Super User 2025 Season 2