You’re offline. This is a read only version of the page.
11
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
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')
)
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'
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:
Share
Report
All responses (
Answers (
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.
#1
stampcoin
17
#2
mmbr1606
15
Super User 2025 Season 1
#3
ankit_singhal
11
Super User 2025 Season 1
