web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Set Date Variable and ...

Power Apps

Answered

Set Date Variable and Update Date/Time Field Value based on a specific scenario

(0) Share

Report

Report

Posted on by KMagadia

48

Hi,

Is there anyone here who knows how to properly set Date/Time variable?

Currently I am using Set(varLMApprovalDate, Blank()) but it doesn't get accepted when I put varLMApprovalDate on my date field Default value.

Also, once entry is saved, there are some instances where I have to update the date field value to Now();

Note: Variable is then set to Set(varLMApprovalDate, {Value: Now()}) and I also tried below:

Set(varLMApprovalDate, DateValue(DateValue3.Now() + Time(Value(HourValue3.Now()), Value(MinuteValue3.Now()),0)));

Any suggestions?

Regards,

-K

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (1)

WarrenBelz 153,051 Most Valuable Professional on at

Like (0)

Report

Hi @KMagadia ,
Try enabling Formula Level Error Management as below and try again.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
Verified answer

v-bofeng-msft on at

Like (1)

Report
Hi @KMagadia :
Do you want to create a variable named varLMApprovalDate whose value is datetime type?
Firstly,I want to point out some of the following formulas that I think are not reasonable.

Set(varLMApprovalDate, {Value: Now()})

The point is {Value: Now()} is a record instead of a datetime type value.
Secondly,I suggest you try this code(Delete the three formulas you mentioned and use the formulas below😞

Set(varLMApprovalDate, Now())

Best Regards,
Bof

Was this reply helpful? Yes No
KMagadia 48 on at

Like (1)

Report
Hi @v-bofeng-msft

As suggested, I set my variable to:

Set(varLMApprovalDate, Now())

And then I updated my DateDataCard's default property value to:

Text(varLMApprovalDate, "[$-en-US]mm/dd/yyyy hh:mm:ss")

Having these 2 setup, I manage to get my stuff done.

Thanks for your help! 🙂

Regards,
-K

Was this reply helpful? Yes No

Join the conversation