cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Post Prodigy
Post Prodigy

Search Multiple Columns - Text & Choice

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?

Thank you!

11 REPLIES 11

@RandyHayes 

 

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!!!

@simms7400 

No problem!  My favorite kind of issue...one that resolves itself!

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.
Check out my PowerApps Videos too!

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Community Highlights

Community Highlights

Check out the Power Platform Community Highlights

Top Solution Authors
Top Kudoed Authors
Users online (4,226)