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

Community site session details

Session Id : WIeQw2Znc28naeKf+RTZs9
Power Automate - General Discussion
Unanswered

Flow - get calendar events over serveral days?

Like (0) ShareShare
ReportReport
Posted on 29 Oct 2019 06:39:09 by 1,095

I have a flow that post to teams a weekly-digest.

But i have a problem.... when someone have added an event that starts on Monday and ends on Thursday (for example).

Then i only get the start date and end daye, the day in between i dont get.....

 

My post to team looks like this:

 

[DAY] : [EVENT-TITLE]

 

The flow works great but i cant figure out how to get that day in between start and end date of an event that spans over several days.

 

Example:

If i have an event that starts on Monday. The event title is "EVENT123"

The event ends at Thursday.

 

Current flow would post this:

Monday: Event123

 

Then it ends. But i want this:

 

Monday: Event123

Thuseday: Event123

Wednsday: Event123

Thursday: Event123

 

But since an event only have an idicator on when it starts and when it ends i cant figure out how to make this work.

I also need the flow to work with events that happens on a single day.

 

 

 

 

  • Spamrancher Profile Picture
    345 on 04 Nov 2019 at 15:00:45
    Re: Flow - get calendar events over serveral days?

    Hey Oskarkuus,

     

    Wanting to see if your Flow is working now or if you need more help.

  • Spamrancher Profile Picture
    345 on 31 Oct 2019 at 16:19:07
    Re: Flow - get calendar events over serveral days?

    So, building off of Lin-Tu's Flow steps -- once you get the number of days between you can initialize a "Counter" variable and then use a Do Until to add the events with addDays(Counter) then increment the variable. Kind of like below.

     

    Flow Example.png

  • Oskarkuus Profile Picture
    1,095 on 31 Oct 2019 at 06:41:37
    Re: Flow - get calendar events over serveral days?

    Dont get it. How would this solve the issue to make a post where i get a printout for each day something happens....

     

    event is monday to friday

    i only have start and end date as indicators to play with.

    but i want an indicator so i get a post for not just the start-date or end-date

     

    monday - eventname

    tuseday - eventname

    wednsday - eventname.

    and so on....

     

     

  • v-litu-msft Profile Picture
    on 30 Oct 2019 at 01:52:42
    Re: Flow - get calendar events over serveral days?

    Hi @Oskarkuus,

     

    You can use the dayOfYear function to get the day number from start of year to timestamp, get the start date and end date, then use sub() function to get the diff between them.

    dayOfYear(triggerBody()?['Start'])
    dayOfYear(triggerBody()?['End'])
    sub(variables('EndTime'),variables('StartTime'))

    Annotation 2019-10-30 094625.png

     

    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.

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

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 2

Loading complete