Float to string

pedro.syngenta.udi

I'm doing an automation through Power Automate, but it only recognizes string values and Smartsheet columns are in float, how can I do this integration?

error that appears API 'smartsheet' returned an invalid response for workflow operation 'receive' of type 'OpenApiConnection'. Error Details: 'API operation 'GetSheetData' requires property 'body/value/43/Official Lot' to be of type 'String', but it is of type 'Float'.'

Genevieve P.

Hi @pedro.syngenta.udi

I checked in the Power Automate Community and found a similar thread that may have a solution you can use: API Operation expecting data of type number but if of type string

In this scenario, the user either removed then re-added a connection and/or removed/re-added any steps using the connector in a flow and retested because their existing connections and actions were still referring to the old OpenAPI definition.

If this hasn't helped, I would recommend posting in the Power Automate Community to get help from other Power Automate users.

Cheers,

Genevieve

Bruno Cerentini

I am having the same issue.