Announcements
Has anyone tried to implement KQL search through Gallery items in canvas app? The end user would like to search using [columnName]: columnValue in a free text Search textbox. Currently the search is being performed in a few text type columns.
@reshmee011
KQL isn't directly supported. To search gallery items, you would use standard PowerFX functions.
To clarify your requirement, your intention is to specify the target search column by prefixing the search term with a : character?
@timl : thanks for responding to my query , to start with the search can be the target column with a column value delimited by ":".
You'd need to write some custom formula to do that. The formula below would deal with example syntax that looks like this - "Surname:Smith" or "Firstname:John"
With({inputValues:Split(txtInputValue.Text, ":")}, Switch(First(inputValues).Value, "Surname", Filter(DataSource, Surname=Last(inputValues).Value), "Firstname", Filter(DataSource, Firstname=Last(inputValues).Value) ) )
@timl : thanks very much for the workaround, I just need to amend the script to cater for different column types, e.g. choices, lookup.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 402 Super User 2026 Season 2
Mohsin Ali 328
WarrenBelz 296 Most Valuable Professional
