cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ABD01
Regular Visitor

Post upcoming events from Outlook calendar to Teams

I'm trying to create a flow that posts the upcoming events (Monday to Sunday) for the following week every Friday at 9:00am to Teams. I've managed most of it, but am having a couple of issues with the formatting and multi-day events.

 

ABD01_7-1660940970248.png

 

I'd like the events above to be presented as:

 

Monday

All day - ABD out

9:00AM to 10:00AM - Meeting

Tuesday

No events

Wednesday

All day - Book fair

Thursday

All day - Book fair

9:00AM to Friday 3:00PM - Residential

Friday

Thursday to 3:00PM - Residential

 

OR

 

DayTimeSubject
MondayAll dayABD out
 9:00AM - 10:00AMMeeting
Tuesday  
WednesdayAll dayBook fair
ThursdayAll dayBook fair
 9:00AM - FridayResidential
FridayThursday - 3:00PMResidential

(If using a table, it would be good if the borders were invisible)

 

I'm happy with minor variations in presentation if needed. The most important things are:

  • multi-day events should appear in the list every day (not just on the first day)
  • events should be grouped by day (so people can just look at a single group if they're in a rush)

 

So far, I've tried:

ABD01_0-1660940504845.png

 

ABD01_2-1660940571157.png

ABD01_3-1660940596787.png

From:

 

 

addDays(utcNow(),2,'yyyy-MM-ddT23:00:00Z')

 

 

To:

 

 

addDays(utcNow(),10,'yyyy-MM-ddT00:00:00Z')

 

 

ABD01_4-1660940688531.png

Day:

 

 

formatDateTime(item()?['Start'],'ddd')

 

 

Time:

 

 

formatDateTime(item()?['Start'],'h:mmtt')
formatDateTime(item()?['End'],'h:mmtt')

 

 

ABD01_5-1660940798159.png

ABD01_6-1660940821972.png

 

Any help would be greatly appreciated!

0 REPLIES 0

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (3,801)