Reply
Frequent Visitor
Posts: 7
Registered: ‎12-03-2018
Accepted Solution

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! Smiley Happy


Accepted Solutions
Community Support Team
Posts: 2,269
Registered: ‎03-15-2018

Re: Search box filter based on two columns

[ Edited ]

Hi @testaccount222

you could go to "import from marketplace", add a "Text slicer"

create a calcuated column

con = CONCATENATE(CONCATENATE(Table2[userid],"-"),Table2[username])

9.png

10.png

 

 

 

 

Best Regards

Maggie

 

 

View solution in original post


All Replies
Community Support Team
Posts: 2,269
Registered: ‎03-15-2018

Re: Search box filter based on two columns

[ Edited ]

Hi @testaccount222

you could go to "import from marketplace", add a "Text slicer"

create a calcuated column

con = CONCATENATE(CONCATENATE(Table2[userid],"-"),Table2[username])

9.png

10.png

 

 

 

 

Best Regards

Maggie