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

All responses (8)

Answers (0)

Sort by

cha_cha 4,932 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
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 118 on at

Like
a
(0)

Report
Copy link

Link copied!

@cha_cha

Tried and not working for me
cha_cha 4,932 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

What's the name of your data source?
Yerlasdutco 118 on at

Like
a
(0)

Report
Copy link

Link copied!

@cha_cha

Table5
cha_cha 4,932 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

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 118 on at

Like
a
(0)

Report
Copy link

Link copied!

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

SERIPDeliverables...
cha_cha 4,932 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
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 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@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