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))
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 |
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 |
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 |
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
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 |
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
User | Count |
---|---|
256 | |
114 | |
95 | |
48 | |
38 |