Answered

Creating Dropdown filter boxes using Choice-type Data Column for List

(0) Share

Report

Posted on by lchen26

Hi Folks,

I have a Power App I've created that is connected to a List in my team's Sharepoint space. I'm attempting to add a Dropdown box to my Browse Screen to help filter my Browse Gallery results.

The (first) issue I have is that when attempting to select a data column for my Dropdown Item, I don't see any Choice-type data columns to. I see Text columns, Number Columns, etc, but not the one I want (a choice column of Equipment types [CPU, Laptop, Macbook, etc]) to select.

What code tweaks should I be making? Should I be using a different object type entirely on my Browse Screen?

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@lchen26

Do you have a choice column in your list? If so, then you can set the Items property of the Dropdown to: Choice([@yourList].yourChoiceColumn) this will give you all of the choices in the dropdown.

You can use that selected value then to filter the gallery.

I hope this is helpful for you.

Was this reply helpful? Yes No
lchen26 28 on at

Like (0)

Report
Copy link

Link copied!

Hi Randy,

Where would I set this code? The most likely place I could find, in the Property>Items location, only shows my linked sharepoint list as a possible selection. Attempting to manually enter the code you mentioned wouldn't confirm

Was this reply helpful? Yes No
Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

@lchen26

Please use the formula editor at the top of the designer screen and choose the Items property from the left dropdown. Then enter the formula provided there.

Was this reply helpful? Yes No
lchen26 28 on at

Like (1)

Report
Copy link

Link copied!

Ah, that makes sense. The function appears to have been renamed to Choices() plural, but I was indeed able to enter the formula into the Function bar and get it working. Thanks for your guidance!

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@lchen26

Oops, my bad! I meant Choices

It was a slip.

Glad you were able to get that working!

Was this reply helpful? Yes No