Answered

Incompatible Types for Comparison

(0) Share

Report

Posted on by Khibby

I'm setting this run OnStart in the app, but keep getting the dreaded "incompatible types for comparison". I'm at a loss and can't get past it. Any help would be greatly appreciated.

ClearCollect(colMyActiveProjects,Sort(Filter('Project Stage',(ProjectManager.Email)=varUserEmail && 'Status'="Active"),Title));
 
Thanks!
Kim

Categories:

Power Apps Pro Dev & ISV

All responses (2)

Answers (1)

Sort by

Verified answer

AndrianaO 242 Moderator on at

Like
a
(2)

Report
Copy link

Link copied!

Hi Kim! I suspect your Status field is a choice, so you need to modify the formula as follows:

ClearCollect(colMyActiveProjects,Sort(Filter('Project Stage',(ProjectManager.Email)=varUserEmail && 'Status'.Value ="Active"),Title));

Let me know if it works!
Khibby 60 on at

Like
a
(0)

Report
Copy link

Link copied!

It's always the little things that get me! Thanks so much for pointing out the obvious. :)

Kim