cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Get Calendar Events v3 for individual team members and insert rows into excel file

Hi All,

 

i need some help please from persons that are infinity more clever that what i am 😁

 

Background: i need to get a consolidated view of our team members individual calendars. Using Outlook doesn't scale for 20 or more people. What we have been doing is each team member has been adding what they have planned for the day manually into an excel spreadsheet.  Spreadsheet has Date Column on the far left, with columns for each team member

 

What has been done: Create a flow that uses "Get Calendar Events (v3) runs 1 x per day, accesses each team members calendar (365) for 60 days in advance. Then we need to convert the time zone with (Convert Time Zone) and we filter out the time, so that we only have the date. Then we use the Excel (Business) Update a Row, to apply to each output, where it finds the date, and puts in the subject in the team members column.

 

Problem Statement: Team members have multiple appointments/events for a day, however this flow only updates the row with the last event of the day.

 

Expected Outcome: want to concat or combine or unify the events for a specific day into a single string, separated by semi-colons. this will help us to see what is planned for each person, and to use this when we are planning work, training, projects, etc.

 

any pointers or links to other posts will be very welcome

Screenshot 2020-10-14 at 14.56.37.pngScreenshot 2020-10-14 at 14.57.36.pngRegards Marc

0 REPLIES 0

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (3,466)