cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ammarfassy
Helper III
Helper III

Part of this search formula cannot be evaluated due to service limitations

Dears,

 

I am getting the below errror:

 

Suggestion: Part of this search formula cannot be evaluated due to service limitations. The local evaluation may produce suboptimal or partial results. If possible simplify the formula. For more information, please see the Search function documentation 

 

the forumula which i am using is:


Distinct(Filter('PharmaApp-MainMapperExcel', Medical_x0020_Rep_x003a_Email.Value=UserMainEmail), Hospital.Value)

 

the field Medical_x0020_Rep_x003a_Email is a lookup field on the list. if i use a colum other than a lookup column formula is fine. But i have to filter the data based on the medical reps email.

 

Please help me. 

2 ACCEPTED SOLUTIONS

Accepted Solutions
Jeff_Thorpe
Super User
Super User

That error should also cause a blue dot to show up because the query isn't delegable. I am guessing that your data source is SharePoint because SharePoint has many field types that are considered complex (Choice, Lookup, Date, Person/Group, Metadata and etc) and are not delegable.  In this case it looks like the Medical_x0020_Rep_x003a_Email is a choice or lookup field which will cause the non-delegable query warning.

 

If your list size is under 2,000 then you have some options. The default non-delegable query row limit is 500 but that can be increased to 2,000 by using the setting listed on the article link below.

 

PowerApps data row limit for non-delegable queries



--------------------------------------------------------------------------------
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.

View solution in original post

Everything Jeff said. I will just pile on.

 

Basically, I have tried to stop using LookUp columns in SharePoint all together with PowerApps. There are just a bunch of gotchas. What you can do is make the LookUp functionality in your App. You can connect to multiple lists and drive your dropdown off the data from the other list. In the App it all works the way you expect and no more delegation issues. The only time this doesn't work is if you need the lookup functionality to work while someone is using SharePoint instead of your App. I have videos on all of this if you need.

 

Shane - Microsoft MVP, YouTube, and PowerApps Consulting for when you are in a bind to get this fixed quickly. And finally we now have PowerApps Training

View solution in original post

6 REPLIES 6
Jeff_Thorpe
Super User
Super User

That error should also cause a blue dot to show up because the query isn't delegable. I am guessing that your data source is SharePoint because SharePoint has many field types that are considered complex (Choice, Lookup, Date, Person/Group, Metadata and etc) and are not delegable.  In this case it looks like the Medical_x0020_Rep_x003a_Email is a choice or lookup field which will cause the non-delegable query warning.

 

If your list size is under 2,000 then you have some options. The default non-delegable query row limit is 500 but that can be increased to 2,000 by using the setting listed on the article link below.

 

PowerApps data row limit for non-delegable queries



--------------------------------------------------------------------------------
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.

Everything Jeff said. I will just pile on.

 

Basically, I have tried to stop using LookUp columns in SharePoint all together with PowerApps. There are just a bunch of gotchas. What you can do is make the LookUp functionality in your App. You can connect to multiple lists and drive your dropdown off the data from the other list. In the App it all works the way you expect and no more delegation issues. The only time this doesn't work is if you need the lookup functionality to work while someone is using SharePoint instead of your App. I have videos on all of this if you need.

 

Shane - Microsoft MVP, YouTube, and PowerApps Consulting for when you are in a bind to get this fixed quickly. And finally we now have PowerApps Training

thanks a lot Jeff for your valuable feedback. yeah its a lookup field. Smiley Happy

thanks a lot Shane for your valuable feedback. appreicate if you can share the videos with me.  Smiley Happy

PowerApps Filter Function - That video will explain the exact issue you are running into. 

 

PowerApps Cascading dropdowns - That video will show you cascading dropdowns which I think will help you connect the dots to recreating LookUp like functionality. 

 

Enjoy Cat Very Happy

Shane - Microsoft MVP, YouTube, and PowerApps Consulting for when you are in a bind to get this fixed quickly. And finally we now have PowerApps Training

thank you Shane. Smiley Very Happy

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (6,909)