Formulate multi filter for Data Table

(0) Share

Report

Posted on by asuhaimi

Hi Folks,

I'm a newbie here, any one can help me to formulate multi filter and DataInput for my below Data Table.

DataTable Items : Sort('Greyhound 2022 - ACTIVITY',Modified,Descending)

// I'm ready using sorting to put on the top.

I need 1 multi input either to use Dropdown or Combo and 2 InputText

Data Column Type: STATUS is Choice

Data Column Type: PIC is Choice (DisplayName) - able to search person name as text

Data Column Type: WORK ITEMS is Text - able to search text

If Data Table can't do multi filter, at least can help to do 1 or 2 filter (STATUS) & (PIC)

Regards

asuhaimi

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

PowerRanger 3,458 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@asuhaimi To achieve this please follow the steps below. I assume that PIC is really a choice field and no "Person or Group" field.

1. Add a DropDown to your screen and name it drpSTATUS
2. For the Items property user Choices('Greyhound 2022 - ACTIVITY'.STATUS)

3.Add a second ComboBox to your screen and name it cmbPIC
4. For the Items property use Choices('Greyhound 2022 - ACTIVITY'.PIC)
5. Disable "Allow multiple section" and enable "Allow searching" for the ComboBox

6.Add a TextInput to your screen and name it txtWorkItem

For you DataTable Items Property use this formular

Sort(Filter( 'Greyhound 2022 - ACTIVITY', STATUS.Value = drpStatus.Selected.Value || IsBlank(drpStatus.Selected.Value), PIC.Value = cmbPIC.Selected.Value || IsBlank(cmbPIC.Selected.Value), 'WORK ITEMS' = txtWorkItem.Text || IsBlank(txtWorkItem.Text) ),Modified,Descending)

This will filter your gallery based on the DropDown/ComboBox selctions and search Text in the TextInput.
All these filters are AND-Based!

For the search Text in txtWorkItems the logic is to be considered as "Exact Match".

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
asuhaimi 85 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @PowerRanger

Thanks for response. Unfortunately PIC is Person or Group but I limited only one person.

Regards
asuhaimi

Was this reply helpful? Yes No
Verified answer

PowerRanger 3,458 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
@asuhaimi In that case you have to update your formular to this:

Sort(Filter( 'Greyhound 2022 - ACTIVITY', STATUS.Value = drpStatus.Selected.Value || IsBlank(drpStatus.Selected.Value), PIC.Email = cmbPIC.Selected.Email|| IsBlank(cmbPIC.Selected), 'WORK ITEMS' = txtWorkItem.Text || IsBlank(txtWorkItem.Text) ),Modified,Descending)

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
asuhaimi 85 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @PowerRanger

Its work now.. Thanks for your helped.
But I change a bit for choice combo PIC.. because it showing email instead of Display name. I need to change here right:
Choices('Greyhound 2022 - ACTIVITY'.PIC) ..???

and one more thing if i need to change color of Ongoing status (ButtonColor), how i'm gonna do it?

Thanks in advance

Was this reply helpful? Yes No