cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
M_Chapman
New Member

Trigger a Flow Based on SharePoint Date Field

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.

 

2021-01-21_17-07-37.png2021-01-21_17-09-32.png

5 REPLIES 5
Mira_Ghaly
Dual Super User II
Dual Super User II

@M_Chapman 

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.

Mira_Ghaly_0-1611284340850.png

 

 

If this post helps you with your problem, please mark your as Accepted solution.If you like my response, please give it a Thumbs Up.

Blog: here

You may need to convert the formatted date to a string. Try running the flow using a test of the current date and see if it works. 

M_Chapman
New Member

S

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.
clientRequestId: 6b40c9d3-9c19-430d-bbfd-e03c91e1b922
serviceRequestId: 6b40c9d3-9c19-430d-bbfd-e03c91e1b922

 

filter format.png

@M_Chapman 

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.

 

If this post helps you with your problem, please mark your as Accepted solution.If you like my response, please give it a Thumbs Up.

Blog: here

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Users online (1,014)