String was not recognized as a valid DateTime. clientRequestId: 47a3437b-e81b-49c6-8bf7-0e0cbb2f5c06

(0) Share

Report

Posted on by UluruRob

108

Hi,

I am very new to Power Automate and this is one of my first flows, it is getting stuck at the final step of creating a Calendar Event because of this invalid date time error. I am trying to get the Dynamic Date Contents values from a Cognito forms to create the Calendar Event. I have attached the Flow and the Error details below. I am using compose actions before the Create Event as for whatever reason the content is not available to add directly. Please help.

Categories:

Building flows

I have the same question (0)

All responses (9)

Answers (2)

eric-cheng 5,171 on at

Like (0)

Report

Hi @UluruRob

It appears in your Start Time and End Time, you are passing 2 date values into each field ie. Outputs and utcNow().

Can you remove the utcNow() expression and try again?

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn

Was this reply helpful? Yes No
UluruRob 108 on at

Like (0)

Report

Thanks for the quick response Eric - I see that now but when I remove the utcNow() and save the flow I get another error - see below? I'm just going around in circles!

Was this reply helpful? Yes No
eric-cheng 5,171 on at

Like (0)

Report

Hi @UluruRob ,

You will just need to use a formatDateTime() expression.

Can you copy and paste an example date time output so I can test on my end.

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn

Was this reply helpful? Yes No
UluruRob 108 on at

Like (0)

Report

Thanks @eric-cheng I am only capturing the date in the Cognito form in the format below - perhaps that is the issue that I need to capture date and time in the one output? I do have a Start and End time in the Cognito form can I create an expression that combines the two outputs Date & Time?
4/10/2021

Was this reply helpful? Yes No
eric-cheng 5,171 on at

Like (0)

Report

Hi @UluruRob ,

You will need to format your date still using formatDateTime() into the below format

You can still pass a date into Create Events. It won't error but it will just create an event with the same start and end time.

To format the date, you can use formatDateTime(yourvaluefromcognito, 'yyyy-MM-dd')
--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn

Was this reply helpful? Yes No
Verified answer

UluruRob 108 on at

Like (0)

Report

Thanks again @eric-cheng I think we are getting close, the dates are now passing successfully after I also update format in Cognito and applied the expression, now if I want to add time to this expression how can I do that please, below is the date format date expression.

formatDateTime(triggerOutputs()?['body/LeaveRequestDetails/FormattedStartDate'],'yyyy-MM-dd')

Was this reply helpful? Yes No
UluruRob 108 on at

Like (0)

Report

@eric-cheng Just to clarify the times are a Dynamic Content value also not the time of date entry - thanks.

Was this reply helpful? Yes No
Verified answer

eric-cheng 5,171 on at

Like (1)

Report

Hi @UluruRob ,

formatDateTime(triggerOutputs()?['body/LeaveRequestDetails/FormattedStartDate'],'yyyy-MM-dd hh:mm tt')

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn

Was this reply helpful? Yes No
TXREVHC1 2 on at

Like (0)

Report

Where does this get inserted?

Was this reply helpful? Yes No