cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Yerlasdutco
Helper III
Helper III

Search DataTable from multiple columns

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

Yerlasdutco_0-1669030102686.png

 

 

8 REPLIES 8
cha_cha
Resident Rockstar
Resident Rockstar

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

 


 
Just in case you my answer helped you solve your problem, please mark/accept this as a SOLUTION This helps community members if they experience a similar issue in the future.

 
bistek.space   @cha_bistek    @BisTekSpace 

@cha_cha 

 

Tried and not working for me 

Yerlasdutco_0-1669030761010.png

 

cha_cha
Resident Rockstar
Resident Rockstar

What's the name of your data source?


 
Just in case you my answer helped you solve your problem, please mark/accept this as a SOLUTION This helps community members if they experience a similar issue in the future.

 
bistek.space   @cha_bistek    @BisTekSpace 

@cha_cha 

 

Table5

cha_cha
Resident Rockstar
Resident Rockstar

Hello, 

 

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


 
Just in case you my answer helped you solve your problem, please mark/accept this as a SOLUTION This helps community members if they experience a similar issue in the future.

 
bistek.space   @cha_bistek    @BisTekSpace 

@cha_cha 

Sure, is excel file. Table5 is MCP sheet

cha_cha
Resident Rockstar
Resident Rockstar

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


 
Just in case you my answer helped you solve your problem, please mark/accept this as a SOLUTION This helps community members if they experience a similar issue in the future.

 
bistek.space   @cha_bistek    @BisTekSpace 
Drrickryp
Super User
Super User

@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

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (5,806)