Filtering lookup items from sharepoint

(0) Share

Report

Posted on by ZacHare

Hi,

Long story short, I have a SharePoint lookup column in my list. Rather than showing all options in the forms field, I just want to show a specified selection to choose from. I am trying with the code below to filter using And operators. Is this correct?

Filter('Class List', Class = "class1" And "class2" And "class3")

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (0)

AhmedSalih

6,678 Moderator on at

Like (0)

Report

Re: Filtering lookup items from sharepoint

Hello, @ZacHare, if you are trying to show the records of either classes, use this:

Filter('Class List', Class = "class1" || Class = "class2" || Class = "class3")

If my reply helped you, please give a 👍 , & if it solved your issue, please give a 👍 & Accept it as the Solution to help other community members find it more.

I am primarily available on weekdays from 6-10 PM CT and 5-10 PM CT on weekends.

Visit my Blog: www.powerplatformplace.com

Visit my YouTube Channel: https://www.youtube.com/@powerplatformplace/videos