cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
IMathur
Helper V
Helper V

Delegation error in Search function

Hi Experts,

I have updated the rows count to 2000 in advance setting and i am using the below formula for Items for gallery: 

Search(Filter(changepoint, ProjectStatus.Value = "Active"), OProjects_TextSearchBox1.Text ,"UserDefinedProject_ID")

 

I am getting below error while using the search function and nothing is displayed n the gallery:

IMathur_0-1596535670498.png

Please help!

2 ACCEPTED SOLUTIONS

Accepted Solutions
iAm_ManCat
Super User II
Super User II

Hi @IMathur !

 

Search is not currently delegable with many data sources, so you might want to modify your formula to the following:

 

Filter(
       changepoint,
       ProjectStatus.Value = "Active",
       //Here we check that there's something entered in the searchbox       
       Len(OProjects_TextSearchBox1.Text)=0
       // Otherwise we filter by items starting with that text
       ||
       StartsWith(OProjects_TextSearchBox1.Text ,"UserDefinedProject_ID")
)

 

If UserDefinedProject_ID is a numeric field, then you will need to change the StartsWith to:

Filter(
       changepoint,
       ProjectStatus.Value = "Active",
       //Here we check that there's something entered in the searchbox       
       Len(OProjects_TextSearchBox1.Text)=0
       // Otherwise we filter by items starting with that text
       ||
       StartsWith(Value(OProjects_TextSearchBox1.Text) ,"UserDefinedProject_ID")
)

 

 

Let me know if you run into any issues,

 

Cheers,

Sancho

@iAm_ManCat


Please 'Mark as Solution' if someone's post answered your question and always 'Thumbs Up' the posts you like or that helped you!


Thanks!
You and everyone else in the community make it the awesome and welcoming place it is, keep your questions coming and make sure to 'like' anything that makes you 'Appy
Sancho Harker, MVP


View solution in original post

Hi ,

Happened to make the issue work (and results are populated after search is done using OProjects_TextSearchBox1) with below formula in Gallery> Items>

Filter(changepoint, ProjectStatus.Value = "Active", OProjects_TextSearchBox1.Text in UserDefinedProject_ID)

View solution in original post

3 REPLIES 3
iAm_ManCat
Super User II
Super User II

Hi @IMathur !

 

Search is not currently delegable with many data sources, so you might want to modify your formula to the following:

 

Filter(
       changepoint,
       ProjectStatus.Value = "Active",
       //Here we check that there's something entered in the searchbox       
       Len(OProjects_TextSearchBox1.Text)=0
       // Otherwise we filter by items starting with that text
       ||
       StartsWith(OProjects_TextSearchBox1.Text ,"UserDefinedProject_ID")
)

 

If UserDefinedProject_ID is a numeric field, then you will need to change the StartsWith to:

Filter(
       changepoint,
       ProjectStatus.Value = "Active",
       //Here we check that there's something entered in the searchbox       
       Len(OProjects_TextSearchBox1.Text)=0
       // Otherwise we filter by items starting with that text
       ||
       StartsWith(Value(OProjects_TextSearchBox1.Text) ,"UserDefinedProject_ID")
)

 

 

Let me know if you run into any issues,

 

Cheers,

Sancho

@iAm_ManCat


Please 'Mark as Solution' if someone's post answered your question and always 'Thumbs Up' the posts you like or that helped you!


Thanks!
You and everyone else in the community make it the awesome and welcoming place it is, keep your questions coming and make sure to 'like' anything that makes you 'Appy
Sancho Harker, MVP


View solution in original post

Hi @iAm_ManCat ,

 

Thanks for the reply!

The formula is able to get the results in gallery, but when i search the text box with the column item "UserDefinedProject_ID", it is not bringing any results, please see the image below:

IMathur_0-1596542268800.png

 

Further to search , i also want to apply sorting on the basis of UserDefined Project_ID

Hi ,

Happened to make the issue work (and results are populated after search is done using OProjects_TextSearchBox1) with below formula in Gallery> Items>

Filter(changepoint, ProjectStatus.Value = "Active", OProjects_TextSearchBox1.Text in UserDefinedProject_ID)

View solution in original post

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

secondImage

Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Power Apps June 2021

June Power Apps Community Call

Did you miss the call? Check out the recording here!

Top Solution Authors
Top Kudoed Authors
Users online (30,299)