Unanswered

Creating customer reminders for events in Google caledar

(0) Share

Report

Posted on by JustANewMember

Sorry, if posting not on the right board.

My aim is to create SMS and E-mail reminders for my customers before their appointments. I have already found a way to book online these appointments and that system generates events in Google calendar like this:

Title: Appointment for Customer 00000000000000 <phone number

...

Start...

Ends...

...

Description:

Client's phone number: 000000000000000

Client's email: ......@........

I have found some answers in this community how to read the description and create some reminders, but I still do not understand how to reference customer's email and send the reminder to it. I know it is a lot to ask, but would it be possible for someone to suggest a flow that would provide such reminders?

Many thanks,

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

v-yamao-msft on at

Like (0)

Report
Hi @JustANewMember,

From the description of an event, to get the email address of the client, send an email to the customer, we could try the following to achieve it.

Say your description is formatted as:

For testing, I used the trigger When an event is added to a calendar.

Adding an action Html to text to convert the description of the event to text.

Adding a Compose action to get the length of the text:

length(body('Html_to_text'))

Adding Compose2 to return the starting position of the string:

indexOf(body('Html_to_text'),'Client email')

Adding Compose3 to get the starting position of the email address:

add(outputs('Compose_2'),13)

Adding Conpose4 to get the email address:

substring(body('Html_to_text'),outputs('Compose_3'),sub(outputs('Compose'),outputs('Compose_3')))

Then in the action Send an email, use the output of Compose4 in the email field, sending an email to the client.

Please take the above flow for a reference and have a try with it on your side.

More details about the workflow definition language:

https://docs.microsoft.com/en-us/azure/logic-apps/workflow-definition-language-functions-reference#substring

Best regards,

Mabel Mao

Was this reply helpful? Yes No
JustANewMember 8 on at

Like (0)

Report

Thank you for help and the link, I get now how the functions work. However, I have tried this method and I have changed those numbers but all the time I do not get the substring to work. It did not provide a correct email, so I tried emailing myself and putting the output from previous Compose steps in the main body, but it just gives me in the final email the actual expression: substring(...) instead of some innacurate email adress or a different string from the description of the event. I have also noticed that when I try to reference values previous Compose steps in the Send an email step, I always have to choose See more option as it thinks that the field in which I am writing is of a different type. Is there any step that could fix this and give me at least incorrect values in the email instead of just the formula?

Thanks,

Was this reply helpful? Yes No
JustANewMember 8 on at

Like (0)

Report

Sorry for bothering, but I have just found that I have to put all my functions into the Expression field and press OK. It all seems to be working now. Thank you!

Was this reply helpful? Yes No