I have a little problem with my flow and hope someone can help me.
The workflow is started as soon as someone adds a new entry in the calendar.
Captured are Start and End.
He should pay the days and put in a variable.
For more than 5 days an approval should be started. For less than 5 days, the entry should be added.
Unfortunately, he does not work the way I would like to.
As seen in the example, the loop runs for 4 days longer than it has to and thus goes into the Approval.
What am I doing wrong.
here my flow:
for the best Example i add a running flow with content to it.
start when create new entry in calandar
here is my problem, the loop does not recognize the termination point
Solved! Go to Solution.
Hi @pit850 ,
First, when you add the date from Sharepoint to flow, the time zone will changed from UTC to your location.
So I am afraid you need to convert the date to UTC to get the original time.
I suggest you add 5 days to the Start time, then check the date whether greater than End time.
I have made a test on my side, please take a try with the following workaround:
The expression in Compose and Compose 2 are: to format the date.
Community Support Team _ Zhongys
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.