Search SharePoint Choice Columns in Power Apps Shorts

[@MrSfinkster]

Awesome tip, i was searching for this today. Saved my day :) as always .

[@ShanesCows]

Glad it helped and you could find it. Shorts are harder to find stuff I think.

[@djanepa]

Thanks for the tip! But I have one more question: How do I filter when my column choices has multiple choices?

[@ShanesCows]

Good timing on the question. This coming Mondays question has an example of that. You have to use the in operator. But if you are using SharePoint it is not delegable.

[@kunleadelabu9810]

Thanks Shane. This solves one of the nightmares I'm currently facing on a project based on SharePoint. But i tried to apply this in dataverse. It keeps throwing error that the function Search has invalid arguments. Any further help?

[@ShanesCows]

DataVerse has a different syntax for the column. I don’t have it off the top of my head but do columnname. And see what it offers you. Or maybe just columnname.

[@kunleadelabu9810]

​@ShanesCows I actually tried that, but It just seems not to be working.

[@BBhive]

Thank you for the info! Does this also work if the column in SharePoint is a lookup column?

[@ShanesCows]

Yes, it should.

[@luisjimenez8760]

Hi Shan. Could you tech how can search by contain in delegation

[@ShanesCows]

Search with SharePoint is never delegable from Power Apps 😑

[@danielszelagiewicz2262]

Hello, concept looks very clean and straight - forward. But it is not working with choice column in Sharepoint... On preview it looks like the column created has also table , not text in itself...

[@ShanesCows]

That is because you are using a Mult-choice column. You are correct, they are stored as a Table. For them you would need to use In operator. ☹️

[@danielszelagiewicz2262]

@@ShanesCows Thanks! I have learnt a lot from You !

[@jeanpierreragequit1726]

Great tip ! Thx u Shane !

[@ShanesCows]

You are welcome! 😎

[@MenPoriyaalan]

Saved my Day .. Thank you

[@ShanesCows]

Happy to help :)

[@M87user]

Hi by default the search is made as a 'filter' not 'search' function in power apps. when I change it to search it does search correctly but when I click on item it does not redirect to the details. Any suggestions how to fix it?

[@asaaprabhat3489]

Thanks alot for the tip Shan

[@ShanesCows]

My pleasure 😊

[@user-ze3sg6ix1u]

Thank you for solving my problem in one minute dude. I hate powerapps. I prefer to code my self lmao

[@ShanesCows]

Glad to help. This low code thing will grow on you over time. 😎

[@Soulebi03]

If(varSearch && drpColumnHeaders.SelectedText.Value ="Competency", Search(AddColumns('DataSource',"Competency",Competency.Value),varSearchInput,"Competency"), hi Shane can you tell me whats wrong with my formula? I have the same problem, I have a choice type of column however this doesn't work

[@ChadRobbins-C42]

Since it is now a column, you need to use reference quotes (single quotes) and not double quotes. Also, you need to rename your new column, it cannot match the old column. Search( AddColumns( 'DataSource', 'New_Competency'_Column, 'Competency'.Value ), varSearchInput.Value, 'New_Competency_Column' )