Select to view content in your preferred language

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

432
2
Jump to solution
11-02-2024 04:35 PM
Dirk_Vandervoort
Frequent Contributor

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

Dirk_Vandervoort_0-1730588261130.png

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:

Dirk_Vandervoort_1-1730590309566.png

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

1 Solution

Accepted Solutions
AlagiriVenkatachal
Esri Contributor

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.

View solution in original post

0 Kudos
2 Replies
AlagiriVenkatachal
Esri Contributor

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.

0 Kudos
CedricMarchand
New Contributor

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 !

0 Kudos