Search error: no result if search input to long

(0) Share

Report

Posted on by DanK

Hello,

I try to implement a search with the formula:

SortByColumns(Search(EntityName, TextSearchBox1.Text, "GUID"), "GUID", If(SortListVAR, Descending, Ascending))

Now if I use the search to look for a GUID i get the correct result when I enter

But as you can see there is the last number missing. If I enter the whole GUID now the search doesn`t show me the result

I tried changing the max. length of the input field but it doesn`t change the outcome. Also the length of the GUID field in the entity is set correctly.

I also want to prevent the search from working if not a whole GUID is entered in the correct format.

Thank you in advance.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

v-xida-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @DanK,

Could you please share a bit more about the Entity that you mentioned? Is it a CDS entity?

Which type of the GUID field within your Entity?

I have made a test on my side (generate an app from CDS entity) and don't have the issue that you mentioned. The GIF image as below:

Please check if the Max length property of the GUID field within your Entity is set to a proper value which is more than the length of the GUID field value.

Please take a try to generate an app from your Entity or re-create your app, then check if the issue is solved. More details about generating an app from Common data service, please check the following article:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/data-platform-create-app

In addition, if you want to prevent the search from working if not a whole GUID is entered in the correct format, please take a try with the following workaround:

Set the Items property of the Gallery control to following formula:

If(
!IsBlank(TextSearchBox1.Text),
SortByColumns(Filter(ProductsRecord,StartsWith(TextSearchBox1.Text,GUID),Len(TextSearchBox1.Text)=36), "GUID", If(SortDescending1, Descending, Ascending)),
ProductsRecord
)

Note: The 36 represents the length of the GUID field value within your Entity.

The GIF image as below:

Best regards,

Kris

Was this reply helpful? Yes No
DanK 13 on at

Like (0)

Report
Copy link

Link copied!
Hello @v-xida-msft
first and foremost thank you for your help and response.

I got it working with your formular and the filter function. To confirm that it is a GUID I use a regex.
If(IsMatch(TextSearchBox1.Text,"^[a-zA-Z0-9]{8}-[a-zA-Z0-9]{4}-[a-zA-Z0-9]{4}-[a-zA-Z0-9]{4}-[a-zA-Z0-9]{12}$"), SortByColumns(Filter(TABLE, StartsWith(TextSearchBox1.Text,guid)),"guid",If(SortListVAR,Descending,Ascending)),SortByColumns(TABLE, TextSearchBox1.Text, "primaryname"), "primaryname", If(SortListVAR, Descending, Ascending)))
With this I search for a GUID in the "subtitle" or a normal name in the main title.

So as this is working I get a "delegation error" because of the StartsWith function.
It says "Part of this formula cannot be evaluated remotely. the 'StartsWith' function cannot be delegated if a field name appears in the second argument."
Also this.

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

Is there an alternative for the StartsWith function in this matter?

Also the error I described existed only on the Search function
SortByColumns(Search(TABLE,TextSearchBox1.Text,"guid"), "guid",If(SortListVAR, Descending, Ascending))
It had no impact changing the length of the field value. Also it is a CDS entity in the Production environment not the Trial.
If I use this code I also get the message:

So all in all thank you it works for now so far 😃 But I might get into trouble with larger data sets.

Was this reply helpful? Yes No
DanK 13 on at

Like (0)

Report
Copy link

Link copied!
Hello @v-xida-msft
first and foremost thank you for your help and response.

I got it working with your formular and the filter function. To confirm that it is a GUID I use a regex.
If(IsMatch(TextSearchBox1.Text,"^[a-zA-Z0-9]{8}-[a-zA-Z0-9]{4}-[a-zA-Z0-9]{4}-[a-zA-Z0-9]{4}-[a-zA-Z0-9]{12}$"), SortByColumns(Filter(TABLE, StartsWith(TextSearchBox1.Text,guid)),"guid",If(SortListVAR,Descending,Ascending)),SortByColumns(TABLE, TextSearchBox1.Text, "primaryname"), "primaryname", If(SortListVAR, Descending, Ascending)))
With this I search for a GUID in the "subtitle" or a normal name in the main title.

So as this is working I get a "delegation error" because of the StartsWith function.
It says "Part of this formula cannot be evaluated remotely. the 'StartsWith' function cannot be delegated if a field name appears in the second argument."
Also this.

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

Is there an alternative for the StartsWith function in this matter?

Also the error I described existed only on the Search function
SortByColumns(Search(TABLE,TextSearchBox1.Text,"guid"), "guid",If(SortListVAR, Descending, Ascending))
It had no impact changing the length of the field value. Also it is a CDS entity in the Production environment not the Trial.
If I use this code I also get the message:

So all in all thank you it works for now so far 😃 But I might get into trouble with larger data sets.

Was this reply helpful? Yes No