Skip to main content

Notifications

Community site session details

Community site session details

Session Id : roxwambX9pk8HYx4gX4u0i
Power Automate - Building Flows
Unanswered

Create a row in excel when an event is created in outlook

Like (0) ShareShare
ReportReport
Posted on 18 Mar 2022 11:15:30 by 6

Hi,

 

I am trying to create a flow so that I can track MS Bookings in Excel.

 

I can't set up an automatic flow from Bookings so the next idea is to create a list in excel that is continually updated every time a Booking is made in my calender. Basically I want every new calender entry to pop up in an Excel sheet in my Sharepoint. Then I can sort out the ones that are done by the Booking system using the Meeting Organiser field to sort.

 

Has anyone done this? Thanks so much for anyone who can provide help!

  • KvB1 Profile Picture
    1,596 on 19 Mar 2022 at 10:36:17
    Re: Create a row in excel when an event is created in outlook

    You would use this in your flow, instead of the dynamic content offered to you to fill the row in the excel table

  • jennyr Profile Picture
    6 on 18 Mar 2022 at 21:40:06
    Re: Create a row in excel when an event is created in outlook

    Thank you! Where do I put that formula in the Excel? Or in the power automation...??

  • KvB1 Profile Picture
    1,596 on 18 Mar 2022 at 13:08:34
    Re: Create a row in excel when an event is created in outlook

    Yeah this is the default date time format

     

    You can play around with the formatdatetime expression a bit, something like:

    formatDateTime(triggerOutputs()?['body/start'],'dd-MM-yyyy hh:mm')

  • jennyr Profile Picture
    6 on 18 Mar 2022 at 12:58:03
    Re: Create a row in excel when an event is created in outlook

    🙂 thanks I found a template where it was exporting to planner so just deleted the planner step and added in Excel and was off and running. It is a bit tricky working out the right 'dynamic fields' from outlook to go into the excel columns - getting a lot of rubbish out i.e. the Start Date and End Date are non-sensical! Any ideas welcome!

    jennyr_0-1647608272587.png

     

  • KvB1 Profile Picture
    1,596 on 18 Mar 2022 at 12:48:24
    Re: Create a row in excel when an event is created in outlook

    Nice to hear you gave it a crack ^^ Is it working the way you want it to?

  • jennyr Profile Picture
    6 on 18 Mar 2022 at 12:42:57
    Re: Create a row in excel when an event is created in outlook

    Thanks KvB1 I have kept playing and ended up with this Screenshot 2022-03-18 234150.png

     

     

     

  • KvB1 Profile Picture
    1,596 on 18 Mar 2022 at 11:27:55
    Re: Create a row in excel when an event is created in outlook

    Did you try using the 'add row to table' action?

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

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Automate - Building Flows

#1
stampcoin Profile Picture

stampcoin 14

#2
Churchy Profile Picture

Churchy 12

#3
rzaneti Profile Picture

rzaneti 8 Super User 2025 Season 1

Overall leaderboard