Search DataTable from multiple columns

[Yerlasdutco]

Hi Folks,

I have a DataTable (Excel DataSource) with multiple columns and need to filter/search from all of columns from 1 TextInput. But it works only for 1 column 

How can I change it well? 

Filter(Table5,StartsWith(Text('SERIP Progress'),TextInput4.Text))

[cha_cha]

Hello @Yerlasdutco 

Use the search function for this.

Search( Table, SearchString, Column1 [, Column2, ... ] )

In your case:

Search( Table3, TextInput4.Text, 'Project Title','Project No.' )

Detailed documentation here:

https://learn.microsoft.com/en-us/power-platform/power-fx/reference/function-filter-lookup

[Yerlasdutco]

@cha_cha 

Tried and not working for me 

[cha_cha]

What's the name of your data source?

[Yerlasdutco]

@cha_cha 

Table5

[cha_cha]

Hello, 

can you pass me your source data so I can try to replicate it here? It's a bit tricky guessing certain words.

[Yerlasdutco]

@cha_cha 

Sure, is excel file. Table5 is MCP sheet

[cha_cha]

Hello @Yerlasdutco 

I was testing your data source and I think it's not searching because it's from an Excel Data Source. I tried Filter function too but it still the same.

A workaround that I did was to move to a Collection and Filter the collection.

ClearCollect(TableX,Table5)

Please watch this short clip to see what happens. I put Table5 data to TableX collection

https://youtu.be/Yxx7RYiEBdQ

[Drrickryp]

@Yerlasdutco

Excel is a terrible datasource, for many reasons. See https://www.google.com/url?sa=t&source=web&rct=j&url=https://m.youtube.com/watch%3Fv%3DRtmZM3tm2Zs&v...

@cha_cha 's solution will work but you likely will run into other problems with it. I suggest that you move it to SharePoint. SharePoint also has some limitations but not like Excel