Answered

Action 'Update_item' failed

(0) Share

Report

Posted on by CU06021343-1

Hi,

Could anyone help me fix the flow?
It works fine if column K has no blank values.

I'm using this formula: if(equals(items('Apply_to_each')?['Data de Conclusão'],''),null,items('Apply_to_each')?['Data de Conclusão'])

returns this error:

The 'inputs.parameters' of workflow operation 'Update_item' of type 'OpenApiConnection' is not valid. Error details: Input parameter 'item/DatadeConclus_x00e3_o' is required to be of type 'String/date'. The runtime value '"44795"' to be converted doesn't have the expected format 'String/date'.

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (1)

Hardesh15 7,087 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@jcnascime1 Pls change your date format.

Please 'Thumbs Up' the posts that helped you and 'Accept as Solution' if my post answered your question.

@Hardesh /Gopenly.in

Was this reply helpful? Yes No
CU06021343-1 on at

Like (0)

Report
Copy link

Link copied!

I already did that and the error persists.

when I don't have blank values in column K, my flow works.

Was this reply helpful? Yes No
Verified answer

v-xiaochen-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @jcnascime1 ,

It is a limitation if the first date is blank.

Please take a look at this post. It shared a workaround.

When Excel first row has blank date all remaining ... - Power Platform Community (microsoft.com)

Best Regards,

Wearsky

Was this reply helpful? Yes No