cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
paulccook
Level: Powered On

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,

 

Paul

 

 

2 REPLIES 2
Community Support Team
Community Support Team

Re: Do not add PowerAppsId when using Insert Row Excel Connector

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:22.JPG

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

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.
Highlighted
paulccook
Level: Powered On

Re: Do not add PowerAppsId when using Insert Row Excel Connector

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

Announcements
firstImage

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 Release Wave 2 Plan

Power Platform 2019 Release Wave 2 Plan

Features releasing from October 2019 through March 2020.

thirdimage

Flow Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Flow Community Video Gallery!

Users Online
Currently online: 200 members 4,448 guests
Please welcome our newest community members: