web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Power app filter/searc...

Power Apps

Unanswered

Power app filter/search function not work (data format issue?)

(0) Share

Report

Report

Posted on by LeoLo

HI

I am very new to Power app, and trying to build an app with the filter/Search funciton in gallery. I tried below 3 formula but not work:

Filter(TestTable,StartsWith('PO Nb', TextInput2.Text ))

Filter(TestTable,TextInput2.Text in 'PO Nb')

Search(TestTable,TextInput2.Text,"PO Nb")

No matter what value I entered in TextInput2, the gallery shows nothing. It only shows all values when the value in blank.

The 'PO Nb' is the Column that I am trying to search for which should be Text value eg 23414-1, ABCDE, 12984-2.

I tried the same formula with other fields and that can work. I wonder is the data format issue but I am not sure how to resolve that.

Thank you

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

AndrewR1 1,572 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @LeoLo using this forumla is deffinalty the corect way to achive this:

Filter(TestTable,StartsWith('PO Nb', TextInput2.Text ))

Maybe double check the way the data is formated and that is doesnt have a space at the beginning of the string?

Please click Accept as solution if my post helped you solve your issue. ✔️ This will help others find the solution to this problem. It also closes the item. Remember, you can accept more than one post as a solution.

If the content was useful in other ways, please consider giving it Thumbs Up. 👍

Thanks
Andrew

Was this reply helpful? Yes No

Join the conversation