web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Combobox filter based ...

Power Apps

Answered

Combobox filter based on the Yes/No column of the SharePoint List

(0) Share

Report

Report

Posted on by caligame

38

Hello PowerApps Community,

I am trying to filter out available choices on the combobox based on the yes/no column of the SharePoint List.

The yes/no column of the Sharepoint list does not need to be on the PowerApps form. But, use as for Game Title's Requestable reference only.

Not sure how I can achieve this but here are the details of the current data and situation:

-Items function-

Game Title = Choices('Product Details - Test'.Game)

-Data-

Game Title	Requestable
A	Yes (Checked)
B	Yes (Checked)
C	Yes (Checked)
D	No

The result and user can select from the Game Title combo box as 'A', 'B', OR 'C' only.

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (1)

Sort by

Verified answer

LaurensM 12,516 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @caligame,

If Game Title is also a choice field, could you try the code below in the Items property of that dropdown:

With( { //Temp store all unique game titles with the requestable value 'no' choiceValNo: Distinct( Filter( 'Product Details - Test', Requestable = false ), Game.Value ) }, //Only display the choice options not contained in that filtered list Filter( Choices('Product Details - Test'.Game), !(Value in choiceValNo) ) )

If this solves your question, would you be so kind as to accept it as a solution.
Thanks!

Was this reply helpful? Yes No
CNT 10,921 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@caligame

Please try the following,

Filter('Product Details - Test', Requestable=true)

Please remember to give a 👍 and accept my solution as it will help others in the future.

Was this reply helpful? Yes No
caligame 38 on at

Like
a
(0)

Report
Copy link

Link copied!

@LaurensM Thanks! I have changed Requestable = True and removed ! from the filter to display the Yes option only.
All working good! Thanks for the support.

Was this reply helpful? Yes No

Join the conversation