Unanswered

Business Rule - Set A Field Value for a Date to Now?

(0) Share

Report

Posted on by cmanning

228

I am working on a business rule to populate a "Date Completed" field when Status changes to several options. When any of these conditions are met, I want to set the Date Completed to Now(). Can this be done?
DV Business Rules for Date Now.png

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Mira Ghaly 11,413 Moderator on at

Like (1)

Report

@cmanning

I would suggest you use a calculated column or a Formula column for that purpose.

Calculated Columns:

https://learn.microsoft.com/en-us/power-apps/developer/data-platform/calculated-rollup-attributes#calculated-columns

Formula Columns:

https://learn.microsoft.com/en-us/power-apps/maker/data-platform/formula-columns

Was this reply helpful? Yes No
cmanning 228 on at

Like (0)

Report
@Mira_Ghaly - Thank you for your response and for pointing me in the right direction.

I created a new formula column "DateClosed" and pasted this code.

If( IssueStatus = IssueStatusChoices.'No Issue Found' Or IssueStatus = IssueStatusChoices.'Outside Our Scope' Or IssueStatus = IssueStatusChoices.'Requires ServiceNow Ticket' Or IssueStatus = IssueStatusChoices.'User Failed to Respond' Or IssueStatus = IssueStatusChoices.Cancelled Or IssueStatus = IssueStatusChoices.Resolved, UTCNow(), Blank() )

When a new or existing record's IssueStatus is set to one of the choices listed in the above code, "DateClosed" will bet set to UTCNow(). Otherwise, it is set to Blank(). I have tested this and it works great!

Was this reply helpful? Yes No