Dynamics Formula Column

(1) Share

Report

Posted on by RM-30040732-0

Hello!

Hopefully someone can help me format this formula properly! I've created a new column labelled IsOverdue and I want to be able to check whether the date has passed and the activity status is open. It seems to dislike the = part but I don't know how to resolve it! I've tried eq, equals, = and no joy!

All responses (2)

Answers (1)

RM-30040732-0 34 on at

Like (0)

Report

Dynamics Formula Column

Hi,

This didn't originally work work for me using email_email_statecode (also I do not have the option to use AI as I am not in the US) but by copying your code further down your message did work! Thanks!
Verified answer

Leah Ju Microsoft Employee on at

Like (0)

Report

Dynamics Formula Column

Hi，

Maybe you can try to use the folllowing:

If(ThisRecord.'Due Date' < Now() && ThisRecord.'Activity Status' = email_email_statecode.Open, "Yes", "No")

You can get formula suggestions From AI.

https://learn.microsoft.com/en-us/power-apps/maker/data-platform/formula-columns?tabs=type-or-paste#get-formula-suggestions-preview-1

1.Select “Get formula suggestions (Preview)” by clicking on the arrow which is the Get formula suggestions (Previews) label.

2.Describe what you want the formula to do, and Arrow to get the suggested formula for the provided expressions.

3.Pasted it at Type of Formula by simply clicking on and selecting fx Type of Formula.

Test：

I hope you can mark my answer verified if it answer your question! If you have any questions, please feel free to contact me.
Regards,
Leah