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

All responses (4)

Answers (0)

Sort by

v-yetonggu-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
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
Manish Solanki 15,169 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

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.
LuisDataReady 2 on at

Like
a
(0)

Report
Copy link

Link copied!
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'])
v-yetonggu-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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