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

All responses Img

All responses (3)

Answers Img

Answers (1)

Sort by

WarrenBelz 156,532 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

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.
Verified answer

v-bofeng-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
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
KMagadia 48 on at

Like
a
(1)

Report
Copy link

Link copied!
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

Join the conversation