You’re offline. This is a read only version of the page.
Hi
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
Any help is welcome, I hope it’s the right forum.
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
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.
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:
Share
Report
All responses (
Answers (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
#1
Tomac
986
Moderator
#2
stampcoin
699
Super User 2025 Season 2
#3
Riyaz_riz11
577
Super User 2025 Season 2
