Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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 wheth...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    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

     

     

v-juanli-msft's avatar
v-juanli-msft
Community Support
7 years ago

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