2
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.
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
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
Share
Report
All responses (
Answers (
length(outputs('Get_items')?['body/value'])
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.
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
#1
Michael E. Gernaey
497
Super User 2025 Season 1
#2
David_MA
436
Super User 2025 Season 1
#3
Riyaz_riz11
244
Super User 2025 Season 1
