cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Power Automate Update Rowin Data verse

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?
6 REPLIES 6
Expiscornovus
Super User
Super User

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?



Happy to help out! 🙂

Interested in more #PowerAutomate #SharePointOnline or #PowerVirtualAgents content?
Visit my blog, Subscribe to my YouTube channel or Follow me on Twitter


Anonymous
Not applicable

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

Configuration.png

 

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

Output.png

 

 

 

 

Expiscornovus
Super User
Super User

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

 

customvalue_example.png

 

2. Add the expression via the expression editor.

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

 

expression_customitem.png



Happy to help out! 🙂

Interested in more #PowerAutomate #SharePointOnline or #PowerVirtualAgents content?
Visit my blog, Subscribe to my YouTube channel or Follow me on Twitter


Anonymous
Not applicable

Hi ,

 

Configuration :

Config1.png

Got the same error after changing the custom value

O_p1.png

Expiscornovus
Super User
Super User

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.

 

requeststatusfield.png

 



Happy to help out! 🙂

Interested in more #PowerAutomate #SharePointOnline or #PowerVirtualAgents content?
Visit my blog, Subscribe to my YouTube channel or Follow me on Twitter


Anonymous
Not applicable

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

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (3,115)