I have a very simple powerapps application which enables managers to enter some information into a SharePoint list.
In order to make it easy for them (and myself) I set up many of the columns as "Choice" fields which present a Dropdown box to the manager with the limited choices they have to populate the field (Example: Under the "Locations" column they can choose North, South, East or West). They cannot add other choices.
Now, in the Powerapp itself, when I go to set some search functionality in the "Search" field at the top, Powerapps will not accept any of the Choice (dropdown) fields to search on.
This is the default forumula in the "Search" box, in the forumula bar, with the gallery selected and "Items" as the property choice:
SortByColumns(Filter('Safety Concentration Time Tasks', StartsWith(ComplianceAssetId, TextSearchBox1.Text)), "ComplianceAssetId", If(SortDescending1, Descending, Ascending))
My question is am I thinking about this the right way OR is there a forumla which will search those "choice" columns?
Solved! Go to Solution.
My solution to this was to add a "Calculated (calculation based on other columns)" column in SharePoint with the formula "=[*Desired column to search in Power Apps*]" as a single line of text. Then reference that new column in Power Apps.
In my case, I needed to search the "Make" column (Apple, Lenovo, HP) which was a choice column in SharePoint and that would not be allowed. The new single line of text calculated column in Sharepoint, named "Make2", then was able to be added to my default formula for my gallery.
Hope this helps!
Learn how to create your own user groups today!
Check out the new Power Platform Community Connections gallery!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.