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 component framework

All responses (2)

Answers (1)

Khibby 39 on at

Like (0)

Report

Incompatible Types for Comparison

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

Kim
Verified answer

AndrianaO 187 Super User 2025 Season 1 on at

Like (2)

Report

Incompatible Types for Comparison

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!