Unanswered

Save records without duplicates

(0) Share

Report

Posted on by LuisDataReady

Hi,

I have a sharepoint list called "Records". I want to save new records from excel. I used List rows present in a table, I want to save records, without duplicates.

In records there is a column named "IDPart". In excel I have the same column IDPart, I want to save the records, but if a IDPart already exist in Records skip.

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

v-yetonggu-msft on at

Like (1)

Report
Hi @LuisDataReady ,

I did a test for your reference.

In my scenario:
My SharePoint List:

My Excel Table:

My Flow:

IDPart eq '@{items('Apply_to_each')?['IDPart']}' length(outputs('Get_items')?['body/value'])

The Result:

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No
ManishSolanki 15,091 Super User 2025 Season 2 on at

Like (0)

Report

Hi @LuisDataReady

Here are the steps, assuming you already have "Get items" action that contains the list items:

After "List rows present in a table", add "Apply to each" action and pass the output value object of SharePoint get items action as its input. Within apply to each block, add "Filter array" action & pass the output value object from "List rows present in a table" action as its input & in filter query compare the ID with each list item in iteration. Next, add "Condition" action to determine the length of output body return by filter array action. using expression, check if length of output body of filter array is zero and add a row in excel in the "Yes" block.

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Was this reply helpful? Yes No
LuisDataReady 2 on at

Like (0)

Report
Hi,
I tested the flow, but it stills duplicate the items.

IDPart duplicates. When I see the flow is because the condition is true and create the item again
length(outputs('Get_items')?['body/value'])

Was this reply helpful? Yes No
v-yetonggu-msft on at

Like (0)

Report

Hi @LuisDataReady ,

I have observed that your IDPart is a Number column in the SharePoint list.

What type of column is the IDPart in your excel list? Is it also a Number column?
As a reminder, in Flow's equal, the data types on both sides must be the same to be equal.

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No