Filter Gallery by multiple choice options

(0) Share

Report

Posted on by sammvarley

Hi,

I have a Gallery that I'd like to filter. I currently have:

Filter(
MIS_Task_Tables,
Staff = 'Staff (MIS_Task_Tables)'.'NAME',

Status (cr74f_status)' = 'Status (MIS_Task_Tables)'.'Awaiting Allocation'

)

And that works fine, but I'd like to be able to search 'In progress' in the status column as well. So in English, 'filter the task table by Staff Column/NAME, AND Status Column/Awaiting Allocation OR In Progress'

Thanks

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (1)

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

Like (0)

Report
Hi @sammvarley ,

Assuming the Staff column is a Lookup column (to the AAD table or the Users table), and that both the Staff and the Status choice column are assigned to Combo Box controls, you can try:

Filter( MIS_Task_Tables, Len(Your_Staff_ComboBox.Selected.'Full Name') = 0 || Staff .'Full Name' = Your_Staff_ComboBox.Selected.'Full Name', Len(Your_Status_ComboBox.Selected.Value) = 0 || Status in Your_Status_ComboBox.SelectedItems )

Note in the above example, "Staff" is a Lookup to the Users table. If "Staff" is a Lookup to the AAD table, then "Full Name" does not exist as a column. For the AAD column, the equivalent column is "Display Name".

------------------------------------------------------------------------------------------------------------------------------

If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
sammvarley 11 on at

Like (0)

Report

Hi,

Thanks for replying! I don't think it's a combo, it's a choice select column. So I have one choice column that is a selection of staff names, and another choice column in the same table that has task distribution choices, two being 'In progress' and 'Awaiting Allocation'. I want to be able to filter for one name choice in the first column, and two choices in the second column.

I could figure out how to search one choice from each column, but not the OR part of the second column, where it needs to filter 'in progress' OR 'awaiting allocation'

Was this reply helpful? Yes No
Verified answer

sammvarley 11 on at

Like (0)

Report

I figured it out:

Filter(
MIS_Task_Tables,
Staff = 'Staff (MIS_Task_Tables)'.'NAME',
Or('Status (cr74f_status)' = 'Status (MIS_Task_Tables)'.'Awaiting Allocation', 'Status (cr74f_status)' = 'Status (MIS_Task_Tables)'.'Working on it')
)

Was this reply helpful? Yes No