Unable to filter multiple columns in excel file with keywords

(0) Share

Report

Posted on by pityman

115

HI, may i know what is the issue below?
I was trying to filter the multiple columns in an excel file with the keyword

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

WarrenBelz 153,075 Most Valuable Professional on at

Like (0)

Report

Hi @pityman ,

The syntax is correct (and would work perfectly in SharePoint), have to tried a single field search to confirm it is the second field causing the issue.

Was this reply helpful? Yes No
pityman 115 on at

Like (0)

Report

Thank you for your reply.
(and would work perfectly in SharePoint) << do you mean it will work perfectly if its from sharepoint list?
Currently my excel file is reside on sharepoint.
Do you recommend to chnage to sharepoint list instead?

Was this reply helpful? Yes No
PTBBSolutions 691 on at

Like (0)

Report

Why don't you use Filter instead? Filter(DataSource, Column1 = "someting" Or Column2 = "something"), etc..

Was this reply helpful? Yes No
WarrenBelz 153,075 Most Valuable Professional on at

Like (1)

Report

Hi @pityman ,

If you have access to SharePoint, please forget Excel as a data source and use a SharePoint List instead.

Please click Accept as solution 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 giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
v-jefferni on at

Like (0)

Report

Hi @pityman ,

The error message indicates that using Search function to search in multiple columns is not supported if using an Excel table as the data source. Like @WarrenBelz said, it is more recommended to use SharePoint as the data source rather than Excel tables, because there are quite a few limitations to use Excel tables:

https://docs.microsoft.com/en-us/connectors/excelonlinebusiness/#known-issues-and-limitations

So if possible, please consider import the data into SharePoint lists and use the lists as the data source of your App.

Hope this helps.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No