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.
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?
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.
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...
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?
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
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' )