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!
You would use this in your flow, instead of the dynamic content offered to you to fill the row in the excel table
Thank you! Where do I put that formula in the Excel? Or in the power automation...??
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')
🙂 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!
Nice to hear you gave it a crack ^^ Is it working the way you want it to?
Thanks KvB1 I have kept playing and ended up with this
Did you try using the 'add row to table' action?
stampcoin
14
Churchy
12
rzaneti
8
Super User 2025 Season 1