cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Spawn10
Helper II
Helper II

How to check if item already exist in SharePoint list?

I have a list where users enter data. I am trying to build a flow that will detect if an item already exists based on an ID column, so they are no duplicate entries. How can I go about doing this? 

1 ACCEPTED SOLUTION

Accepted Solutions
v-litu-msft
Community Support
Community Support

Hi @Spawn10,

 

You could use Get items + OData filter query to approach that, for example:

ID eq 'id number'

Then use length() function to get the number of return items, if it is 0, means there is no item with ID 12 exists in the SharePoint list:

length(outputs('Get_items')?['body/value'])

Screenshot 2020-12-28 171622.jpg

 

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

1 REPLY 1
v-litu-msft
Community Support
Community Support

Hi @Spawn10,

 

You could use Get items + OData filter query to approach that, for example:

ID eq 'id number'

Then use length() function to get the number of return items, if it is 0, means there is no item with ID 12 exists in the SharePoint list:

length(outputs('Get_items')?['body/value'])

Screenshot 2020-12-28 171622.jpg

 

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
User Groups Public Preview

Join us for our User Group Public Preview!

Power Automate User Groups are coming! Make sure you’re among the first to know when user groups go live for public preview.

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Users online (49,345)