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

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

AndrianaO 213 Moderator on at

Like (2)

Report

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!

Was this reply helpful? Yes No
Khibby 60 on at

Like (0)

Report

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

Kim

Was this reply helpful? Yes No