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

Remove duplicates in Excel Table or Delete all rows in Excel table.

Hi,

 

I have a flow set up to combine the data from tables in 6 separate excel workbooks into one 'master' table in another workbook.

 

I have no issues getting the data in or adding it to the table, but I need to do one of the following to the 'master' table:

 

  1. Remove all rows/data from table (at the start of Flow); or
  2. Remove all duplicates from table (at the end of Flow)

Has anyone done something similar or have some pointers on what & how I could accomplish this?

 

Thanks!

 

- Alan

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: Remove duplicates in Excel Table or Delete all rows in Excel table.

Hi @Alan-Hossack ,

 

Remove all rows/data from table at the start of Flow could be easily achieved using the following configuration.

 

Please check the image for a reference.

 

Note: If you have more than 256 rows, you need to set Top Count to its maximum value.

1.PNG

 

 

Best regards,

Mabel          

 

Community Support Team _ Mabel Mao
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

4 REPLIES 4
Highlighted
Community Support
Community Support

Re: Remove duplicates in Excel Table or Delete all rows in Excel table.

Hi @Alan-Hossack ,

 

Remove all rows/data from table at the start of Flow could be easily achieved using the following configuration.

 

Please check the image for a reference.

 

Note: If you have more than 256 rows, you need to set Top Count to its maximum value.

1.PNG

 

 

Best regards,

Mabel          

 

Community Support Team _ Mabel Mao
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
Frequent Visitor

Re: Remove duplicates in Excel Table or Delete all rows in Excel table.

Hi

 

this doesnt work for me, i still get an error cannot find id

 

 


@v-yamao-msft wrote:

Hi @Alan-Hossack ,

 

Remove all rows/data from table at the start of Flow could be easily achieved using the following configuration.

 

Please check the image for a reference.

 

Note: If you have more than 256 rows, you need to set Top Count to its maximum value.

1.PNG

 

 

Best regards,

Mabel          

 



Capture.JPG

 

 

Highlighted
New Member

Re: Remove duplicates in Excel Table or Delete all rows in Excel table.

One problem Iran into was that the Flow would error if the table had a filter applied to it. Clearing the filter fixed the issue though.

Highlighted
Frequent Visitor

Re: Remove duplicates in Excel Table or Delete all rows in Excel table.

thanks for that, i checked and it was so i cleared the filters but i am still getting the same message:

 

 
"statusCode": 404,
"message": "Resource not found"
 

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Upcoming Events

Experience what’s next for Power Automate

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Top Solution Authors
Top Kudoed Authors
Users online (6,507)