Unanswered

formatting numbers from SharePoint list to Google Sheets

(0) Share

Report

Posted on by jensjakobsen

I have a Flow that will copy new entries from my SharePoint list to a Google sheet, which in turn I use to populate a WordPress page via a plugin (no problems there)..

I have 2 problems

Formatting numbers - I get too many decimals (see screenshot - last 3 rows)
The Flow autocreates a column I didn’t ask for (see same screenshot)

Any help is welcome, I hope it’s the right forum.

Categories:

Using flows

I have the same question (0)

All responses (3)

Answers (1)

v-yamao-msft on at

Like (0)

Report
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

Was this reply helpful? Yes No
jensjakobsen 49 on at

Like (0)

Report

Thanks Mabel.

Regarding # 1: POINTS is not a calculated field. I just enter what ever value I want, I just want it to be a number value that I can SUM at a later stage (within Flows). Will you suggestion still work even though it's not a calculated field?

Regard # 2: I tried to HIDE the PowerAppsID field on Google Sheets, but once the the Flow inserts another row in the Google Sheet, then the field is visible once again. If possible I would want to hide it.

Was this reply helpful? Yes No
Verified answer

v-yamao-msft on at

Like (1)

Report

Hi @jensjakobsen ,

About #1, it still works even though it is not a calculated field.

Please take a try with it.

About #2, I am afraid that it is not possible to hide the PowerAppsId field which will be used in the following actions. It will be created automatically when it is working with Microsoft Flow.

However, you could also submit a request on Flow Ideas Forum, so it might be taken into consideration in future releases:

https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas

Best regards,

Mabel

Was this reply helpful? Yes No