Remove Duplicate Rows From Excel Table Using Power Automate

 Steps to follow:

1. Create a new flow in Power Automate. To do this, log in to the Power Automate portal, click the "New" button, select "Instant Cloud flow" and select the appropriate trigger.

2. Add an action to retrieve the data from your Excel table, such as the "List rows present in a table" action.

   

3. Add a "Select" action to select the excel table columns from which the Duplicate values need to be removed.

   

4. Add the "Compose" action to get the unique rows of the excel table.In the "Compose" action, use the expression "union(body('Select'),body('Select'))" to create a unique rows.

5. Add "Delete A Row" Action within "Apply To each" action to delete older rows.

6. Add "Add A row into a table" Action within "Apply To each" action to insert unique rows.Here select output of 'Compose' action as input for 'Apply to each action'.In the column fields of "Add A row into a table" Action, use the expression as 'item()?['ColumnName']' to get the values of the respective column.

   
   Hope this will work for you and feel free to share your issues.