topic Re: Update record with Unique ID Field as a STRING, the flow treats it like a NUMBER in ArcGIS Connectors for Power Automate Questions

Update record with Unique ID Field as a STRING, the flow treats it like a NUMBER

Dirk_Vandervoort — Mon, 04 Nov 2024 13:12:59 GMT

I have a flow that includes Update a Record in a Feature Layer that looks like this:

ParagonID is a string field and records are guaranteed unique. the value of "096" returns a unique record from the feature layer. When the flow executes I get the following:

In other words, somewhere, under the hood, the string "096" is getting converted to a numerical 96. Fail.

My Question: How to enforce that a string is getting passed to the task? I've tried '096', \096, "096" string(096) and a few other variations.

TIA

Re: Update record with Unique ID Field as a STRING, the flow treats it like a NUMBER

AlagiriVenkatachal — Mon, 18 Nov 2024 22:51:00 GMT

Hello @Dirk_Vandervoort,

This seems like an issue with how the body is parsed by the Power Automate connector. We will pick this up to fix for our next update.

Re: Update record with Unique ID Field as a STRING, the flow treats it like a NUMBER

CedricMarchand — Wed, 08 Jan 2025 08:19:11 GMT

Hi, same problem here. I need to pass a value '096' as a string, but it is automatically converted to a number and saved as 96 in my feature layer. Hope the update comes soon !