Answered

Help with Filtering a Gallery and Variable

(0) Share

Report

Posted on by janineb

Good day

I have a gallery with the following Items (linked to a SQL database):

Filter(SubmissionRatingsAdmin, CorpSecDateInt = Year(DatePicker1.SelectedDate)*10000 + Month(DatePicker1.SelectedDate)*100 + Day(DatePicker1.SelectedDate) And CorpSecCommittee in Dropdown2.SelectedText.Committee)

Unfortunately it gives me a Delegation error. Please assist me to declare a variable to get rid of the error?

Thank you

Janine

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

WarrenBelz 153,084 Most Valuable Professional on at

Like (0)

Report
Hi @janineb ,

Other than the in Filter (which I think is Delegable in SQL), you can do this

With( { wInt: Year(DatePicker1.SelectedDate)*10000 + Month(DatePicker1.SelectedDate)*100 + Day(DatePicker1.SelectedDate) }, Filter( SubmissionRatingsAdmin, CorpSecDateInt = wInt && CorpSecCommittee in Dropdown2.Selected.Committee ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
janineb on at

Like (0)

Report

Hi Warren
I still have the delegation warning on the gallery. Any other suggestions perhaps? Thank you

Was this reply helpful? Yes No
janineb on at

Like (0)

Report

It is also not returning any items, although there are items in the database?

Was this reply helpful? Yes No
WarrenBelz 153,084 Most Valuable Professional on at

Like (0)

Report

Hi @janineb ,

I simply copied your values and shifted the variable you were creating in the body of the filter outside it (and away from Delegation scrutiny), so it has not changed your filter functionality. If the in Filter is not Delegable in SQL, then you cannot make this Delegable, however this guide (which is normally accurate) says it is.

Was this reply helpful? Yes No
Verified answer

janineb on at

Like (0)

Report

Thank you - there is nothing wrong with your code - it is perfect 🙂 as always. I just don't understand why the filter is not returning any items (it was not working before either).

Was this reply helpful? Yes No
WarrenBelz 153,084 Most Valuable Professional on at

Like (0)

Report
@janineb ,

So you are saying it was not working before ? Put this in a label

Year(DatePicker1.SelectedDate)*10000 + Month(DatePicker1.SelectedDate)*100 + Day(DatePicker1.SelectedDate)

and ensure you have the same value in field CorpSecDateInt in SubmissionRatingsAdmin in at least one record and this record also contains a value in CorpSecCommittee you have selected in your drop-down.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No