Forum Discussion
Anonymous
7 years agoNot applicable
Search box filter based on two columns
I have a table with text columns for a person's name (Table[Name]) and a unique string called UserID (Table[UserID]). I want to have a search box (text box?) that will filter the table based on whether a user's name or userID is typed into that search box.
I believe I will have to use a slicer to do this, but I can't figure out how to get the desired behaviour.
Any help would be much appreciated! :)
Hi Anonymous
you could go to "import from marketplace", add a "Text slicer"
create a calcuated column
con = CONCATENATE(CONCATENATE(Table2[userid],"-"),Table2[username])
Best Regards
Maggie
1 Reply
- v-juanli-msftCommunity Support
Hi Anonymous
you could go to "import from marketplace", add a "Text slicer"
create a calcuated column
con = CONCATENATE(CONCATENATE(Table2[userid],"-"),Table2[username])
Best Regards
Maggie