Answered

Incompatible Types for Comparison Issue

(0) Share

Report

Posted on by Robert_

Hi All,

I'm working on Power Apps and I want to filter out a gallery by status = Submitted but exclude any records in which the current user (the approver) is already listed as Approver. I'm not sure why, but when I use =!, I get a "incompatible Types for Comparison" error but not if I just use "=".

Here is the code that I want:

SortByColumns(Filter(Requests, ReqStatus="Submitted", Approver=!varUserName), "ID",Descending)

This code does not work. But if I make Approver = varUserName, it works.

SortByColumns(Filter(Requests, ReqStatus="Submitted", Approver=varUserName), "ID",Descending)

What I am missing here? I want to avoid any operator that is non-delegable.

Thanks,

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

BCLS776 8,994 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

The ! operator works with boolean variables. Have you tried Approver <> varUserName instead?

Hope that helps,

Bryan
Robert_ 36 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for the reply. I must be doing something wrong because it is not accepting !. See attached.

I want to avoid <> because it is not delegable. My SP list will eventually exceed 2,000 rows.
Verified answer

BCLS776 8,994 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
You cannot use the ! operator on a variable that contains a string - that's why you're seeing an error.

To help with delegation on a SP list, try using a With() to pre-filter and then filter out all records that match varUserName:

With({aFilter: SortByColumns( Filter(Requests, ReqStatus="Submitted"), "ID", Descending )}, Filter(aFilter, Approver <> varUserName) )

This should work as long as the total number of records with a ReqStatus = "Submitted" is less than the non-delegable query limit of the app.

Bryan
Robert_ 36 on at

Like
a
(1)

Report
Copy link

Link copied!

Thanks a million @BCLS776. That seems to work. And yes, I anticipate that ReqStatus = "Submtted" will always be less than the non-delegable query limit!