
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")
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 |