Answered

Filter sharepoint lookup.

(1) Share

Report

Posted on by StevieC

137

I have a SharePoint list called Applications with a lookup column to the another list called Platforms. I have modified the form for the list in PowerApps and all works well. The issue is that the Platforms look up list contains items I don't want to include for users to select - these are identified by a choice field (single select) called Status.

I've tried to work out how to Filter the Items in the drop down in the form, including creating a collection which I try to filter, but as the field is seen as a table, I can't work out how to do something like:

ClearCollect('Platforms', Filter('Platforms', 'Status'.Value <> 'Decommed))

I get various different errors (delegation etc) but I'm not sure if I'm even starting this the right way!! Any help/guidance greatly appreciated :)

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

WarrenBelz 155,949 Most Valuable Professional on at

Like
a
(2)

Report
Copy link

Link copied!
Hi StevieC

Your issue is the Not (in your case not equals) is not Delegable. You need to list all the Status values you want to include, rather than the one you want to exclude.

ClearCollect( 'Platforms', Filter( 'Platforms', 'Status'.Value = Status1 || 'Status'.Value = Status2 || 'Status'.Value = Status3 ) )

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
MVP (Business Applications) Visit my blog Practical Power Apps Buy me a coffee

Was this reply helpful? Yes No
StevieC 137 on at

Like
a
(1)

Report
Copy link

Link copied!

Spot on!!!! Easy when you know how :)

Cheers WarrenBelz

Was this reply helpful? Yes No