Unanswered

Filtering Gallery help

(0) Share

Report

Posted on by thomasw1964

139

The goal is to sort available gallery data to show clients who are Active in the veterans' program or a Graduate. 
I have both SharePoint data sources attached to this application

Sort(

Filter(

'Clients Sign Out Sheet',

ClientId.ClientStatus = "Active" &&

(ClientId.Program = "Veterans" || ClientId.Graduate = "Yes")

Created,

SortOrder.Descending

)

I am getting an error on (ClientId.Program = "Veterans" || ClientId.Graduate = "Yes") the equal signs: Incompatible types for comparison. Both of these are choice columns in SharePoint

I have tried the following as well:

Sort( Filter( 'Clients Sign Out Sheet', ClientId.ClientStatus = "Active" && ClientId.Program.Value = "Veterans" || ClientId.Graduate.Value = "Yes") ), Created, SortOrder.Descending )

------------------------------------------------------------------------------

Sort(

Filter(

'Clients Sign Out Sheet',

ClientId.ClientStatus = "Active" &&

(Value(ClientId.Program) = "Veterans" || (Value(ClientId.Graduate = "Yes")

)),

Created,

SortOrder.Descending

)

Any help is much appreciated on this

Categories:

Building Power Apps

All responses (10)

Answers (0)

Sort by

Rajkumar_M 3,747 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @thomasw1964

Try this formula,

Sort(
Filter(
'Clients Sign Out Sheet',
ClientId.ClientStatus.Value = "Active" &&
(ClientId.Program.Value = "Veterans" || ClientId.Graduate.Value = "Yes")
),
Created,
SortOrder.Descending
)

Thanks!

If my response has been helpful in resolving your issue, I kindly request that you consider clicking "Accept as solution" and "giving it a thumbs up" as a token of appreciation.
thomasw1964 139 on at

Like
a
(0)

Report
Copy link

Link copied!

Still shows an issue with .Value
mmbr1606 14,629 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

hey @thomasw1964

what kind of column is this? have u tried selected.value?

Let me know if my answer helped solving your issue.

If it did please accept as solution and give it a thumbs up so we can help others in the community.

Greetings
thomasw1964 139 on at

Like
a
(0)

Report
Copy link

Link copied!

ClientStatus is Single line of Text
Program is a Choice column
Graduate is a Single line of Text
mmbr1606 14,629 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

text column have .text and choice selected.value

Let me know if my answer helped solving your issue.

If it did please accept as solution and give it a thumbs up so we can help others in the community.

Greetings
Rajkumar_M 3,747 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
@thomasw1964 Try this

Sort(
Filter(
'Clients Sign Out Sheet',
ClientStatus = "Active" &&
(Program.Value = "Veterans" || Graduate = "Yes")
),
Created,
SortOrder.Descending
)

Thanks!

If my response has been helpful in resolving your issue, I kindly request that you consider clicking "Accept as solution" and "giving it a thumbs up" as a token of appreciation.
thomasw1964 139 on at

Like
a
(0)

Report
Copy link

Link copied!

Sort(
Filter(
'Clients Sign Out Sheet',
ClientId.ClientStatus.Text = "Active" &&
(ClientId.Program.Selected.Value = "Veterans" || ClientId.Graduate = "Yes")
),
Created,
SortOrder.Descending
)

Still the same result
Rajkumar_M 3,747 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Try this formula instead of your formula,

Sort(
Filter(
'Clients Sign Out Sheet',
ClientStatus = "Active" &&
(Program.Value = "Veterans" || Graduate = "Yes")
),
Created,
SortOrder.Descending
)
thomasw1964 139 on at

Like
a
(0)

Report
Copy link

Link copied!

I wouldn't expect that to work since we are not telling it to reference the other list attached
Rajkumar_M 3,747 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Try this

Sort(
Filter(
'Clients Sign Out Sheet',
ClientId.ClientStatus = "Active" &&
(ClientId.Program.Value = "Veterans" || ClientId.Graduate = "Yes")
),
Created,
SortOrder.Descending
)