Answered

ComboBox - DefaultSelectedItems - Filter Items based on Table

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi!

I need for the DefaultSelectedItems property of my ComboBox to display items based on the filtering of a table.

I have the following formula - Filter(Markets.'Market Name', 'Market Name' in Split(ProjectList_Gallery.Selected.Multimarket,",")).'Market Name'

Basically I need to filter the DB called Markets and display as DefaultSelectedItems in my ComboBox all the values that match from the table created by Split(ProjectList_Gallery.Selected.Multimarket,","). At the moment the Split function is working as expected but for some reason there is only 1 market showing as DefaultSelectedItems.

Any ideas?

Thanks in advance 🙂

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Left you some screenshot in case seeing how the formula is redacted helps. As you may see, the Markets DB has a lot of records, the Split function is returning 2 records (austria, france) but the final Filter formula only returns 1 (austria)

Was this reply helpful? Yes No
v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous,

I have a test on my side, and it works as expected:

I have found that you have column name mixed issue, not sure how you configure your data, however, I have found that your 'Market Name' column exists as Title column name.

Not sure if it is the key, but I suggest you modify your formula as below:

Filter(Markets, Title in Split(ProjectList_Gallery.Selected.Multimarket,","))

If Power Apps does not recgonizes Title column, replace it with 'Market Name'.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Qi! Thanks for the response.

I've tried what you suggested but still the same unfortunately. My DB for Markets is a SharePoint list and reckon that the difference between "Title" and "Market Name" is purely semantical as the column in the list is named "Market Name" but the PowerApps for some reason recognizes it as "Title". I've tried also using the same formula in a gallery as you showed in the screenshots but still showing just one market.

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous,

Actually it is an easy logic issue, however, not sure how you configure your data source and some hidden clue are holding your back.😂

In general, to filter the items both existing in two colums, we used to write:

Filter(Data1, Column1 in Data2.Column2)

You could try to simplize your formula to fit it.

Was this reply helpful? Yes No