Showing results for 
Search instead for 
Did you mean: 
Helper V
Helper V

Seachbox delegation issues - Help with Formula -Please

Hi All,


I have a gallery that shows its content via the below formula. I have a blue wavy delegation line under "BellRef" which is the column that we are searching.  Source content is via sharepoint list.


Is there a workaround or alternative formula where i will have the same outcome without delegation issues?


Search(Filter(CustomerCareLog,Complete="0"), Searchbox_1.Text,"BellRef")

The search basically checks the whole data source to see if a job is uncomplete (ie. "0" boolean value) and then as we have hundreds of these, which will continue growing i have a searchbox where the user can type in the referance to narrow the search down,


Thanks in advance.



to troubleshoot the problem, please try each condition separately. Ie just the StartsWith() and just the complete = 0 without combining them.

 I think I made an error in my StartsWith() function. It should be StartsWith(BellRef,Searchbox_1.Text) 

see General-Discussion/StartsWith-in-combination-with-amp-amp-and-filter/m-p/24400#M10500

View solution in original post

Thanks for this.  Works Perfectly for me now! No worries of future delegation issues! 🙂

Helpful resources

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


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,140)