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

Filter a data source using TextSearchBox

Hello,

 

I'm new to PowerApps so please be patient. 🙂

I'm trying to figure out how to define a common Filter for a data source. Users should be able to insert some numbers (tracking IDs for parcels) so that the Gallery only shows entries containing those numbers.

 

So, I got at least 2 problems with this:

 

1.

To start off easy I tried this for my gallery: 

 

Filter (parcel_; StartsWith (parcel_ID_; TextSearchBox1.Text)) 

 

If I enter this formula in the items tab my data source is lost and no entries will show up (by default: items = fx parcel_).

I also tried the default tab but an error accured.  "The Property is expecting record-values but this rule creates incompatible table-values." The error is shown in German so probably I translated it differently.

 

2.

I don't know how to define the TextSearchBox1 at all. I browsed through all the E-Learning material but probably missed that part. Also it seems kind of outdated.

Do I even have to define anything or is it set correctly by default?

 

I created my App from a SharePoint data source.

 

If you need any further information I can probably provide some screenshots e.g.

 

Thank you so much for your help!

 

 

 

3 REPLIES 3
v-yamao-msft
Community Support
Community Support

Hi hendi,

 

I assume that column “parcel_ID_” should be a number column. While StartsWith function expects a Text value in the left. SO I am afraid that the code you are using “Filter (parcel_; StartsWith (parcel_ID_; TextSearchBox1.Text))” won’t work.

 

To test this issue, I add a Gallery control on the app and add a connection to a SharePoint list. Then set the Items property of the Gallery to Filter(List2,StartsWith(Title,TextInput1.Text)). The code works fine on my side.

 

What do you mean by “how to define the TextSearchBox”? You could add a Text input control then rename it to TextSearchBox. More details about Text input control, please check it at here:
https://powerapps.microsoft.com/en-us/tutorials/control-text-input/


Best regards,
Mabel Mao

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi, 

 

thanks for your reply.

I already received a  message from another user. We figured out that my data source had to much entries so the filter would not work. I added an index to the column of the SharePoint - list and now it's working, kind of.

SortByColumns(Filter(parcel_; StartsWith(parcel_ID_;TextSearchBox1.Text)); "timestamp_"; If(SortDescending1; Descending; Ascending))

 

The only problem left is that only 100 entries are shown in the gallery without scrolling down. So I am not able to filter and find entries from 2015 e.g. I know that it's made like that to manage a good performance but that is kind of exactly what we need.

 

Cheers

Boa tarde!

 

 Preciso que a pesquisa seja feita com números. Como devo fazer já que "Filter (parcel_; StartsWith (parcel_ID_; TextSearchBox1.Text))" só funciona com texto?

Helpful resources

Announcements
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

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Carousel April Dunnam Updated 768x460.jpg

Urdu Hindi D365 Bootcamp

Dont miss our very own April Dunnam’s The Developer Guide to the Galaxy! Find out what the Power Platform has to offer for the traditional developer.

Top Solution Authors
Top Kudoed Authors
Users online (2,443)