You’re offline. This is a read only version of the page.
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?
@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.
Share
Report
All responses (
Answers (
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!
I would suggest you use a calculated column or a Formula column for that purpose.
Calculated Columns:
Formula Columns:
https://learn.microsoft.com/en-us/power-apps/maker/data-platform/formula-columns
#1
mmbr1606
22
Super User 2025 Season 1
#2
stampcoin
17
#3
ankit_singhal
11
Super User 2025 Season 1
