Updating a calendar event from an email

[lg81]

Hey, I am newish to Flow and looking for some help for what could be a massive time saver. 

We have a booking system that sends us an email when a booking is complete and I wanted to update our calendar events when another booking comes in. We may have 6-8 events per day, 5 days a week (each with a unique event name on that day, but that repeats during the week) so currently it is time consuming to update them with the customers names when a booking is complete. 

The email from the booking system has the same specific title for all events so i guess the Flow I am looking for would do the following

• Read the booking email and figure out the which existing calendar event it needs to update (it would have a matching event name,date and start time in the body of the email)
• Find in the body of the email the new customers name (the email is templated so the name is always in the same specific location)
• Add and save the new customer name in the body of the calendar event.   

Not 100% where to get started but no there are flows for email, updating events etc. 

Thanks in advance. 

[v-yuazh-msft]

Hi @lg81,

Could you please share more details about the booking email?

Could you please share more details about the relationship between booking email and existing calendar event?About the matching event name,date and start time in the body of the email?

Have you created a flow to achieve your needs?

Please take a try on your side to create the flow and you could share more details about the problem when you create the flow.

Best regards,

Alice

[lg81]

Thanks for the response.

Ok, so the email is just a templated standard booking response with the only changing details being the customer name, the session name, time and date. It does have a ICS attachment but that doesnt hold any customer details. Example is;

Booking Details:

Item

Details Booked session   Tue 26 Jun 11:30, 1 hour and 30 mins Quantity 1 Address 123 Fake Street Islington N1 1PP United Kingdom (View on map) Booking Reference 31860

Name	Lee Greenhalgh
Email	lee@gmail.com
Phone	+44 (0)7777 777777
Address	N10 10NN (View on map)

From a flow part ive started but not been successful,

• Starting with a "when new email arrives" in which i can add a specific email address and a specific subject filter as for every email they are the same
• Next i have something to scan the email for the calendar invite - the session name and start time/date. 
• Somethign to scan the email for the new customers name 
• Update Event V2 to input the name that it has already scanned. 

As i said im new to flow so the code for scanning the email body is the biggest challegne currently. 

Lee