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

Announcements

News and Announcements icon
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
    Microsoft Employee 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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 251 Super User 2026 Season 1

#2
Haque Profile Picture

Haque 239

#3
Expiscornovus Profile Picture

Expiscornovus 220 Most Valuable Professional

Last 30 days Overall leaderboard