cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Baratux
New Member

How to delete tables in excel?

Hi there

I'm new and I think this should be the easiest thing to do, but I don't get it.

I want to remove all data(except the headers) from four tables in one excel sheet when a new month starts.

 

grafik.png

Here is what I have so far: (sorry for not english parts)

 
 

Thank you already

1 ACCEPTED SOLUTION

Accepted Solutions
v-alzhan-msft
Community Support
Community Support

Hi @Baratux ,

 

Could you please share a screenshot of the excel table?

Please refer to screenshot below to create the flow and make sure the Key value is unique in the Key column:

1.png

 

Best regards,

Alice       

 

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

7 REPLIES 7
Jcook
Super User
Super User

Hello,

I am wondering if this solution from this post is of any help:
https://powerusers.microsoft.com/t5/General-Power-Automate/Delete-old-rows-in-Excel/td-p/296530

If not, could you please translate the picture you have included.

Thanks

--Josh

If you like my post please hit the "Thumbs Up" -- If my post solved your issue please "Mark as a Solution" to help others

Did I answer your question? Mark my post as a solution!

If you like my post please hit the Thumbs Up


Proud to be a Flownaut!


Check out my blog for Power Automate tips,
tricks, and guides
FlowAltDelete





Hi  Josh,

 

No, the post doesn't help much. I think i made all in the same way.

 

The first excel block on the picture is "List rows present in a table" and down below is where my problems are.

Here again fully translated:

 

grafik.png

grafik.png

The error message I get is, that he can't find the row with the ID "<first name in my table>"

 

Hi,

Are you selecting the table name from the drop down?

Excel connector unfortunately cannot have dynamic table name.

--Josh

If you like my post please hit the "Thumbs Up" -- If my post solved your issue please "Mark as a Solution" to help others

Did I answer your question? Mark my post as a solution!

If you like my post please hit the Thumbs Up


Proud to be a Flownaut!


Check out my blog for Power Automate tips,
tricks, and guides
FlowAltDelete





Hi,

 

Yes from the Dropdown, no custom value.

My tables in excel are infite (whole columns) , could that be a problem?

Also I am not sure about IDs, does every row need to have a clearly ID in the table?

 

Thank you for trying to help

v-alzhan-msft
Community Support
Community Support

Hi @Baratux ,

 

Could you please share a screenshot of the excel table?

Please refer to screenshot below to create the flow and make sure the Key value is unique in the Key column:

1.png

 

Best regards,

Alice       

 

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Hi Alice,

 

thank you for your attetion first.

I have now retried some things and I think to have located the error:

I secured some of the colums with a password, because these are calculations that should not be changed.

Without the password on the page, the deleting works.

The are no protected cells in the table itself, so is this intended?

I think about a workaround for myself or is there any handy solution to this problem where cells can stay protected while deleting others?

 

Best regards

Baratux

 

 

Hi @Baratux ,

 

There is no any solution for the issue.

 

Best regards,

Alice       

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (3,090)