Unanswered

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

(1) Share

Report

Posted on by Phineas

5,345 Moderator

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

All responses (3)

Answers (0)

Sort by

trice602 16,679 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!

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 ⭐⭐⭐⭐⭐
Phineas 5,345 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

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?
trice602 16,679 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!

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 ⭐⭐⭐⭐⭐