web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Filtering SQL from Com...

Power Apps

Answered

Filtering SQL from Combobox

(0) Share

Report

Report

Posted on by Tommy-Upton

119

I'm trying to filter a dropdown from a combobox.selected items. Data source is SQL for both. I believe you can't filter directly, so I have an OnChange event for combobox to concat the list of selected items together and then filter dropdown from that selected list. Like this pseudocode:

ComboBox OnChange():

UpdateContext({varBranchCodes:Concat(cboBranches.SelectedItems,branchcode,", ")})

Then, for dropdown Items():

Filter(Active_Patients, varBranchCodes in CltBranch)

This works fine if there are 1 BranchCode selected, but as soon as I choose 2 or more, the "in" statement doesn't return any records. I can go to the SQL source and select using those BranchCodes and return data no problem. What am I doing wrong?

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

subsguts 1,259 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

did you read this post: Solved: Issue with "in" operator inside "Filter()" functio... - Power Platform Community (microsoft.com)

Sounds like it may be the answer to your question too?

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 @Tommy-Upton,

Modify the formula as below:

Filter(Active_Patients, varBranchCodes in Concat(CltBranch,CltBranch,","))

This formula will filter items that includes all the value selected in the combo box.

(the combo box select a,b; you will only get records with value like this: a,b,c ; ab,d)

ForAll(cboBranches.SelectedItems,Filter(Active_Patients,branchcode in CltBranch))

If you want to filter items that only includes parts of value selected in the combo box, you could try this:

(the combo box select a,b; you will get records with value like this: a,c ;b,c ;a,b,c)

Was this reply helpful? Yes No

Join the conversation