Answered

Building a flow that extracts date from email

(0) Share

Report

Posted on by Ftapiaj39

Hi,

I am new to using power automate but i am trying to create a flow by extracting dates from a justworks email to create an event on the outlook calendar, I also noticed to create an event on I would need a time format which justworks does not provide. Below is an example of the email format:

Policy:	Vacation
Total Days Off:	2.0
Start Date:	07/01/2021
End Date:	07/02/2021

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

v-LilyW-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @Ftapiaj39
According to your description, you want to get the Start date and End date from email to create an event.
I created a simple Flow, you can refer to as below:
The flow is triggered by When a new email arrives, then convert the email body from Html to text.
Expression: last(split(outputs('Html_to_text')?['body'],'Start Date:'))
Get Start Date:
Expression:first(split(outputs('Compose'),'End Date:'))
Get End Date:
Expression:last(split(outputs('Html_to_text')?['body'],'End Date:'))
Create event with Start Date and End Date.
When a new email arrive like this
The new event will be created
For more info about function you can refer to:
https://docs.microsoft.com/en-us/azure/logic-apps/workflow-definition-language-functions-reference
Hope the content above may help you.
Best Regards
If my solution helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
Ftapiaj39 8 on at

Like (0)

Report
Copy link

Link copied!

Hi,
Thank you for the help, but for some reason for the end date it is pulling the remaining part of the email instead of just the date.

Was this reply helpful? Yes No
Verified answer

v-LilyW-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @Ftapiaj39
The above method is applicable when there is no content after end date or the content after the end date is fixed.
If the content behind end date is not fixed, you can try the following screenshots to get the date:
Expression:substring(body('Html_to_text'),add(lastIndexOf(body('Html_to_text'),'Start Date:'), 11),12)
Expression:substring(body('Html_to_text'),add(lastIndexOf(body('Html_to_text'),'End Date:'), 9),12)
Hope the content above may help you.
Best Regards
If my solution helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
Ftapiaj39 8 on at

Like (0)

Report
Copy link

Link copied!

It Worked! Thank you!

Was this reply helpful? Yes No