Power Platform Community Forum Thread Details

I have to Sharepoint lists.

One list is called "Warranty" and another list is called "Product".

In the Warranty list there is a loockup Field called "Products" that is looking up Products from the "Product list", and it is possible to Select multipple Products. 1-10 Products can be selected in one single Warranty registration.

When i register a New Warranty item, and I select some Products(in the multiselect Field), i like to now if any of these Products already are registered in a another warranty item, and it it is - i like to display a Message.

How can i check if a Product already are registrated in another Warranty item? Any idea. ? Thank you.

Categories:

Building Power Apps

Hey @TrulsB,

maybe this one helps you:
I'm having a similiar function in one of my apps.
When a user is typing in another users name i'm checking whether the user is in the specific list. In my case "Master data".

I'm using this function and i could image that this one could work for your case by just adding .value to the column you want to filter.
This is the function i use on my error Textbox:

If(Or(IsBlank(UserName.Text);UserName.Text in Filter(MasterData;Department.Value="Sales").UserName);false;true)

So in my case if the Textbox is left Blank or the Typed in UserName is in my Masterdata Table, the error won't occure, otherwise it gets visible.

I would try adding the .value to the (in my case) last UserName.

I did not test it, but maybe this one helps you 🙂

kind regards

kim