web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Filter Dataverse Multi...

Power Apps

Answered

Filter Dataverse Multi Select Choice Column

(0) Share

Report

Report

Posted on by FaerchDK

36

I have a table with a choice column.

The choice column is linked with the global choice "JFI Location Choices" and I have enabled "Selecting multiple choices is allowed".

The Choice Column:

The Table:

I now want to filter the table based on a Combo Box (DataCardValue17) that is connected to the same global choice.

These formula doesn't work. It just gives me all the items in the table.

Filter('[JFI] Area', DataCardValue17.Selected in 'JFI Location')

Filter('[JFI] Area', DataCardValue17.Selected.Value in 'JFI Location')

If I hardcode the selected choice it does work (with a delegation warning)

Filter('[JFI] Area', 'JFI Location Choices'.'Internal Transport' in 'JFI Location')

How do I get the filter to work with the selected value from the Combo Box?

This is the desired result:

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

Ami K 15,687 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!
@FaerchDK - assuming the ComboBox Items property contains:

Choices('JFI Location')

Then use:

Filter( '[JFI] Area', 'JFI Location' in DataCardValue17.SelectedItems )

Was this reply helpful? Yes No
FaerchDK 36 on at

Like (0)

Report
Copy link

Link copied!

@Amik Thanks

Was this reply helpful? Yes No

Join the conversation