Issues with DataTime linking to Calander Appointment

(0) Share

Report

Posted on by MRasmus

Hi All,

I am new to making flows and I'm having trouble with linking a date into a Calander appointment.

What I am doing is when an email arrives, the flow will convert html to text and then I filter the body of the email to get the date/time from it. This part works correctly. See below.

Email:

Filter: substring(body('Html_to_text'),add(lastIndexOf(body('Html_to_text'),'Work Start:'), 12),19)

Output:

The next part is where I am having issues. I take the output of the filter and add it to the Calander appointment and then get this error: "String was not recognized as a valid DateTime. clientRequestId: 6db99979-f1da-4abd-8733-c098b87e6288"

I then tried to use formatDateTime to change the output into ISO 8601 format and then take that output and put it into the Calander appointment, but I then get the below error when it attempts the formatDateTime.

Expression: formatDateTime(outputs('Work_Start'), 'yyyy/MM/dd hh:mm tt')

Error: Unable to process template language expressions in action 'Work_Start_Reformat' inputs at line '0' and column '0': 'In function 'formatDateTime', the value provided for date time string '18/05/2023 06:00 AM' was not valid. The datetime string must match ISO 8601 format.'.

In the error I can see that is has taken the correct time from the Work Start step. I have been looking around and haven't been able to find how to fix this.

I am hoping someone will be able to point out what i am missing to make this work.

(I will need to do the same thing for Work End but i will hold off doing that till I get Work Start working)

Below is screenshot of the flow.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

v-peijunz-msft Microsoft Employee on at

Like (0)

Report
Hi @MRasmus

Based on your description, I have made a simple test for your reference.
1. Here is the flow:
split(outputs('Compose'),' ')[0]
split(split(outputs('Compose_2'),' ')[0],'/')
concat(outputs('Compose_3')[2],'-',outputs('Compose_3')[1],'-',outputs('Compose_3')[0])
formatDateTime(outputs('Compose_4'),'yyyy-MM-ddTHH:mm:ssZ')

2. Result:

Here is the doc for your reference:
How to Convert a String to Date in Power Automate | Power Tech Tips

Hope it helps!

Best regards,
Sylvia

Was this reply helpful? Yes No
MRasmus 18 on at

Like (0)

Report

Thanks for your reply @v-peijunz-msft
Just before your reply I found a post with the below setup which work which is basically that same as your post.

Work Start Split: split(outputs('Work_Start'),'/')

Work Start Reformat: concat(outputs('Work_Start_Split')[1],'/',outputs('Work_Start_Split')[0],'/',outputs('Work_Start_Split')[2])

I then linked the Work Start Reformat to the Calander appointment without the formatDateTime function and it worked 🙂

Having seen your setup, you have 2 split functions, but I have 1. is my setup not ideal and do I need to add another split function? and do I need to use the formatDateTime function?
Just wondering if my setup will cause issues down the line.

Was this reply helpful? Yes No
v-peijunz-msft Microsoft Employee on at

Like (0)

Report

Hi @MRasmus

Your method also works! You could choose the way you preferred.
I just use formatDateTime to the format the style I like:)

Anyway, your solution is great, I think you could mark the solution to let more people with the same problem to solve their own problem as quick as possible, and close the case now.
Thank you so much!

Best Regards,
Sylvia

Was this reply helpful? Yes No