Hi all,
I'm encountering an issue with my Power Automate flow while updating a feature layer from an Excel (XLSX) spreadsheet stored in SharePoint. While text and date fields map correctly in the "Update a record in a feature layer" step, the number columns do not appear as dynamic fields.
I've verified that the numbers are formatted correctly in Excel, and the field type in ArcGIS Online (AGOL) is set to Double. Additionally, both Excel and AGOL store these numbers with two decimal places.
Do I need to create an expression to convert the number columns to the Double format? If so, where should I incorporate this expression within my flow? Below is the layout for reference.
.
