web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Do Until not be correct
Power Automate
Answered

Do Until not be correct

(0) ShareShare
ReportReport
Posted on by 26

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:

 

flow_1.pngflow_2.pngflow_3.pngflow_4.pngflow_5.pngflow_6.png

flow_1.png

 

 

 

 

 

 

 

 

 

 

 

for the best Example i add a running flow with content to it.

start when create new entry in calandar

 

1_Start date.png

 

2_End Date.png

Variable intialize

 

3_init Variable.png

 

4-init Variable 2.png

 

 

5_compose 4.png

 

6_declaration Variable.png

 

7_do until_1.png

here is my problem, the loop does not recognize the termination point

8_do until_2.png

 

9-array filter .png

 

10_Bedingung.png

Thus, the conditions are also not correct and he runs into the approval.
Does anyone have an idea why this might be.

 

 

 

 

Categories:
I have the same question (0)
  • v-zhos-msft Profile Picture
    on at

    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.

    formatDateTime(triggerBody()?['EventDate'],'yyyy-MM-dd HH:mm:ss')
    formatDateTime(triggerBody()?['EndDate'],'yyyy-MM-dd HH:mm:ss')
    The expression in Compose 3 and  Compose 4 are: to get the original time.
    convertToUtc(outputs('Compose'),'China Standard Time')
    convertToUtc(outputs('Compose_2'),'China Standard Time')
    The expression in Compose 5: to add 5 days to Start time.
    addDays(outputs('Compose_3'),5)

    Capture.PNGCapture1.PNG

    Best Regards,

    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

  • Verified answer
    pit850 Profile Picture
    26 on at

    Thanks for your Support, 

    I think I was a little bit awkward.
    Now he is running

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 503 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 321 Moderator

#3
abm abm Profile Picture

abm abm 237 Most Valuable Professional

Last 30 days Overall leaderboard