web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps is it possible to add ...

Power Apps

Unanswered

is it possible to add a business rule that sets default date as today

(0) Share

Report

Report

Posted on by Tango

1,168

Hi,

I have a date column in Dataverse and would like to set its default value to today if a different column has a specific value.

Flow is not really an option as its too slow.

Thanks

Todd

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Jonathan Manrique 2,687 on at

Like (0)

Report
Copy link

Link copied!
Hi @Tango

Not Business Rules as a business rule, but you can use Javascript or a WorkFlow to do it

function formOnload(executionContext) { // Get a reference to the form context var formContext = executionContext.getFormContext(); // Create a new Date object to get today's date var today = new Date(); // Set the value of the date field formContext.getAttribute("nombre_del_campo_fecha").setValue(today); }

Another way is to use Power Fx,

Was this reply helpful? Yes No
AliceW 286 on at

Like (0)

Report
Copy link

Link copied!

Use this
If('Field A' = "Confirmed", Now())
Works for fields with String values

if 'Field A' is a Choice field:
If(Field A ='Field A (Table)'.Confirmed, Now())
Good luck!

Was this reply helpful? Yes No

Join the conversation