web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Automate
Unanswered

Email to calender

(0) ShareShare
ReportReport
Posted on by

Hello All,

 

Brand new here. Need help. 

 

I get the following notification as an email. I wanted to write a flow that extracts information from this email and creates a calender entry in outlook for 30 mins. 

 

email details:

------------------------------------

subject: Proposal Submission for ABC Inc. 

 

Body: 

Hi, 

The Proposal Submission is due on: 

Date: December 18, 2018

Time: 3:00 PM

Thx

------------------------------------

Can someone please help ? I tried split etc, but while everything works to get the data, I am unable to create a new event. 

 

Thanks in advance!! 

 

 

 

 

Categories:
I have the same question (0)
  • v-yamao-msft Profile Picture
    on at

    Hi @Anonymous,

     

    Do you want to extract the information from the email body then create an event on Outlook Calendar?

    Please take the following configuration for a reference.

    By the way, please make sure your email body always contains the info with the same format.

    Add the trigger When a new email arrives.

    Add the action Html to text.

    Add Compose action and enter the following code to get the starting position of the date:

    add(indexOf(body('Html_to_text'),'Date:'),5)

    Add Compose2, input the following code to get the starting position of Time:

    indexOf(body('Html_to_text'),'Time:')

    Add Compose3 with the following code to get the extract date info:

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

    Add Compose4 with the following code to return the extract time info:

    substring(body('Html_to_text'),add(outputs('Compose_2'),5),sub(indexOf(body('Html_to_text'),'Thx'),add(outputs('Compose_2'),5)))

    Add Compose5 with code to combine date and time:

    concat(outputs('Compose_3'),outputs('Compose_4'))

    Add Compose6 with following code to format it to an valid time string:

    formatDateTime(outputs('Compose_5'),'yyyy-MM-dd HH:MM')

     Add action Create event. Select Email subject for the Subject filed, the output of Compose6 for the Start time field, input the following code for the End time field:

    addMinutes(outputs('Compose_6'),30)

     A screenshot for your reference.

    1.PNG2.PNG

     

    Best regards,

    Mabel

  • Community Power Platform Member Profile Picture
    on at

    thnks a lot!!!!! This helps!!!!! It works well now

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 522 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 364 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard