How to check if list items exists in a SharePoint list

  • 28 December 2020
  • 1 reply
  • 103 views

Badge +6

I am in SP 2016. I have a customer and orders lists. Using my workflow, I am retrieving customer id from the customer list. I want to use the same id to grab information from the orders list. But before doing that want to check if that entry is already there in the Orders list. 

 

I am thinking of creating a switch or if then statement. If record is there, update it. If not, create it. How do I check if the record is already there. How do I check for blank values?

 

Your help is appreciated.


1 reply

Badge +7
Hi,

I would use a Query List-action to see if you can find Customer-information in your Orders-list. Information is put inside a collection. Then you can use a condition to check if your collection contains values or not.

Hope this helps!

Reply