Answered

How to check if an item exists on a SharePoint list

(2) Share

Report

Posted on by sherwintan77

I have an EmployeeID field in Microsoft Forms. When the form is submitted, I'd like to check if the EmployeeID exists in a Sharepoint List I've created (Employees table with column name EmployeeID). If it does not exist, Send email to notify me.

Any help would be appreciated!

All responses (21)

Answers (1)

martrinthompson 2 on at

Like (0)

Report

Re: How to check if an item exists on a SharePoint list

Hi I have used this approach but I am always getting false from the condition regardless of if the item exists or not. Please can someone help I have looked everywhere and tried everything.

This is the get items output cut down yo start and end. of my last run where an item exits so should be updated but a new one is created.
{"statusCode":200,"headers"
,"Content-Length":"12"},"body":{"value":[]}}
wdg 3 on at

Like (0)

Report

Re: How to check if an item exists on a SharePoint list

What if you cannot use filter query? I was filtering email addresses but when I had an email with a ' in it, it broke the flow. I am trying to compare an email address from one list to see if it exists on the other list. If it does, it updates the information, if it does not exist then I want to create it on the final list.
Community Power Pla... on at

Like (0)

Report

Re: How to check if an item exists on a SharePoint list

Hi @faustocapellanj

thank you for your flow example... it is pretty much like for like for what I need. However, it won't let me use the formula and keeps saying .....

Any ideas?

Basically I'm trying do do very similar. I have a database which holds empoyee Information (SHEQ Admin). Every employee has a unique employee number.
Weekly a list will be uploaded with current employees (Cascade list) and I want the flow to check current employee Numbers (Cascade) against the database list employee numbers (SHEQ Admin).

Thank you so much in advance.
Florin1 4 on at

Like (0)

Report

Re: How to check if an item exists on a SharePoint list

Hi,

I'm new in sharepoint flow and i need a little bit more help if it's posssible :
- i have 2 lists : list1 and list2
- list1 has a column "serialnumber1"
-list2 has a column " serialnumber2"

what i want , when a new item it's added in list1 , to check "serialnumber1" if exist in list2 in "serialnumber2".

thank you in advance!
faustocapellanj 1,662 on at

Like (0)

Report

Re: How to check if an item exists on a SharePoint list

Ah, got it. I see this approach is excellent in the event you don't know if the list is set up to only follow a unique ID approach. I will definitely keep that expression handy. Thanks for that.
Berny 93 on at

Like (0)

Report

Re: How to check if an item exists on a SharePoint list

I completely agree - In my list I was expecting to just find one item but there were a few "issues" where there were multiple items found. So changing it to allow for the multiple items seems like a great idea as it works for either one or more than one item identified.
faustocapellanj 1,662 on at

Like (0)

Report

Re: How to check if an item exists on a SharePoint list

Hi @Berny

I'm glad the solution helped you with your issue. The case with the original post was to look for one specific list item since the EmployeeID value would be unique, making this a one-to-one case. As for your suggestion, it is a great idea, but this would be excellent in a one-to-many scenario where you are looking for a value and the query will return several items.

Thank you for the suggestion.

Fausto Capellan, Jr
Berny 93 on at

Like (0)

Report

Re: How to check if an item exists on a SharePoint list

I just wanted to say thanks for posting the detaild work through for this issue. I really appreciate it since it helped me solve a similar issue.

One thing to add is the condition should be Greater than or equal to incase there are multiple items with the same search criteria
@greaterOrEquals(length(body('Get_items')?['value']), 1)
faustocapellanj 1,662 on at

Like (1)

Report

Re: How to check if an item exists on a SharePoint list

Hi @sherwintan77

I'm glad that it worked. Please do not hesitate to reach out if you ever need help.

Regards,
Fausto Capellan, Jr
sherwintan77 62 on at

Like (0)

Report

Re: How to check if an item exists on a SharePoint list

Brilliant! This worked! Thanks much Fausto!