Power Automate Update Rowin Data verse

[Anonymous]

Would like to Update the Row in Dataverse.

Facing the Following Error:

OpenApiOperationParameterTypeConversionFailed. The 'inputs.parameters' of workflow operation 'Update_a_row_5' of type 'OpenApiConnection' is not valid. Error details: Input parameter 'item/cr73e_requeststatus' is required to be of type 'Integer/int32'. The runtime value '"XXXX"' to be converted doesn't have the expected format 'Integer/int32'.

How to resolve this?

[Expiscornovus]

Hi @Anonymous,

It looks like the requeststatus field in the update row action is in the wrong data format. It is expecting a number and my guess is that it is probably a string or another data type. 

Can you share a screenshot of your current update row action configuration?

[Anonymous]

Thank you for the response. Here is the configuration of update row

While I'm trying to set text value to Choice column, it says error.Here is the Screenshot

[Expiscornovus]

Hi @Anonymous,

With a choice field I would expected the internal number (for example 309310000) of that choice option instead of the label (for example Review).

Can you try and use this expression instead in the custom value field?

1. Click the Custom Value option

2. Add the expression via the expression editor.

items('Apply_to_each')?['cr73e_requeststatus']

[Anonymous]

Hi ,

Configuration :

 

Got the same error after changing the custom value

[Expiscornovus]

Hi @Anonymous,

Apologies if it wasn't clear. But I suggested to replace the value with an expression in the Request Status field, not the Row ID field.

[Anonymous]

This works. Your answer was clear. Thank you for the response and support