Answered

Removing duplicate rows from DataTable based on single Column

(0) Share

Report

Posted on by billy405

Hello, I am looking for solution to remove duplicate rows in DataTable based on Column zero.
I cant use "add items " to list first and then delete.

Is there any script way to do it?

Categories:

Power Automate Desktop

I have the same question (0)

All responses (4)

Answers (1)

Sort by

UrosB 11 on at

Like
a
(0)

Report
Copy link

Link copied!
Something similar to this (paste it into empty action window in PAD):

Variables.CreateNewDatatable InputTable: { ^['ID', 'Name'], [1, $'''John'''], [2, $'''Anne'''], [1, $'''Paul'''] } DataTable=> FirstTable Variables.CreateNewDatatable InputTable: { ^['ID', 'Name'], [$'''''', $''''''] } DataTable=> SecondTable Variables.DeleteRowFromDataTable DataTable: SecondTable RowIndex: 0 LOOP FOREACH CurrentItem IN FirstTable Variables.FindOrReplaceInDataTable.FindItemInDataTableByColumnIndex DataTable: SecondTable AllMatches: False ValueToFind: CurrentItem['ID'] MatchCase: False MatchEntireCellContents: False ColumnNameOrIndex: $'''ID''' DataTableMatches=> DataTableMatches IF DataTableMatches.RowsCount = 0 THEN Variables.AddRowToDataTable.AppendRowToDataTable DataTable: SecondTable RowToAdd: CurrentItem END END

Was this reply helpful? Yes No
Riyaz_riz11 4,214 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @nabeelamjad ,

Try this, this will help you.

If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.

Regards,
Riyaz

Was this reply helpful? Yes No
Verified answer

Nived_Nambiar 18,138 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @nabeelamjad

Another way to achieve this is by using Linq query using Run .Net script action.

Assume you have a input datatable like below:

You need to remove duplicate columns based on column first /zero.

Now use Run .NET Script action to run the GroupBy linq query

see below:

For field References to be uploaded, you have to pass the folder path where you have stored dll files for executing your script, for the details of the this,refer this article :

https://www.linkedin.com/pulse/how-run-net-script-action-empowers-data-table-power-automate-bysani/

2. Script paramters: specify the parameters that you need to pass in out of flow, see below:

3. Script: add the group by script like below:

dt2= (From row in dt1.AsEnumerable() Group row by col= row(0).ToString Into Group Select Group.first()).CopyToDataTable()

Now see the result :

Hope this helps !

Thanks & Regards,
Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

Was this reply helpful? Yes No
Hidden 2 on at

Like
a
(0)

Report
Copy link

Link copied!

After reading through the excel sheet and filtering out the data and use delete Duplicate rows from the data table action ensuring that all rows with identical data are deleted. Set the variable Var to 0.
When comparing two rows within the same column using an if statement, remember that ['Name'] refers to the column name for which the values are being matched.

I hope the above logic will help in deleting the rows that have the same value in a particular column.

Was this reply helpful? Yes No