Unanswered

Excel

(0) Share

Report

Posted on by Gayu

This is my Excel worksheet . Here I want to Delete the First Row . could not even delete it manually , Can anyone say how to delete this by using the desktop flow action.

Categories:

Power Automate Desktop

I have the same question (0)

All responses (4)

Answers (0)

Sort by

UK_Mike on at

Like
a
(0)

Report
Copy link

Link copied!

That looks like a Power Query output ?

Was this reply helpful? Yes No
Gayu 46 on at

Like
a
(0)

Report
Copy link

Link copied!

I am new to this power platform , can you explain it detail?

Was this reply helpful? Yes No
MichaelAnnis 5,727 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

I'm pretty sure it is a table, and that is why you cannot delete it. There may be a table option to remove header from table. Good luck.

Was this reply helpful? Yes No
VJR 7,635 on at

Like
a
(0)

Report
Copy link

Link copied!

@Gayu

This cannot be manually deleted and hence cannot be deleted via PAD too, because it is an Excel table.

But I understand your intention is to make them as column headers.

So you can copy paste your headers already present from Row No 2 to Row No 1

and then delete Row No 2.

Like this...

Original:

After copy pasting row 2 into row 1

Then after deleting row 2

Was this reply helpful? Yes No