Unanswered

Filter/StartsWith only working for first letter

(0) Share

Report

Posted on by Community Power Pla...

Any idea why this could be happening? Have a text box and gallery. Gallery items = Filter(DataSource, StartsWith(clientname, Textbox.Text))

I can type "p" and it will show items that start with "p". Let's say the first one is "Paul". If I type an "a" after the "p", all the items in the gallery disappear, even though Paul was just showing.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

v-xida-msft on at

Like (0)

Report
Hi @Anonymous ,

Could you please share a screenshot about your issue?

Do you mean that the "Paul" disappear when you type "pa" within your TextSearchBox?

Based on the issue that you mentioned, I have made a test on my side, and don't have the issue that you mentioned. The screenshot as below:

The StartsWith() function is used to test whether one text string begins with another. Please make sure the Client Name column is a Text type column in your Data source.

Also please consider take a try with the following formula in your Gallery:

Filter(DataSource, Textbox.Text in clientname)

Note: Above formula may cause a Delegation warning issue, if the amount of your data source records is not more than 2000, you could ignore this warning issue. Set the "Data row limit for Non-delegable queries" option to maximum value -- 2000 within Advanced settings of App settings of your app, then you could process 2000 records locally at most in your app.

Please also consider re-generate a new app based on your data source, then try your formula again, check if the issue is solved.

Best regards,

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hello,

Thank you for your reply.

To answer some of your questions first:
Client Name is a Text type column in my SharePoint list.
The in function will not work because the data source is greater than 2000.
This situation is not within an app based off a data source. It is a customized form on a SharePoint list, and the gallery control is using a different SharePoint list as the data source.

I discovered that the gallery will not work correctly if it's inside of a data card. I tried adding it to a data card that was created automatically from a SharePoint column, and I also tried to add it to a custom data card that is not connected to anything. This is still a problem because the only way the gallery functions is if it's floating around the form. Any ideas about that?

Was this reply helpful? Yes No
v-xida-msft on at

Like (0)

Report

Hi @Anonymous ,

Do you mean that you add/embed a Gallery within a Data card in your Edit form (SharePointForm1)?

Actually, using a Gallery withi a Data card has not beed supported within PowerApps. The fact that you can bypass that limitation by copy/pasting a gallery inside a card is a bug in the product.

Please check the response from the PowerApps Staff @CarlosFigueira within the following thread:

https://powerusers.microsoft.com/t5/General-Discussion/Gallery-inside-Data-Form-no-longer-selectable/m-p/133260/highlight/false

If you copy a Gallery, and then paste it into a Data card in your Edit form, it may cause some unknown issue. Currently, as an fixed solution, please consider insert your Gallery outside the data card and the Edit form. You could consider configure your app as a Tablet app, then on the left half of the Edit screen, put your Edit form, then on the right half of the Edit screen, put your Gallery:

Best regards,

Was this reply helpful? Yes No