Contents
How to run a flow using a calculated date field?
Could you please show the name of the column contains ” Revalidation “, the RevalidationDate in input just a fake name for test, it should append the real name of the SharePoint column. If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
When does the calculated column Say ” Yes “?
I am trying to make a Flow that sends an email when the Calculated Column (Test) says “Yes” but no matter what i write in conditions it always gives “false” status when testing. @equals (triggerBody ()?
How to calculate the number of days in a flow?
If flow figure out 330 days that would be great. We have a SharePoint Library with 4,000 Word documents. Some of them get updated/modified frequently, some of them don’t. We want to make sure each document is reviewed/revalidated at least once a year.
The error suggests that you are not referring to the correct column, as Matiur Rahman mentioned. If you can return “Not Found” for all columns, it suggests that the formula is working fine. Change the field name in your formula and see the result. I figured it out!
How to get Microsoft Flow to update column?
So the trick is to get Microsoft Flow to update the column every night to keep the calculation correct. To create the MS Flow that will update the column, you need the “Send an HTTP request to SharePoint” action. In this example I have a calculated column on a tasklist. The Column is called “CalcToday”.
How to use formatdatetime in a flow?
The formatDateTime expression requires the date and time to be cast as a string in order for it to work, whereas when the date comes back from SharePoint it is a datetime data type. A simple update to the expression that @v-litu-msft posted should help you out:
The aspect that puzzles me is why you are using a calculated column for the revalidation date in your SharePoint list column. You don’t need to: an ordinary date/time column would be sufficient with the calculation/date comparison done within a PowerAutomate expression.