cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Getting Warning in formula in Text Search box

Dears, 

Need your support. I have created Mutli Search in my list ,but i get warrning and not able to see latest Items when i search ,but if i make it only one search defult ,then i able to see all items. 

Below how it show. 

 

14 REPLIES 14
Highlighted
Super User III
Super User III

Re: Getting Warning in formula in Text Search box

HI @HussainAlnasri ,

Is this a delegation warning ? Can you please supply the warning text 

 

Highlighted
Super User III
Super User III

Re: Getting Warning in formula in Text Search box

Apart from delegation issues, Try placing the  can the first StartsWith in value: StartsWith('Serial Number',Value(TextSearchBox1.Text))

 

 

If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution.

Highlighted
Frequent Visitor

Re: Getting Warning in formula in Text Search box

Hi @WarrenBelz , 

See the attachment, 

I had follow the steps as per the warning to change the name of the list ,but still same warning given 

Highlighted
Frequent Visitor

Re: Getting Warning in formula in Text Search box

Hi @eka24 , 

 

I had tried ortByColumns(Filter([@'Service Engineer Calendar_1'], StartsWith('Serial Number',Value(TextSearchBox1.Text)) ||StartsWith('Service Engineer Name',Value(TextSearchBox1.Text))), "Title", If(SortDescending1, Descending, Ascending)) 

 

It's same warning. 

Highlighted
Super User III
Super User III

Re: Getting Warning in formula in Text Search box

Thanks @HussainAlnasri ,

Please have a look at the below code and notes

SortByColumns(
   Filter(
      [@'Service Engineer Calendar_1'], 
      StartsWith(
         'Serial Number',
         Value(TextSearchBox1.Text
      )
         //extra bracket was in here - not needed
      ||
      StartsWith(
         'Service Engineer Name',
          TextSearchBox1.Text    // do not need Value here - removed
      ), 
      "Title", 
      If(
         SortDescending1, 
         Descending, Ascending
      )
   ) 
)          //bracket should be here

 

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.

 

Highlighted
Frequent Visitor

Re: Getting Warning in formula in Text Search box

Hi @WarrenBelz , 

Thank you for support. If i use your formula ,then no any data show. 

I had tried below formula ,but not showing me any error or woning. 

SortByColumns(Filter([@'Service Engineer Calendar_1'], StartsWith(Title, TextSearchBox1_1.Text) ||StartsWith('Created By'.DisplayName, TextSearchBox1_1.Text)), "Title", If(SortDescending1, Descending, Ascending))

 

It seems there is problem in the 'Service Engineer Name'.Value  

 

Can you type the formula so i can copy it. 

Highlighted
Super User III
Super User III

Re: Getting Warning in formula in Text Search box

Hi @HussainAlnasri ,

I am not aware of your data structure, so initially was only trying to get the code in a syntax what might work. The code below is a totally different Filter to your first post. There is nothing wrong with the syntax below as long as all the references are valid. When you are typing all the valid options come up under the box as you hit the "dot" to start the next part. With the Service Engineer, see what is underneath with you type the "dot".
Due to timezone issues, I will be offline shortly.

SortByColumns(
   Filter(
      [@'Service Engineer Calendar_1'],
       StartsWith(
         Title, 
         TextSearchBox1_1.Text
       ) ||
       StartsWith(
          'Created By'.DisplayName, 
          TextSearchBox1_1.Text
        )
    ), 
    "Title", 
    If(
       SortDescending1, 
       Descending, 
       Ascending
   )
)

 

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.

Highlighted
Frequent Visitor

Re: Getting Warning in formula in Text Search box

Hi @WarrenBelz , 

 

What i mean when i change the second search from 'Service engineer name'.Value  to 'Created by'  just for trial and no warning show also the blue line off under the formula. Which mean there is problem in selection beucase  the box is not showing me this option 'Service engineer name'.value  to be select. Is there any other optition i can do mulit search in my list. 

Highlighted
Super User III
Super User III

Re: Getting Warning in formula in Text Search box

OK @HussainAlnasri ,

What type of field is Service Engineer in your data source?

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Find your favorite faces from the community presenting at the Power Platform Community Conference!

Watch Now

Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (7,896)