How to use Power Automate to bring data from MS Bookings to SharePoint and finally Excel

[@Thiago-nm5df]

Hi François, I work for a company that offers employee transportation services. Currently, ten drivers handle these requests, scheduled through phone calls and emails. As the company undergoes workflow changes, we're encouraging everyone to use Microsoft Teams. After a phone or email booking, an employee creates a task(to do planner) in Teams and assigns it to a driver. Being new to the transportation sector, I noticed the potential of using bookings for appointments. However, since our company culture prioritizes Teams, I'm working on a Power Automate flow. Ideally, after an employee books a transport through MS Bookings, the flow would automatically create a Teams task for the assigned driver (chosen randomly based on availability). Unfortunately, I'm facing challenges. While I can create a Teams task upon booking, it lacks automatic driver assignment and content, leaving it blank. I sincerely appreciate your cooperation! Thank you for your time and effort.

[@digitalfrancois]

This requires a chat, send me a message, find my contacts in video description or channel info.

[@alexbury]

How do you actually get the excel part to work? Custom answers from bookings to excel in Power Automate seems unnecessarily tricky.

[@digitalfrancois]

true. First, get the details from Microsoft Bookings using Power Automate. Then, use the ‘Parse JSON’ action to break down the data, focusing on the field that contains the custom questions. Finally, map out the questions and responses so you can use them in your "create SP item".