cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
cberni1
Level: Powered On

power app mobile search error

I am only able to search by project number and not client name in my power app.  I have tried to rearrange the list to put client first and project number below it but it still won't provide any results for the search.  My data source is a sharepoint list and the client name and project number are indexed and required so I don't know what else i'd be missing.  please let me know what else you may need to help me troubleshoot.

1 ACCEPTED SOLUTION

Accepted Solutions
K-A-R-L
Level 10

Re: power app mobile search error

Hi @cberni1 ,

 

You have to enclose the Column Names with double quotation marks.

If(IsBlank(TextSearchBox1.Text),
'Project Notes',
Search( 'Project Notes',
TextSearchBox1.Text,
"mnemonic",
"ProjectNumber"
)
)

----------------------------------------------------------------------------
Thanks,
K-A-R-L


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If you thought this post was helpful, please give it a Thumbs Up.

View solution in original post

9 REPLIES 9
K-A-R-L
Level 10

Re: power app mobile search error

Hi @cberni1 ,

 

Can you please make sure that you are searching on the right column "ClientName".

Please check your search syntax

Search( 
DataSource, //SharePoint List TextInput.Text, //Text Input Field "ClientName" //Client Name Column on your SharePoint List )

If you want to search on either Project Number and Client Name, just add the Project Number Column

Search( 
 DataSource, //SharePoint List
 TextInput.Text, //Text Input Field
 "ClientName", //Client Name Column on your SharePoint List 
 "ProjectNumber" //Project Number Column on your SharePoint List 
)

----------------------------------------------------------------------------
Thanks,
K-A-R-L


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If you thought this post was helpful, please give it a Thumbs Up.

Community Support Team
Community Support Team

Re: power app mobile search error

Hi @cberni1 ,

Could you please share a bit more about your Search formula you used within your app?

Are the Project number and Client name both Text type column in your SP list?

 

I have made a test on my side, and don't have the issue that you mentioned. Please consider take a try with the following workaround:

Add a Gallery within your app, set the Items property to following:

Search('YourSPList', TextSearchBox1.Text, 'project name', 'client name')

Note: The TextSearchBox1 represents the Text Input box in your app, where you type your search text.

Or

Filter(
        'YourSPList',
         StartsWith('project name', TextSearchBox1.Text) || StartsWith('client name', TextSearchBox1.Text)
)

Please consider take a try with above solution, then check if the issue is solved.

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
cberni1
Level: Powered On

Re: power app mobile search error

@v-xida-msft @K-A-R-L  

 

I am attaching screen shots of what i'm seeing.  I do woner if my source data has some issues and that is why my app isn't working like i'd expect.  I did try the syntax you suggested but since i'm somewhat new to this program, i'm not sure if I did this correctly.  The data field works when " " is in the function but when i put your suggested syntax with either "title" "subtitle" or my specific field "Mnemonic" Projectnumber", it removes all the content.  Please let me know what you think.

 

pic4.JPGpic1.JPGpic2.JPGpic6.JPG

K-A-R-L
Level 10

Re: power app mobile search error

Hi @cberni1 ,


You need to add the code to the BrowseGallery1 Items NOT on the TextSearchBox 1 Default.

Please add IsBlank() on the code. If your TextSearchBox1.Text is blank, ignore TextSearchBox1.Text and return DataSource, if TextSearchBox1.Text is NOT blank, filter/search using the TextSearchBox1.Text.

If(IsBlank(TextSearchBox1.Text),
 DataSource, 
    Search(      DataSource, //SharePoint List
     TextSearchBox1.Text, //Text Input Field
     "ClientName", //Client Name Column on your SharePoint List 
     "ProjectNumber" //Project Number Column on your SharePoint List 
                )
 )

----------------------------------------------------------------------------
Thanks,
K-A-R-L


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If you thought this post was helpful, please give it a Thumbs Up.

cberni1
Level: Powered On

Re: power app mobile search error

@K-A-R-L  I tried to put in the command you suggested and still get nothing.  Below is what I created.  Should i be nesting the "if" statement inside the command?  I may still be confused.

 

If(IsBlank(TextSearchBox1.Text),
'Project Notes',
Search( 'Project Notes',
TextSearchBox1.Text,
Mnemonic_DataCard1,
ProjectNumber_DataCard1
)
)

K-A-R-L
Level 10

Re: power app mobile search error

Hi @cberni1 ,

Can you please add the code to the BrowseGallery1 Items NOT on the TextSearchBox 1 Default.

Cheers

K-A-R-L
Level 10

Re: power app mobile search error

Hi @cberni1 ,

 

You have to enclose the Column Names with double quotation marks.

If(IsBlank(TextSearchBox1.Text),
'Project Notes',
Search( 'Project Notes',
TextSearchBox1.Text,
"mnemonic",
"ProjectNumber"
)
)

----------------------------------------------------------------------------
Thanks,
K-A-R-L


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If you thought this post was helpful, please give it a Thumbs Up.

View solution in original post

K-A-R-L
Level 10

Re: power app mobile search error

Hi @cberni1 ,

 

Do you have more than 2000 items on your Data Source?

If you have a delegation warning:

 

It means it still works (not a red wavy line but a blue wavy line) if the table contains fewer than 500 records, the formula works perfectly.

 

But if the table contains more than 500 records, the formula won't return record 501 or higher, even if it matches the criteria.

 

So the Max result here may be an error if table contains more than 500 records.

 

However 500 is the default number of records, but you can change this number for an entire app:

 

On the File tab, select App settings.
Under Experimental features, change the Data row limit for non-delegable queries setting from 1 to 2000.

For more details about Delegation warnings please check this link:

 

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/delegation-overview


As a workaround for more thatn 2000 try reading this:
https://michalguzowski.pl/how-to-overcome-500-items-limit-in-powerapps/

----------------------------------------------------------------------------
Thanks,
K-A-R-L


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If you thought this post was helpful, please give it a Thumbs Up.

cberni1
Level: Powered On

Re: power app mobile search error

I have under 500 data sets so something else must be wrong with my data.  i attached a screenshot for what seems to be an error with my search field within the string.  I'm not sure if this is trul an issue or not but its underlined in red.pic8.JPG

Helpful resources

Announcements
New Ranks and Rank Icons in April

'New Ranks and Rank Icons in April

Read the announcement for more information!

Better Together’ Contest Finalists Announced!

'Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

thirdimage

Community Summit North America

Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (9,562)