Announcements
I have an requirement that i added the invoice column in collection. Now i need to check whether the invoice no already exist in the collection or not? I got stuck with this . Please help me to achieve this.
@Abhilash
Utilize the LookUp function for this...
ex. LookUp(yourCollection, criteria, true) will return a true if there is such a record and false if not.
I hope this is helpful for you.
You will just do a check on if countrows invoice="number" = 0 then it does not exist, else it does
@TheRobRush @RandyHayes thanks for your suggestion, I tried with the suggestion but if the collection has invoice no 1 and 2 then i search the value again with 1 it is showing the count value as 2. how to resolve this?
drop a screenshot of how you have your data source set up and i will write you an example true false return on a check of it
You should simply by using the LookUp(yourCollection, criteria, true) function.
So, if you have invoice 1 and invoice 2 in your list, then LookUp(yourCollection, InvoiceNumber=1, true) will return true. If you do LookUp(yourCollection, InvoiceNumber=3, true) you will have false.
What is it that you are ultimately trying to do with the lookup into the list? You might be overcomplicating if this is part of some logic to update items or create them.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 329 Most Valuable Professional
11manish 209 Super User 2026 Season 2
Mohsin Ali 179
