Showing results for 
Search instead for 
Did you mean: 

Update Column in a Excel Table using a Flow and RowID/ PowerappsID


I am using a google Sheet document to maintain some data.

I connected this doc via powerApps, using the corresponding connector, but unfortunatly it broke this document by updating a "used" (containing data) column and added this "PowerAppsId" data 


I attached a screenshot.


How coud I prevent such thing to happen ? 




Community Support
Community Support

Hi @FredEsn,

Could you please share a bit more about your scenario?

Do you want to prevent the __PowerAppsId__ column from being added into your Google sheet?

If you want to prevent the __PowerAppsId__ column from being added into your Google sheet when you connect to this sheet from your app, I afraid that there is no way to achieve your needs in PowerApps currently.

Actually, when you create a connection to your Google sheet from your app, it would create a column called __PowerAppsId__ automatically, with a unique ID for each row of your Google sheet. The __PowerAppsId__ column would be acted as unique Row Id of each row of your Google sheet.

If you want to update an existing row in your Google sheet using MS Flow, you need to use the corresponding __PowerAppsId__ column value as the Row Id.


Best regards,


Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi Kris,

thanks a lot for this explaination, it helps me to understand how the product works.


My "problem" is in fact that this extra data has been added in a column that contained valuable data, in other words powerappsID coulumn replaced my data.

In the attached screenshot columns AW, AX, AY used to contain data, and this powerappsID column replaced my "AX" data.

question would be : how to prevent such problem ? For example, explicitely mention the column that should be used for this indexing data.


Thanks !



Hi @FredEsn,

Is there a __PowerAppsId__ column existed in your Google sheet?

Do you mean that the AX column data has been overwrited by __PowerAppsId__ column value in your Google sheet?

I have made a test on my side, and don't have the issue that you mentioned.

Please take a try to re-create a new Google sheet on your side, then create a connection to this new sheet from your flow, then try it again, check if the issue still exists.


Best regards,


Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi Kris,

I confirm the scenario : an existing file has bee broken by the connector, updating all the data in a column for this powerAppsID.

Would it be possible to share offile this file with you in order to have your expertise ?


Thanks a lot !



Hi, I did the test again and had same result.

I suspect some logic in the connector that generates this behavior.

What would be the best way to deep dive this ?


Not applicable

adding in @GregLi to review and assist. 



Helpful resources

PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Top Solution Authors
Top Kudoed Authors
Users online (1,126)