Power Platform Community Forum Thread Details

Hi everyone,

Hope you can help me with this as I am completely lost now and don't know why it not working.

I had the app with the Filter function as below and it was work fine in the last 2-3 months. It now suddenly could not work and returned could not find the data. My database is an excel file in SharePoint with the value type is Text

Does anyone know what wrong with it or how to fix it? There is no error code on the formular. Thank you

Categories:

Building Power Apps

Error handling

Hi @CU25062156-1

Firstly try this (I assume that Serial is a Text field)

Filter(
   Records,
   Len(txtSearch.Text) = 0 || Serial = Trim(txtSearch.Text)
)

You can also set the Default of txtSearch to "" (empty string) and try this

Filter(
   Records,
   StartsWith(
      Serial,
      txtSearch.Text
   )
)

If Serial is a Number field

Filter(
   Records,
   Len(txtSearch.Text) = 0 || Serial = Value(Trim(txtSearch.Text))
)

Also, Excel is really the "data source of last resort" with (among other deficiencies) very limited Delegation capacity - how many records are in your Excel Table and what is your Data Row Limit. You have access to SharePoint so this will work much better in with a SharePoint List.

Please ✅ Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider answering Yes to Was this reply helpful? or give it a Like ♥
Visit my blog Practical Power Apps LinkedIn