Unanswered

Power Apps Sort By Column Error

(0) Share

Report

Posted on by AshleyTaylor

Hello All,

I am trying sort and filter multiple columns in a gallery. I am using the following formula:

SortByColumns(
 Filter(
 colDatabase,
 StartsWith(
 'ID',
 txtID.Text
 ) && (Field1 = drpField1.Selected.Value || IsBlank(drpField1.Selected.Value)) && ("Field2_x002f_Machine" = 'drpFieldMachine2'.Selected.Value || IsBlank('drpFieldMachine2'.Selected.Value)) && (OperationStatus = drpOperationStatus.Selected.Value) && IsBlank(drpOperationStatus.Selected.Value) && (Created >= dteStart.SelectedDate || IsBlank(dteStart.SelectedDate)) && (Created <= dteEnd.SelectedDate || IsBlank(dteEnd.SelectedDate))
 ),
 varSortColumn,
 varSortDirection
)

When I try and use the formula I get an error on column OperationStatus "The specified column ("Column Name") does not exist or is an invalid column type"

I had the same issue with column "Field Machine 2" but I resolved this by using the Sharepoint list 'system' name

"Field2_x002f_Machine"

I have tried using the system name for "OperationStatus" but this does not help. I have removed and re-added the data source and deleted and re-created the column to no avail.

Any help much appreciated

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Daniel Bocklandt 5,151 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Could you show us what kind of Data you have in your Dropbox and what kind of data is in your Column.
to be sure that you get the data you expect from your Dropbox try putting it into an Text label and see what you get.

Was this reply helpful? Yes No
AshleyTaylor on at

Like (0)

Report
Copy link

Link copied!
Thanks for the reply.

In the drop box I have a selection of options in the 'Items' property.
["","Option 1","Option 2","Option 3","Option 4"]
In the Sharepoint list the column is set to single line of text.

Can you elaborate on the putting the dropbox inside a text label?

Thanks

Was this reply helpful? Yes No
Daniel Bocklandt 5,151 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
inside the Textlabel text property you can set this formula
Dropdown1.Selected.Value
If there is an error it is probabl that the controll returns a table value instead of a string

Was this reply helpful? Yes No
AshleyTaylor on at

Like (0)

Report
Copy link

Link copied!

I have just checked as requested and this works as expected

Was this reply helpful? Yes No
Daniel Bocklandt 5,151 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Can you check the name of the Column again?
you can find it inside the URL of the Sharepoint

you can find it there under settings.

If that doesn't work can you create a Gallery and a dropdown on a sepparate screen. Add 3 Textlabels into the gallery and use your Datasource as Item in the Gallery.
In on Label you put the Column, in the second one Dropdown1.Selected.Value and in the third
If(TextLabel1.Text=TextLabel2.Text="OK","false")

Was this reply helpful? Yes No