App won't accept new database in specific Sort/Search/Filter statement

[JulieHeadlee]

I am relatively new to PowerApps, and have a problem.  I have a working app that I want to use as a template for a new one, connecting to a different data source.  Both data sources are existing Sharepoint Lists.  I use three filters to limit the data displayed in a gallery.  Original data source is "Client Database".  New is "Client2 Database".  I can change the code without errors through the app, but when I try to change the below code I can change every data source occurrence without error until the last one.  The error message is "The function Search has some invalid arguments".  The new data source only has one data record at this time.  Could that be the problem, or can someone see what it might be?

SortByColumns( 
	Search(
		If( drpClass.Selected.Result = "All",
			If(
				drpStatus.Selected.Result = "All",
				If(
					drpDeployment.Selected.Result = "All",
					'Client Database',
					Filter(
						'Client Database',
						Deployment = drpDeployment.Selected.Result
					)
				),
				If(
					drpDeployment.Selected.Result = "All",
					Filter(
						'Client Database',
						Status = drpStatus.Selected.Result
					),
					Filter(
						'Client Database',
						Status = drpStatus.Selected.Result,
						Deployment = drpDeployment.Selected.Result
					)
				)
			),
			If(
				drpStatus.Selected.Result = "All",
				If(
					drpDeployment.Selected.Result = "All",
					Filter(
						'Client Database',
						Class = drpClass.Selected.Result
					),
					Filter(
						'Client Database',
						Deployment = drpDeployment.Selected.Result,
						Class = drpClass.Selected.Result
					)	
				),
				If(
					drpDeployment.Selected.Result = "All",
					Filter(
						'Client Database',
						Status = drpStatus.Selected.Result,
						Class = drpClass.Selected.Result
					),
					Filter(
						'Client Database',
						Status = drpStatus.Selected.Result,
						Deployment = drpDeployment.Selected.Result,
						Class = drpClass.Selected.Result
					)
				)
			)
		),
		txtSearchText.Text, "Last_x0020_Name", "E_x002d_mail_x0020_Address", "First_x0020_Name"
	),
	"Last_x0020_Name",
    Ascending,
    "First_x0020_Name",
    Ascending
)

[Drrickryp]

Hi @JulieHeadlee 

The interaction between SharePoint and PowerApps can sometimes be peculiar with respect to column names.  Please check your new SharePoint list to make sure that the column names are correct. ref. https://powerusers.microsoft.com/t5/Building-Power-Apps/Collection-column-names-not-displaying-corre... 

FYI Best practices: Avoid the use of spaces in field names by using Camel case (lastName), Pascal case (LastName) or Snake case(Last_Name).  

[JulieHeadlee · Accepted solution]

I eventually just threw out the code and started over, without referring to the old.  It worked.  There was have been something strange that I just coulnd't see.  

I unfortunately am stuck with the wordy column names.  I wish I could change them, but it would break other things.  Such is work life 🙂