Search DataTable from multiple columns

(0) Share

Report

Posted on by Yerlasdutco

118

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))

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (0)

cha_cha 4,932 Moderator on at

Like (0)

Report
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

Was this reply helpful? Yes No
Yerlasdutco 118 on at

Like (0)

Report

@cha_cha

Tried and not working for me

Was this reply helpful? Yes No
cha_cha 4,932 Moderator on at

Like (0)

Report

What's the name of your data source?

Was this reply helpful? Yes No
Yerlasdutco 118 on at

Like (0)

Report

@cha_cha

Table5

Was this reply helpful? Yes No
cha_cha 4,932 Moderator on at

Like (0)

Report

Hello,

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

Was this reply helpful? Yes No
Yerlasdutco 118 on at

Like (0)

Report

@cha_cha
Sure, is excel file. Table5 is MCP sheet

SERIPDeliverables...

Was this reply helpful? Yes No
cha_cha 4,932 Moderator on at

Like (1)

Report
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

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (1)

Report

@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&ved=2ahUKEwjzkJuAvL_7AhVDIkQIHaRfATYQo7QBegQIBxAB&usg=AOvVaw1d8T7aJR_7eBmvEQZw4men

@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

Was this reply helpful? Yes No