I have a SharePoint list where I am trying to trigger a reminder email based on a date field in the list (Client Reminder Date). I have formatted the flow as follows and with other blog suggestion that I have found and still cannot get it to work. Any help would be greatly appreciated.
I suggest that on your Get Items use the Filter Expression as below instead of applying a condition and you can add inside UTCNow() ; the same format as the date is setup in sharepoint, so this saves you from retrieving all items and then filter them.
I like this idea. I tried and received the following message. Am I formatting the column name wrong?
The expression "Client_x0020_Reminder eq 2021-01-22T18:25:26.7459659Z" is not valid. Creating query failed.
If the column in sharepoint is with spaces then it looks right.. May be you need to add a date format inside UTCNow('dd/MM/yyyy') as well as adding a single columns like below
Client_x0020_Reminder eq 'UtcNow('dd/MM/yyyy')'
Let me know if this works for you , Make sure you supply the same date format.
Check out the News & Announcements to learn more.
Check out the new Power Platform Community Connections gallery!
Congratulations, the new Super User Season 2 for 2021 has started!
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.