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