I am trying to create a simple condition that does things different depending on the date submitted (field in SharePont) + 5 days. I would rather do business days, but that looks far more complex to calculate. The condition that I have setup that isn't working is:
Expected Date (field in SharePoint list)
Is less than (condition)
Hi @DCurzio
Are you formatting the expected date in the format?
If you want to see the format expression value then add a compose step and set the expression formatDateTime(addDays(utcNow(), +5), 'MM/dd/yyyy'). Use the compose output to compare the value against the expected date. This way you can see the runtime values from the run history.
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Hi @DCurzio,
The date column format in the SharePoint is 'yyyy-MM-dd', so when comparing it with the utcNow + 5 days, the formate fuction should input 'yyyy-MM-dd', please follow as blew shows, use the formatDateTime(addDays(utcNow(), +5), 'yyyy-MM-dd') instead of formatDateTime(addDays(utcNow(), +5), 'MM/dd/yyyy').
Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @DCurzio,
Has your problem been solved?
If your problem has been solved, You could go ahead and mark the post as solved by clicking “Accept as Solution” so that this thread will be marked for other users to easily identify!
Best Regards,
Community Support Team _ Lin Tu
User | Count |
---|---|
65 | |
50 | |
47 | |
27 | |
17 |
User | Count |
---|---|
26 | |
26 | |
22 | |
20 | |
20 |