cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
gazzo1967
Level 8

delegation Help Needed :(

HI All

I have a gallery which is being used to gather peninputs for a register.

It seems as per standard that i am having delegation issues with my filter not returning all records based on the filter criteria.

i am filtering using a textinput based on title and a field being blank, here is my formula

Filter(Course_Registration,Title=CourseFilter_1.Text,signature = Blank())

 

how can i rewrite this as a non delegation function..

 

I have not exceeded any limits ( i have 30 records for test)

 

Help very appreciated 

Gary

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Dual Super User
Dual Super User

Re: delegation Help Needed :(

Hi @gazzo1967 

 

I believe you are storing the signature as base64 format in a multi line text field

Problem is multi line text columns are not delegable when used in queries

 

So your best bet will be either to create a single line of text column and if no siganture then populate it with "No" else "Yes"

and query on this field to avoid delegation (whereas your data can continue to reside in the multi line field)

 

Another option would be to collect data from your data source in batches of 2k (delegation limit) and then filter on collection

 

Regards,

Reza Dorrani

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

View solution in original post

7 REPLIES 7
Super User
Super User

Re: delegation Help Needed :(

If Course_Registration is a SharePoint data source then the formula looks delegable. Are you getting the yellow delegation warning or is there a blue squiggle line under any piece of the formula when you cursor is in the formula box?



--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.
gazzo1967
Level 8

Re: delegation Help Needed :(

@Jeff_Thorpe 

Hi Jeff

The triangle

Gary

Super User
Super User

Re: delegation Help Needed :(

Is Course_Registration a SharePoint list data source and is Signature a text column in the SharePoint list?



--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.
Highlighted
Dual Super User
Dual Super User

Re: delegation Help Needed :(

Hi @gazzo1967 

 

I believe you are storing the signature as base64 format in a multi line text field

Problem is multi line text columns are not delegable when used in queries

 

So your best bet will be either to create a single line of text column and if no siganture then populate it with "No" else "Yes"

and query on this field to avoid delegation (whereas your data can continue to reside in the multi line field)

 

Another option would be to collect data from your data source in batches of 2k (delegation limit) and then filter on collection

 

Regards,

Reza Dorrani

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

View solution in original post

gazzo1967
Level 8

Re: delegation Help Needed :(

@RezaDorrani 

WOW how did you know that one????

 

Thank you worked perfectly just by changing column type!

 

@Jeff_Thorpe 

Thank you for responding Jeff

Dual Super User
Dual Super User

Re: delegation Help Needed :(

Hi @gazzo1967 

 

a wild guess 🙂

gazzo1967
Level 8

Re: delegation Help Needed :(

@RezaDorrani 

May the force be with you lol

Gary

Helpful resources

Announcements
thirdimage

Power Apps Super User Class of 2020

Check it out!

thirdimage

New Badges

Check it out!

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

SecondImage

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors
Users online (5,284)