Do not add PowerAppsId when using Insert Row Excel Connector

[paulccook]

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,

Paul

[v-xida-msft]

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:

https://docs.microsoft.com/en-us/connectors/excel/

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:

https://docs.microsoft.com/en-us/connectors/excelonlinebusiness/

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,

Kris

[paulccook]

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.