cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
rlv
Level: Power Up

Email content triggers calendar invitation

Hi there-

 

I am trying to build a flow whereby the following occurs:

- A very specific sender sends an email to my outlook account AND

- If the body of the message includes the word "hospital" or "hospitalization", then a calendar event is automatically created 7 days from the date of the email.

 

Does that seem possible?

 

Thanks! 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Email content triggers calendar invitation

Hi @rlv 

Yes, that is a Compose, I have just named it that way.

 

If you have found my post helpful, please mark thumbs up.

 

If the above post has solved your problem, please click "Accept as Solution".

Any other questions, just ask.

Thanks, Alan


Did I answer your question? Mark my post as a solution!

Proud to be a Flownaut!


View solution in original post

5 REPLIES 5
Super User
Super User

Re: Email content triggers calendar invitation

Hi @rlv , thank you for posting your issue.

It is entirely possible (like most things in Flow) and here is how I have got it working.

Full Flow overview.

Capture-253.png

Now, let's build it. Start with the below, add your parameters to suit:Capture-254.png

Now onto capturing the body text and stripping out the HTML.Capture-255.png

Now split every word contained in the body to an individual word:Capture-256.png

split(body('Html_to_text'), ' ')

Now onto an apply to each that includes a condition:Capture-257.png

and to finish it off, outwith the "Apply to each" use "Create event (V2)" as below:Capture-258.png

Subject: 

addDays(utcNow(),7,'MM-dd-yyy')

Start time:

addDays(utcNow(),7,'MM-dd-yyy')

End time:

addDays(utcNow(),8,'MM-dd-yyy')

Please change the above to suit your date format, event title etc but this starts a calendar event called "Appointment 03-07-2019" based on todays date.

 

If you have found my post helpful, please mark thumbs up.

If this post has solved your problem, please click "Accept as Solution".

Any other questions, just ask.

Thanks, Alan


Did I answer your question? Mark my post as a solution!

Proud to be a Flownaut!


rlv
Level: Power Up

Re: Email content triggers calendar invitation

Hi @AlanPs1 -

 

Thank you for your quick reply. I have everything set up, but cannot seem to select "Compose Split Text"; I am only able to find a "Compose" action. How did you get these specific action?

 

Thank you again!

Super User
Super User

Re: Email content triggers calendar invitation

Hi @rlv 

Yes, that is a Compose, I have just named it that way.

 

If you have found my post helpful, please mark thumbs up.

 

If the above post has solved your problem, please click "Accept as Solution".

Any other questions, just ask.

Thanks, Alan


Did I answer your question? Mark my post as a solution!

Proud to be a Flownaut!


View solution in original post

Super User
Super User

Re: Email content triggers calendar invitation

Hi @rlv 

Now that you are using compose and naming them as in my guide, has this solved your problem?

 

If you have found my post helpful, please mark thumbs up.

If this post has solved your problem, please click "Accept as Solution".

Any other questions, just ask.

Thanks, Alan


Did I answer your question? Mark my post as a solution!

Proud to be a Flownaut!


rlv
Level: Power Up

Re: Email content triggers calendar invitation

Hi all-

 

I have another question.

 

Using the same scenario from the original post, how would I do the following:

 

- The body of the calendar would include content from the email which triggered the flow.

 

Thank you!

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors
Users Online
Currently online: 419 members 6,366 guests
Please welcome our newest community members: