Unanswered

Excel - Delete Rows, Make Table, Move Data to SharePoint List

(1) Share

Report

Posted on by Phineas

5,323 Super User 2025 Season 2

I have an Excel workbook that has half-a-dozen sheets.

Each sheet has merged and other cells/lines in the first seven rows that I don't need.

1. I need to delete the first seven lines of each of the sheets.

2. I then need to make a table of a set of a predetermined set of rows and columns remaining.

3. I then need to move the data from each of those sheets to a SharePoint List.

I know I can accomplish 2 and 3 with flow. Can I accomplish the deleting of the rows - at all, specifically, in the same flow as 2 and 3?

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

trice602 15,331 Super User 2025 Season 2 on at

Like (0)

Report

Re: Excel - Delete Rows, Make Table, Move Data to SharePoint List

Hi @Phineas ,

Yes, you can do this a couple of different ways and I use both.

1) Run a quick desktop flow from your cloud flow and go delete the desired rows, save, and come back to cloud flow and continue processing your data. You can easily delete rows in Power Automate Desktop.

2) The 2nd option is to process your data in dataflows in Power Automate, which is essentially the PowerQuery for Dataverse, nearly identical functionality.

So you have a couple of options and they both do work well.

Please mark as a solution ✅ and/or give me a thumbs up 👍🏽 for replying and volunteering my time! 🎗️ Always glad to help! Tom ⭐⭐⭐⭐⭐

Was this reply helpful? Yes No
Phineas 5,323 Super User 2025 Season 2 on at

Like (1)

Report

Re: Excel - Delete Rows, Make Table, Move Data to SharePoint List

Thank you for your detailed reply.

Can you clarify; Seems what you propose requires manual manipulation, and is not intrinsically 'automatic', yes?

The Excel workbook involved comes in from a third party several times a week. The solution I need will need to recurring and automatic.

RPA would require the use of someone's computer, and Power Query would need to be manually performed for every instance, yes?

Was this reply helpful? Yes No
trice602 15,331 Super User 2025 Season 2 on at

Like (0)

Report

Re: Excel - Delete Rows, Make Table, Move Data to SharePoint List

HI @Phineas ,

No, both solutions can run unattended from your cloud flow. The 1st option is to Run a Desktop Flow (which can run unattended on a machine - I use a VM) and this essentially would just open up your Excel workbook and dynamically delete those first 7 rows you mentioned, save, close, and return to your cloud flow to do tasks #2 and 3.

The 2nd solution, Dataflows, is PowerQuery but in Dataverse for cloud flows. This can all be done unattended in the cloud and doesn't run on anyone's machine.

Again, I use both and depending on the task, I will use one or the other. Going to dataflows does allow you to accomplish way more than just deleting the 1st 7 rows; technically you could do task 1, 2, and 3 here and just return the table to your cloud flow, or save it off in SharePoint and just treat it like a cleaned up excel workbook.

Please mark as a solution ✅ and/or give me a thumbs up 👍🏽 for replying and volunteering my time! 🎗️ Always glad to help! Tom ⭐⭐⭐⭐⭐

Was this reply helpful? Yes No