Formula Column Using Status Reason

(1) Share

Report

Posted on by CU01081947-0

716

Hello Power Apps Community.

Can you help please?

I'm creating a Formula column where I want to count the number of data between the 'Created On' column when the 'Status Reason' changes to the value of 'Done'. It's numerical value is 100.

I imagine I can do this with a real time workflow or a Power Automate Flow, but wanted to try it with a formula column. Below is the formula that I'm having trouble with.

If('Status Reason' = 100, 
    DateDiff('Created On', 'Modified On'),
    DateDiff('Created On', Now())
)
 
The error I'm getting is:
Incompatible types for comparison. These types can't be compared: OptionSetValue (publisher_transfertask_publisher_transfertask_statuscode), Decimal.

Any idea what I'm doing wrong, please?

Thanks,
 
Garry

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (7)

Answers (1)

RR-12011342-0 25 on at

Like (0)

Report
Copy link

Link copied!

Hi,

You cant use late bind like 100, try to use 'Status Reason'(table name).Value, here valur will be like Active or InActive.

Was this reply helpful? Yes No
Suggested answer

mmbr1606 14,615 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
hey

can you try this:

If( 'Status Reason'.Value = 100, DateDiff('Created On', 'Modified On'), DateDiff('Created On', Now()) )

if it helped please mark as verified answer

cheers

Was this reply helpful? Yes No
CU01081947-0 716 on at

Like (1)

Report
Copy link

Link copied!

Hello @mmbr1606,

Thanks so much for the reply. No luck, unfortunately.

I get this error "Name isn't valid. 'Value' isn't recognized."

Sorry.

Garry

Was this reply helpful? Yes No
Suggested answer

mmbr1606 14,615 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

what kind of column type are u using?

cheers

Was this reply helpful? Yes No
Verified answer

CU01081947-0 716 on at

Like (1)

Report
Copy link

Link copied!

Hello @mmbr1606,

Again, thanks so much for replying, especially on a weekend!

The column I'm using is the Status Reason column that comes on every Dataverse table. Sorry, I should have stated this on the original message. It's a Choice column.

I've been asking ChatGPT and it's been throwing everything at me, but eventually this worked. Please see below.

If(

Value('Status Reason') = 100,

DateDiff('Created On', 'Modified On'),

DateDiff('Created On', Now())

)

Thanks so much for your help!

Garry

Was this reply helpful? Yes No
mmbr1606 14,615 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

hey Garry

if it worked please mark your answer as solution so we can also help others with similar issues ;)

cheers

Was this reply helpful? Yes No
RR-12011342-0 25 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Try to use 'Status Reason'(table name).Value, here value will be like Active or InActive.

Was this reply helpful? Yes No