Error message in the flow

(0) Share

Report

Posted on by MartinVargas

312

I have the following problem:

Error saving flow with code "OpenApiOperationParameterValidationFailed" and message "Error in validation" item "of input parameter in workflow operation" Set_Incident ": Parameter with value" "@outputs ('Get_Client' )? ['body / createdon'] "" in path "item / CreatedOn" with type and format "String / date-time" cannot be converted to type and format "String / date-no-tz". . ".

Can anybody help me out here ?

Cheers folks

Categories:

Building Power Apps

I have the same question (0)

All responses (14)

Answers (1)

Sort by

Pstork1 69,657 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Date and Time columns in Dataverse can be set to different default formats. They can be user local (which is the default), date only, or Time Zone independent. That value you are trying to use is Time Zone Independent, but I suspect the field is set to use User local. You'll need to reformat the input value to be ISO 8601 in UTC format for the API to accept it. Try using the DateTimeFormat() function in Power Automate to reformat the Date/time value.

Was this reply helpful? Yes No
MartinVargas 312 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Pstork1, Use the following expesion without any result:

convertToUtc (triggerOutputs ()? ['body/createdon'], 'GMT Standard Time')

Was this reply helpful? Yes No
Pstork1 69,657 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
If

triggerOutputs ()? ['body/createdon']

is set for Time Zone Independent then I don't think you can Convert it to UTC because there is no Time Zone to convert. Try using FormatDateTime() as I suggested.

Was this reply helpful? Yes No
MartinVargas 312 on at

Like
a
(0)

Report
Copy link

Link copied!
@Pstork1 Try this and the result is as follows:

formatDateTime (utcNow () , 'MM / dd hh: mm tt' )

The error:

We cannot convert the value "11 / 22 07: 52 PM" to type DateTime. inner exception: We cannot convert the value "11 / 22 07: 52 PM" to type DateTime. clientRequestId: 513e6f3e-533c-4b52-beb1-42ff08533231

Was this reply helpful? Yes No
Pstork1 69,657 Most Valuable Professional on at

Like
a
(2)

Report
Copy link

Link copied!
That's an incomplete date. Please use

formatDateTime (utcNow () , 'o' )

Was this reply helpful? Yes No
MartinVargas 312 on at

Like
a
(0)

Report
Copy link

Link copied!

@Pstork1 Incredible, I understand that utcNow () is Coordinated Universal Time. If I wanted to pass it to Central Standard Time. Is there a way or way to achieve that?

Was this reply helpful? Yes No
Pstork1 69,657 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
convertFromUtc(utcnow(),'Central Standard Time')

Was this reply helpful? Yes No
MartinVargas 312 on at

Like
a
(0)

Report
Copy link

Link copied!

@Pstork1. Thank you. Is there any way to get this format:
'dd-MM-yyyy hh:mm'

I tried the following but got an error.
convertFromUtc(utcnow(),'Central Standard Time', 'dd-MM-yyyy hh:mm')

Was this reply helpful? Yes No
Pstork1 69,657 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

That formula works for me in a compose. But if you are using it to update a field in Dataverse if may need to be in an ISO 8601 compliant format to be recognized. What is the error that you get?

Was this reply helpful? Yes No
MartinVargas 312 on at

Like
a
(0)

Report
Copy link

Link copied!

.

Was this reply helpful? Yes No