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 / Microsoft Flow - Expor...
Power Automate
Answered

Microsoft Flow - Export events from sharepoint calendar "today + 5 days"

(0) ShareShare
ReportReport
Posted on by 1,097

Hi!

 

I hope someone can help me with a thing.
I have this line that i use to export Todays dates events from an sharepoint calendar.

This works really well!

EventDate ge datetime'@{formatDateTime(utcNow(),'yyyy-MM-dd')}T00:00:00' and EventDate le datetime'@{formatDateTime(utcNow(),'yyyy-MM-dd')}T23:59:59'


How would i change this one to make it extract all events from todays date and 5 days ahead.
So if it is monday morning. I want to extract all events from Monday, Tuesday, Wednesday, Thursday and Friday (5 days).

 

I have a flow that is triggered every monday morning.

I want to get all events from a calendar for the comming week (monday-friday).

 

How do i change above formula?

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

    Hi @Oskarkuus,

     

    You could change the formula as below:

    EventDate ge datetime'@{formatDateTime(utcNow(),'yyyy-MM-dd')}T00:00:00' and EventDate le datetime'@{formatDateTime(addDays(utcNow(),5),'yyyy-MM-dd')}T23:59:59'

     

    Best regards,

    Alice

  • Oskarkuus Profile Picture
    1,097 on at

    Thank you!

     

    But how do you make it so that the timestamp follows another timezone?

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 519 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 296 Moderator

#3
abm abm Profile Picture

abm abm 232 Most Valuable Professional

Last 30 days Overall leaderboard