Send customer questionnaire

[JBMac]

Good morning

I am looking to create a flow that sends a questionnaire to the customer 1-hour after the end of a session - the questionnaire is a simple Microsoft Forms form. The session is booked via Microsoft Bookings, as there is no connector for this I am attempting to use the calendar event that it generates as the trigger - the organizer will always be the email address I have setup on the Microsoft Bookings so that provides a simple condition to stop the flow running against other calendar entries (added additional filter against subject as well for now to test it does work for 1 session and not for another)

I want the flow to pickup the end time of the event and add 1 hour so started with a Compose with the Expression as:

formatDateTime(addHours(triggerOutputs()?['body/end'],1),'yyyy-MM-ddThh:mmZ')

I then use the Outputs in the Delay until timestamp

Then convert Html to text for the body of the calendar event (not sure if I need this?)

The email address is in the body of the calendar event so put this Expression in the Compose 2 Inputs:

first(skip(split(first(split(body('Html_to_text'),'Email')),':'),1))

(there is a space between Email: and the email address - do I need to account for that?)

Then send an email to the Outputs of Compose 2 with link to form

[JBMac]

Screenshot of event confirmation

[efialttes]

Humi!

So if the problem is 

"there is a space between Email: and the email address - do I need to account for that?"

...I would use trim() function to remove spaces at the beginning and at the end of your string

Hope this helps

[efialttes]

Hi!

Issue finally solved?

Thanx!

[JBMac]

Afraid not @efialttes 

The Delay until is working a treat now but the Compose 2 part is failing to pickup the email address from the HTML to text output

Formula for that is:

first(skip(split(first(split(body('Html_to_text'),TrimEnds('Email'))),':'),1))

This looks unnecessarily long to me 

[efialttes · Accepted solution]

Hi!

So it looks the email structure is always this, right?

Email: xxxx
Phone Number: yyyy

I am also assuming patterns Email: and Phone Number: will be present just once in your email body.

If so, I would try with the following expression

trim(first(split(last(split(body('Html_to_text'),'Email:')),'Phone Number:')))

Hope this helps

[JBMac]

That worked a treat, thank you @efialttes