Filtering multi select columns

(0) Share

Report

Posted on by Aitor

Hi all,

I am trying to customize a form with PowerApps ...

I have a list (DocsList) in SharePoint Online with a first multi-selection drop-down column (MultiDoc) and a second multi-selection drop-down column (MultiDoc2), but I need it to offer me filtered elements that depend on the selection of the first column

So if in the first column I select Document A and Document C, in the second column it offers me to multi select Area A01, Area A02, Area C01 ... but not the rest.

To do this, I have created another list (SourceList) that contains a column with the name of the main documents and another column with the name of the corresponding areas, looking like this:

The first combo lets me select multiple elements,

Distinct('Documents and Areas (Source List)',Documento)

but the second only offers me the areas of one of the selections from the first combo (the last selected), not all the possible ones:

Filter('Documents and Areas (Source List)',Documento = DataCardValue9.Selected.Result)

Could someone guide me? I don't have much of a programming idea and I'm just starting out on this.

Thank you very much in advance and greetings to this community.

Categories:

Building Power Apps

I have the same question (1)

All responses (11)

Answers (1)

Sort by

Verified answer

CNT 10,921 Super User 2024 Season 1 on at

Like
a
(2)

Report
Copy link

Link copied!
@Aitor Because u'r first Combo is a Multi Select, u'll have to use this,
Filter('Documents and Areas (Source List)',Documento in DataCardValue9.SelectedItems)

Was this reply helpful? Yes No
Aitor 20 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you very much for your help @CNT , it has worked as I wanted!😄

Was this reply helpful? Yes No
CNT 10,921 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Aitor Glad to help!

Was this reply helpful? Yes No
Aitor 20 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @CNT (and all) again...

My joy in a well!... Everything works in Power Apps, it filters and searches correctly when I try it from there (except for the Delegating Warning, which does not worry me because I will not have more than 500 records):

But I can not save correctly the information in SharePoint. The form appears correctly and works, but on saving, it creates the record with nothing in both columns:

These are my datacards on Power Automate:

These are the advanced value properties of the combo boxes:

Any idea why it doesn't save the selected values for me?

Thanks in advance,

Was this reply helpful? Yes No
CNT 10,921 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Aitor Check the following setting for these columns in SharePoint.

Was this reply helpful? Yes No
Aitor 20 on at

Like
a
(0)

Report
Copy link

Link copied!

@CNT Yes in both columns multiple values are allowed

Was this reply helpful? Yes No
CNT 10,921 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Aitor How are you saving to the SP List? Are you using SubmitForm() or Patch?

Was this reply helpful? Yes No
Aitor 20 on at

Like
a
(0)

Report
Copy link

Link copied!

SubmitForm I think...

Was this reply helpful? Yes No
Aitor 20 on at

Like
a
(0)

Report
Copy link

Link copied!

@CNT SubmitForm

Was this reply helpful? Yes No
CNT 10,921 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Aitor The Items property for the 2 combos have something of type Documento from 'Documents and Areas (Source List)'. The two LookUp columns to which you are trying to save this information - Are they of the same type?

Was this reply helpful? Yes No