Yes, you got it right! The search within column values. What if we want to implement something similar for List Box Property Control ?
We are going to do it today !!
Let's Start.
- We are going to create a Input Field property first to capture our search string. In this example, I am going to call it - ${CountrySearch}. This is going to search values in [Country Name] column.
- Create a Calculated column [Country] to hold search results with expression below -If(Len('${CountrySearch}')>0,
If(Find(Lower('${CountrySearch}'),Lower([Country Name]))>0,
[Country Name]) ,
[Country Name]) - Now create your Property Control using column [Country]. I have given a search button, just to move focus out of search box; however hitting enter also works well.
Here is what we have in the end -