Unanswered

Converting outlook email details to an outlook calendar event using flow

(0) Share

Report

Posted on by lallen_jranck

I have created a PDF form for PTO requests that sends an email to end user and payroll manager with supervisor approval. I need to take the information from this email and automatically make it a calendar event for the end user and a group calendar called PTO. I have the PDF form pulling the information and routing to the supervisor for approval and then the payroll manager with the approved email working correctly. I have tried to put a flow in place that will extract the information (title, start date, end date) from the email and automatically set up a outlook calendar event, but it's not working. The email routes correctly, but the calendar event flow fails. This is the output error message: status 400, The string was not recognized as a valid DateTime. There is an unknown word starting at index 0. Does anyone know how I can get this to work?

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

yashag2255 24,769 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @lallen_jranck

Can you share a screenshot of the flow you have created so far? Note that the start time and the end time of the event in the create event action should be appropriately formatted strings (yyyy-MM-ddThh:mm:ssz) in order for the action to work. I am guessing that there must be a misconfiguration at this place while providing the data exacted from the email.

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
lallen_jranck 2 on at

Like (0)

Report
Copy link

Link copied!

@yashag2255
This is what I have.
When a new email arrives (V3)
Folder Inbox
Html to text (Preview)
Content Body
Compose
length(body('Html_to_text'))
Compose 2
add(indexOf(body('Html_to_text'),'End time'),10)
Compose 3
substring(body('Html_to_text'),outputs('Compose_2'),sub(outputs('Compose'),outputs('Compose_2')))
Compose 4
add(indexOf(body('Html_to_text'),'Subject'),9)
Compose 5
indexOf(body('Html_to_text'),'Start time')
Compose 6
substring(body('Html_to_text'),outputs('Compose_4'),sub(outputs('Compose_5'),outputs('Compose_4')))
Create event (V4) 2
Calendar id Calendar
Subject Outputs
Start time formatDateTime(triggerOutputs()?['body/Start time'])
End Time Outputs
Time zone (UTC-05:00) Eastern Time (US & Canada)

Was this reply helpful? Yes No