Hi Folks -
I have a search box and galley set up on one of my form. I've also enabled it where the user can search multple fields as well. Here is my formula:
SortByColumns( Filter(rdAssets, StartsWith(Alias, TextSearchBox4.Text) || StartsWith(Name, TextSearchBox4.Text) || StartsWith(Target_x0020_Short_x0020_Name, TextSearchBox4.Text) || StartsWith(Brand_x0020_Name, TextSearchBox4.Text) || StartsWith(PF_Research_Code, TextSearchBox4.Text) || StartsWith(Generic_x0020_Name, TextSearchBox4.Text) || StartsWith(Development_Name, TextSearchBox4.Text) || StartsWith(Alternate_Name, TextSearchBox4.Text) && !(Portfolio_x0020_Status.Value="Terminated")), "Alias", If(SortDescending1, Descending, Ascending) )
It's currently sorted by "Alias" (which is a text field), however I need to add one more column to sort by : Portfolio_x0020_Status
The issue is the Portfolio_x0020_Status is a choice field and it's not liking any formula. Can somene give me some pointers on how to add Portfolio_x0020_Status to my above formula?
Solved! Go to Solution.
Randy, please excuse me. My network must have been slow/disconnected as I relaunch the app and now your formula works. Let me add it to the respective Forms and report back if i have issues.
Thank you so much!!!
No problem! My favorite kind of issue...one that resolves itself!
So many events that are happening this month - don't miss out!
Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.
Your chance to join an engaging competition of Power Platform enthusiasts.