You’re offline. This is a read only version of the page.
Announcements
14
I have a Sharepoint list with a StartDate column formated as Date Only. I want to set up a Recurrance flow to run daily and check the value of the StartDate column for each item in the Sharepoint list and send an email for each item that the StartDate is less than Today.
I created a flow that runs daily and GETS the items from the Sharepoint list
Then Apply to Each using the VALUE output from the GET action
Then COMPOSE with the following inputs: @formatDateTime(@{items('Apply_to_each')?['StartDate']},'yyyy-MM-dd'
Then COMPOSE with the following inputs: @utcnow('yyyy-MM-dd')
Then CONDTION - @less(outputs('Compose'), outputs('Compose_2'))
Then IF YES - Send an email
The flow is working but it is sending an email for ALL items in the list including items with STARTDATE greater than today.
I have looked through similiar posts on this forum and the syntax appears to be correct but the results are not what i am expecting. What am I missing? Thank you.
Hi @EdKOffice365,
I think there is something wrong with your formula in first Compose action. I have made a test on my side and the flow works as you expected.
Please take a try to type the following formula in your first Compose action:
“@formatDateTime(item()?['StartDate'],'yyyy-MM-dd')”
Best regards,
Kris
Share
Report
All responses (
Answers (
