Showing results for 
Search instead for 
Did you mean: 
Regular Visitor

Do not add PowerAppsId when using Insert Row Excel Connector

I have made a flow that takes items from a SharePoint List and inserts them into an excel sheet on OneDrive (Get Items -> Apply to Each(Insert Row)).


I would like for the flow NOT to add PowerAppsId Column to my Spreadsheet.


Is this possible? If not, can I delete this column with another action?


Additionaly, I would like the Wrap Text property applied on a specific column to be upheld, but it is always removed. Can we fix this?


Thank you,





Community Support
Community Support

Hi @paulccook,


Could you please share a screenshot of your flow's configuration?

Do you want to not add the __PowerAppsId__ column into your Excel table when inserting rows into the Excel table?


If you want to not add the PowerAppsId column into your Excel table when inserting rows into the Excel table, I afraid that there is no way to achieve your needs. When you use Excel connector to connect to the Excel file within your OneDrive folder, the __PowerAppsId__ column would be inserted into your Excel table automatically and this column is used to keep track of changes in the row.


In addition, there is no way to delete the __PowerAppsId__ in an Excel table in Microsoft Flow currently. 


More details about the Excel connector, please check the following article:


If you don't want the flow to add the __PowerAppsId__ column in your Excel table automatically, you could consider take a try to store your Excel file in a SharePoint library, then use the "Add a row into a table" action of Excel Online (Business) connector to insert the items into your Excel table. I have made a test on my side, please take a try with the following workaround:22.JPG

More details about Excel Online (Business) connector, please check the following article:



If you want to apply the Wrap Text property to a specific column within Microsoft Flow, I afraid that there is no way to achieve your needs in Microsoft Flow currently.



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.
Regular Visitor

Hi @v-xida-msft

Thank you very much for your feedback - much appreciated. I have decided to simply hide this column, allowing me to keep the formatting the way I want.

Every part of my flow works now, EXCEPT that the rows are not alphabetically sorted as they are in my sharepoint list view. I have tried the "get items" sharepoint connector with a "order by" paramater applied - unfortunately, thus is just sorting them almost at random!? Rows with the same entry in the "order by" column are not even grouped together.

Could you provide an example of how to properly use the "order by"?

Strangely, I have to also include a filter to use "order by" without it triggering an "apply to all" - I use a dummy filter, but wonder if this is a bug in the connector?

Thanks again.

Helpful resources

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (1,974)