Answered

Filtering SQL from Combobox

(0) Share

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 (2)

Answers (1)

subsguts 1,259 Moderator on at

Like (0)

Report

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 on at

Like (0)

Report
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