Hi guys,
I have a List on Sharepoint which contains a Date/Hour field and a Person field from our company users.
I need a flow that send an email to each user with the datas of the record where the field Date/Hour is "tomorrow".
Can you help, please?
Thanks in advance.
@PowerRanger sure,
that's it:
this is the field of the data source:
I've already tried to change the expression to dd-MM-yyyy, dd/MM/yyyy, dd/MM/yyyy hh:mm.... nothing works
@asanz could you provide a screenshot of your Action as well as of the expression you are using.
Hi @PowerRanger , your solution is not working...
Expression "Data App.to eq '03/09/2022'" not valid. Creating query failed.
clientRequestId: 6faa337f-c13d-4a3c-a896-e14ac27927f6
serviceRequestId: 6faa337f-c13d-4a3c-a896-e14ac27927f6
Can you help?
@asanz use the Get Items action and apply a Filter Query
The Syntax will be:
ColumnName eq 'expression'
(The expression must be put in single quotes)
The expression is: addDays(utcNow(),1,'yyyy-MM-dd')
This will get all items where the specified date column is set for tomorrow.
Michael E. Gernaey
497
Super User 2025 Season 1
David_MA
436
Super User 2025 Season 1
Riyaz_riz11
244
Super User 2025 Season 1