
Announcements
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.
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
| Day | Time | Subject |
| Monday | All day | ABD out |
| 9:00AM - 10:00AM | Meeting | |
| Tuesday | ||
| Wednesday | All day | Book fair |
| Thursday | All day | Book fair |
| 9:00AM - Friday | Residential | |
| Friday | Thursday - 3:00PM | Residential |
(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:
So far, I've tried:
From:
addDays(utcNow(),2,'yyyy-MM-ddT23:00:00Z')
To:
addDays(utcNow(),10,'yyyy-MM-ddT00:00:00Z')
Day:
formatDateTime(item()?['Start'],'ddd')
Time:
formatDateTime(item()?['Start'],'h:mmtt')formatDateTime(item()?['End'],'h:mmtt')
Any help would be greatly appreciated!