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?
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:
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.
Learn how to create your own user groups today!
Check out the new Power Platform Community Connections gallery!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.