cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
Highlighted
Community Support
Community Support

Re: How to delete tables in excel?

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
Highlighted
Super User
Super User

Re: How to delete tables in excel?

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!





Highlighted
New Member

Re: How to delete tables in excel?

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

 
Highlighted
Super User
Super User

Re: How to delete tables in excel?

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!





Highlighted
New Member

Re: How to delete tables in excel?

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

Highlighted
Community Support
Community Support

Re: How to delete tables in excel?

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

Highlighted
New Member

Re: How to delete tables in excel?

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

 

 

Highlighted
Community Support
Community Support

Re: How to delete tables in excel?

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
firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

Join the new Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

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

Top Solution Authors
Users online (8,989)