dropdown should show only true choices

(0) Share

Report

Posted on by AlexanderGjr

Hi all,

working on a power app which is generally a PDF library.

This time I am stuck on filtering items displayed in dropdown.

I am using a SP library which containing all the PDF files, with additional columns for further details e.g. autor, book title, year...

One column is type of choice, multiple = category. So a single PDF file (book) can be assigned to several categories.

But there are also choices which are not assigned to a book yet.

So I do not want that "empty" choices are visible in the dropdown menu.

To show all choices in dropdown I am using:

Choices(SPlibrary.ColumCategory)

Category1

Category2

Category3 (empty, not assigned to book yet)

Category4 (empty, not assigned to book yet)

Category5

So goal is that selection of the dropdown only shows:

Category1

Category2

Category5

Appreciate any advise.

Thanks and Regards, Alexander

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Drrickryp Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@AlexanderGjr

Use a combobox control with Items property: Filter(Choices(SPlibrary.ColumCategory),Value="Category1"||Value="Category2"||Value="Category5")

Was this reply helpful? Yes No
AlexanderGjr 16 on at

Like (0)

Report
Copy link

Link copied!

@Drrickryp thanks, but just recognized that I missed to add a requirement.
This statement have to be dynamic: Value="Category1"||Value="Category2"||Value="Category5"

Let's assume I have two PDF Files uploaded:
book1 = Category1 + Category2
book2 = Category5
dropdown shows categories 1,2,5

next time when I upload another book:
book3 = Category4 + Category2
dropdown will show categories 1,2,4,5

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@AlexanderGjr

Ultimately, will you want to select a category and display the books and alternatively, select a book and see its categories.

Was this reply helpful? Yes No
AlexanderGjr 16 on at

Like (0)

Report
Copy link

Link copied!

@Drrickryp
kind of, app is already displaying books by filtering through dropdown, if user select a book, all categories shown in a text label too.

as the library is slowly growing, users have to many selections which are useless at the moment, so I want to get rid of them as long no book carries this category

Was this reply helpful? Yes No
AlexanderGjr 16 on at

Like (0)

Report
Copy link

Link copied!
By using this:

Distinct(SPlibrary, ColumCategory). Result

I end up with a dropdown showing 5 empty options.
What do I miss?

guess I have to convert the type somehow

Was this reply helpful? Yes No