Answered

Help creating a flow to send an email in 90 days based on a completed date in SharePoint

(0) Share

Report

Posted on by DT-21011433-0

HI,

I have a flow that when someone sets the item to completed it adds a completed date of that day so UTC NOW(), I then want to create a flow that based on the completed date sends an email in 90 days asking the Project Lead to do something.

I created the below flow

The flow looks ok until I try to test it and I get the below error any help would be appreciated

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (2)

Sort by

Verified answer

Pstork1 69,397 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

You are missing the status value that you want to filter. Probably because the name of the date starts with 'Completed...' It should read

RAG_x0020_Status eq 'Completed' and Completed_x0020_...

----------------------------------------------------------------------------------
If this Post helped you, please click "Does this answer your question" and give it a like to help others in the community find the answer too!

Paul Papanek Stork, MVP
Blog: https://www.dontpapanic.com/blog

Was this reply helpful? Yes No
Verified answer

DT-21011433-0 16 on at

Like (0)

Report
Copy link

Link copied!

I realised I had missed the Completed value out, so added it but then came up saying the fields were not valid. The share point list view showed a space but the field value doesn't .

Was this reply helpful? Yes No
Pstork1 69,397 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

The space versus no space is the difference between the internal column name and the display name. That's a common issue.

----------------------------------------------------------------------------------
If this Post helped you, please click "Does this answer your question" and give it a like to help others in the community find the answer too!

Paul Papanek Stork, MVP
Blog: https://www.dontpapanic.com/blog

Was this reply helpful? Yes No