https://community.esri.com/t5/arcgis-connectors-for-power-automate-questions/how-can-i-get-my-number-columns-to-show-up-in/m-p/1615933#M955 <P>Hi all,</P><P><SPAN>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 "<STRONG>Update a record in a feature layer</STRONG>" step, the number columns do not appear as dynamic fields.</SPAN></P><P><SPAN>I've verified that the numbers are formatted correctly in Excel, and the field type in ArcGIS Online (AGOL) is set to <STRONG>Double</STRONG>. Additionally, both Excel and AGOL store these numbers with two decimal places.</SPAN></P><P><SPAN>Do I need to create an expression to convert the number columns to the<STRONG> Double</STRONG> format? If so, where should I incorporate this expression within my flow? Below is the layout for reference.</SPAN></P><P>.</P><P>&nbsp;</P> Mon, 19 May 2025 12:03:07 GMT FM5091 2025-05-19T12:03:07Z https://community.esri.com/t5/arcgis-connectors-for-power-automate-questions/how-can-i-get-my-number-columns-to-show-up-in/m-p/1615933#M955 <P>Hi all,</P><P><SPAN>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 "<STRONG>Update a record in a feature layer</STRONG>" step, the number columns do not appear as dynamic fields.</SPAN></P><P><SPAN>I've verified that the numbers are formatted correctly in Excel, and the field type in ArcGIS Online (AGOL) is set to <STRONG>Double</STRONG>. Additionally, both Excel and AGOL store these numbers with two decimal places.</SPAN></P><P><SPAN>Do I need to create an expression to convert the number columns to the<STRONG> Double</STRONG> format? If so, where should I incorporate this expression within my flow? Below is the layout for reference.</SPAN></P><P>.</P><P>&nbsp;</P> Mon, 19 May 2025 12:03:07 GMT https://community.esri.com/t5/arcgis-connectors-for-power-automate-questions/how-can-i-get-my-number-columns-to-show-up-in/m-p/1615933#M955 FM5091 2025-05-19T12:03:07Z https://community.esri.com/t5/arcgis-connectors-for-power-automate-questions/how-can-i-get-my-number-columns-to-show-up-in/m-p/1616551#M956 <P>Never Mind I got it with the help of, DominicRobergeIADOT, Thanks Dom!</P> Tue, 20 May 2025 17:01:39 GMT https://community.esri.com/t5/arcgis-connectors-for-power-automate-questions/how-can-i-get-my-number-columns-to-show-up-in/m-p/1616551#M956 FM5091 2025-05-20T17:01:39Z