Unanswered

Canvas App SQL Delegation warning on Multiselect Combo Box

(0) Share

Report

Posted on by NotOnUrNelly76

Hi All,

I am building a rather complex filter panel for a gallery connected to a SQL view. The panel will be built using a number of Date Pickers and Multiselect Combo boxes.

I have used a work around for the date delegation issues which compares numbers rather than dates and this works fine.

The problem is I’m really struggling to find a workaround for the Multiselect combos. I have tried using the In function as in a Reza Dorani YouTube video but this was working on SP lists and the code does it work for SQL. .

Could someone please advise on a workaround. My code for a button that creates a collection for the gallery items is pasted below. I will need to replicate the final line for numberous comboboxes once I have a solution to the delegation issue.

Thanks in advance

Jamie.

ClearCollect(colFlowFilters,

Filter('sqlView',

FileReceivedint >=Value(lblFileReceievedFromNumber_1.Text) &&FileReceivedint <=Value(lblFileReceievedToNumber_1.Text),

LastUpdateint >= Value(lblLastUpdatedFromNumber.Text)&& LastUpdateint <=Value(lblLastUpdatedToNumber.Text),

IsBlank(cboOriginator.SelectedItems.Value)||IsEmpty(cboOriginator.SelectedItems)||Originator incboOriginator.SelectedItems.Value

))

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Sort by

SebS 4,867 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
@NotOnUrNelly76

You could try this in SQL In operator where Text is compare to Column is Delegable so in theory it should work I think 🙂

ClearCollect(colFlowFilters, Filter('sqlView', FileReceivedint >=Value(lblFileReceievedFromNumber_1.Text) &&FileReceivedint <=Value(lblFileReceievedToNumber_1.Text), LastUpdateint >= Value(lblLastUpdatedFromNumber.Text)&& LastUpdateint <=Value(lblLastUpdatedToNumber.Text), IsBlank(cboOriginator.SelectedItems.Value)||IsEmpty(cboOriginator.SelectedItems)||Concat(incboOriginator.SelectedItems,Value,",") in Originator ))

You may need to concat column in the same way I'm not sure how you store data in it

Contact(Orginator, Value,”,”)

Was this reply helpful? Yes No
NotOnUrNelly76 23 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Seb,

I have added the following code into the Gallery Items and the delegation warnings have dissapeared but the filters are not working.

Filter('UI.VW_FlowGas',IsBlank(ComboboxCanvas2.SelectedItems.Value)||IsEmpty(ComboboxCanvas2.SelectedItems)||Concat(ComboboxCanvas2.SelectedItems.Value,",") in Originator)
The field is a text field and only one item can be selected.

Can anyone suggest what I might be missing here.

Was this reply helpful? Yes No
SebS 4,867 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!

@NotOnUrNelly76

What Type is You Originator column, and could you provide a sample of stored data in the row please?

Was this reply helpful? Yes No
NotOnUrNelly76 23 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @SebS

The stored data type is (varchar(100),null) with a data sample same as below.

Originator
LBG
LBG
LBG
BGT
BGT

In this particular column there are only two different values but many of my other columns that I need to acheive the same search functionality have many different values.

Thank you for your help.
Jamie

Was this reply helpful? Yes No
NotOnUrNelly76 23 on at

Like
a
(0)

Report
Copy link

Link copied!

@SebS
The following code is part working it will filter the values when individually selected - LGB filters LGB values and BGT filters BGT values. The gallery blanks when I select both LGB and BGT in the combo box but when I deselect all of the values show for both BGT and LGB.

ClearCollect(colFlowFilters,
Filter('UI.VW_FlowGas',

FileReceivedint >= Value(lblFileReceievedFromNumber_1.Text) And FileReceivedint <= Value(lblFileReceievedToNumber_1.Text),
LastUpdateint >= Value(lblLastUpdatedFromNumber.Text) && LastUpdateint <= Value(lblLastUpdatedToNumber.Text),

IsBlank(cboOriginator.SelectedItems.Value)||IsEmpty(cboOriginator.SelectedItems)||Concat(cboOriginator.SelectedItems,Value,",") in Originator
))

Was this reply helpful? Yes No