Answered

How do I filter using StartsWith in Excel table?

(0) Share

Report

Posted on by matix003

I have a gallery control connected to an excel table. I have a search box by which I want to get specific results. I tried doing

Filter(Table1,StartsWith(Name,empSearchbox.Text))

This gives me the error-

The requested operation is invalid. Server Response: Tablel failed: Invalid filter clause: unsupported operation. Only single 'eq', 'ne', 'contains', 'startswith' or 'endswith' is currently supported. clientRequestid: 9b03bf1e-18c4-4270- b6c7-2953d1042081

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Nogueira1306 7,390 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

When I had to filter an Excel table I also had a problem....

My advice is for you to create a Collection from that datasource and use that Collection instead of the Excel file

If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!

Best regards,

Gonçalo Nogueira

Check my LinkedIn!

Buy me a coffee!

Check my User Group (pt-PT)!

Last Post on Community

My website!

Was this reply helpful? Yes No
matix003 64 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Nogueira,
My excel table has got more than 100 rows and the User can add more. If I create a collection do I have to write down all 100 rows details in the collection?

Was this reply helpful? Yes No
Verified answer

matix003 64 on at

Like
a
(0)

Report
Copy link

Link copied!

I restarted my PowerApps and now it works.

Was this reply helpful? Yes No