Filter Gallery using two combo boxex connected to two multiselect choice columns

(0) Share

Report

Posted on by zerocool55

Hi,

I'm trying to filter my gallery using two combo boxes each linked to a choice multi select SharePoint column.

I'm using the follwing code, it allow me to filter to some extend but i'm not able to display any record that is under two choices. or more

looking forward for your support

With(
{
kData: Filter(
Sort(
PortfolioProjectList,
Modified,
SortOrder.Descending
),
VarUserEmail in BO.Email || VarUserEmail in BusinessPartner.Email || VarUserEmail = BUPortfolioOwner.Email || VarUserEmail = ProjectApplicant.Email
)
},
Sort(
AddColumns(
Filter(
kData,
(Len(Performance.Selected.Value) = 0 || IsEmpty(Performance.SelectedItems) || Concat(
'BusinessUnit(s)'.Value,
ThisRecord.Value,
", "
) in Performance.SelectedItems.Value) && (Len(HRSub.Selected.Value) = 0 || IsEmpty(HRSub.SelectedItems) || Concat(
'HRSubFunction(s)'.Value,
ThisRecord.Value,
", "
) in HRSub.SelectedItems.Value)
),
"StatSort",
Switch(
Status.Value,
"Approved",
1,
"Applied",
2,
"Draft",
3
)
),
StatSort
)
)

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

bnastase 17 on at

Like
a
(0)

Report
Copy link

Link copied!

Okay a few things: your filtering logic is reliant on the Concat function to generate a string from multi-choice column values and then check if this concatenated string is in the selected items of your combo box. This method can be problematic if there are multiple selections because it expects the concatenated string to match the selection exactly.

Try this: With(
{
kData: Filter(
Sort(
PortfolioProjectList,
Modified,
SortOrder.Descending
),
VarUserEmail in BO.Email || VarUserEmail in BusinessPartner.Email || VarUserEmail = BUPortfolioOwner.Email || VarUserEmail = ProjectApplicant.Email
)
},
Sort(
AddColumns(
Filter(
kData,
(Len(Performance.Selected.Value) = 0 || IsEmpty(Performance.SelectedItems) || CountRows(Intersect(Performance.SelectedItems, 'BusinessUnit(s)'.Value)) > 0) &&
(Len(HRSub.Selected.Value) = 0 || IsEmpty(HRSub.SelectedItems) || CountRows(Intersect(HRSub.SelectedItems, 'HRSubFunction(s)'.Value)) > 0)
),
"StatSort",
Switch(
Status.Value,
"Approved",
1,
"Applied",
2,
"Draft",
3
)
),
StatSort
)
)

This should help improve your filtering for records that have multiple choices.

Was this reply helpful? Yes No
zerocool55 94 on at

Like
a
(0)

Report
Copy link

Link copied!

hi @bnastase
I can't try your code as we can't use intersect in powerapps

Was this reply helpful? Yes No