Re: formatting numbers from SharePoint list to Google Sheets
Hi @jensjakobsen ,
About #1, I assume that the value for the Point column comes from a Calculated column in SharePoint list.
By default, the value of calculated column will be considered as a text when working with Flow.
Please use float function to convert it to an actual floating point number.
I have made the following test and it works properly.
The function used in the “cal” column is:
float(items('Apply_to_each')?['Cal'])
About #2, once you create a connection to Excel table, a “_PowerAppsId_” column will be added automatically, that is where you find the ID or that row, and you can later specify in a flow.
For example, when using the action Update row, you are asked to specify the Row Id. Then you could select the “_PowerAppsId_” for this field.
Best regards,
Mabel
