Answered

Duplicate rows created

(0) Share

Report

Posted on by Ers Siv

I created a flow where a list is updated from a csv file every time new items are added to the csv file. I upload a new csv file weekly and want to add only the new item (rows) in the list to the list.

However, my flow keeps duplicating all the old rows every time I run the flow.

I know it's possible to skip duplicates based on some column criteria, but I cannot figure it out.

Can someone help me out here? I attached my flow in zip file.

Thank you.

Ersin S.

TEST_202505261505...

Categories:

Using flows

I have the same question (0)

All responses (7)

Answers (1)

Sort by

Michael E. Gernaey 53,978 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @CU26051937-0

My suggestion

Add a column called New and its either true or false, or make it yes or no just strings really

Then in the ListRows In a Table, you can easily write a filter to grab only those with no or false (whichever wording you use).

Then you would update that column to yes/true

and done

Was this reply helpful? Yes No
Ers Siv 8 on at

Like (0)

Report
Copy link

Link copied!

Got it. So once the new rows are imported, I'll mark them all as YES so PowerAutomate skips those rows.

Makes sense. I'll try that.

Thank you.

Was this reply helpful? Yes No
Michael E. Gernaey 53,978 Moderator on at

Like (0)

Report
Copy link

Link copied!

Correcnt @Ers Siv

If it works as you need if you don't mind marking my answer as well as maybe a link please

THanks

Was this reply helpful? Yes No
Ers Siv 8 on at

Like (0)

Report
Copy link

Link copied!

I am sorry Michael, what do you mean marking your answer and a link? I am new to this new version of posting boards. I apologize.

Also, I still think there must be a way for PowerAutomate to check the rows and do not import the duplicates/identical ones, don't you think so?

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

Like (0)

Report
Copy link

Link copied!

Hi@Ers Siv,

I hope there might be some unique identifier before inserting into table check whether that unique identifier is present or not using get rows using a table action if get rows output empty then insert a row.

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
Ers Siv 8 on at

Like (0)

Report
Copy link

Link copied!

Yes, each file has a unique identifier on the first column. RO# and it's unique for each row.

I want the automation to check that and if the RO# is already in the list, then skip it, if not, add a new line.

Was this reply helpful? Yes No
Verified answer

Riyaz_riz11 4,139 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @Ers Siv

Trigger the Flow when a new CSV file is uploaded to OneDrive or SharePoint.
Read the File Content using the "Get file content" action.
Convert the CSV to JSON:
Use "Create CSV table" followed by "Parse JSON" to transform the CSV rows into structured data.
Retrieve Existing List Items from your SharePoint list using the "Get items" action.
Loop Through Each Row in the parsed CSV data.
Check for Duplicates:
Use a "Filter array" to compare a unique column (like ID or Email) from the current CSV row against the existing list items.
If no match is found (length of the filtered array is 0), it means the row is new.
Add Only New Rows:
In the "Yes" branch of the condition, use "Create item" to insert the new row into the list.

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