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:

Connecting to Data

General Questions

All responses (11)

Answers (1)

Aitor 20 on at

Like (0)

Report

Re: Filtering multi select columns

@CNT I think yes. You are asking about the created columns on SharePoint, that's right?. These are the LookUp columns on the destination list (where I am editing the Form on Power Apps):
And these are the columns on the Source List (Documento and Área):
Thanks for your time helping me
CNT 10,919 Super User 2025 Season 1 on at

Like (0)

Report

Re: Filtering multi select columns

@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?
Aitor 20 on at

Like (0)

Report

Re: Filtering multi select columns

@CNT SubmitForm
Aitor 20 on at

Like (0)

Report

Re: Filtering multi select columns

SubmitForm I think...
CNT 10,919 Super User 2025 Season 1 on at

Like (0)

Report

Re: Filtering multi select columns

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

Like (0)

Report

Re: Filtering multi select columns

@CNT Yes in both columns multiple values are allowed
CNT 10,919 Super User 2025 Season 1 on at

Like (0)

Report

Re: Filtering multi select columns

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

Like (0)

Report

Re: Filtering multi select columns

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,
CNT 10,919 Super User 2025 Season 1 on at

Like (0)

Report

Re: Filtering multi select columns

@Aitor Glad to help!
Aitor 20 on at

Like (0)

Report

Re: Filtering multi select columns

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