web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Set Current Date and T...

Power Apps

Unanswered

Set Current Date and Time to a Variable

(0) Share

Report

Report

Posted on by Trout19

395

I am wanting to create a unique id with the current date and time. I have it set to set the variable in the StartScreen currently.

Also, how would you clean the record up to have a string of numbers only. For example, 06062024953

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (5)

Answers Img

Answers (2)

Verified answer

madlad 2,637 Moderator on at

Like (1)

Report
Hi!

To do this, it should just be something along the lines of:

If(IsBlank(Param("ID")), Set(VarRand, Text(Now(), "mmddyyyyhhmmss")))

The if function is just what you already had, and "Text(Now(), "mmddyyyyhhmmss")" formats it as you specified.

Hope this helps!

Was this reply helpful? Yes No
Trout19 395 on at

Like (1)

Report

Great thanks, I had to move it to on Start for it to work.

Was this reply helpful? Yes No
Trout19 395 on at

Like (0)

Report

@madlad I put varRand in a textbox text control to test it and it is not coming through.

Was this reply helpful? Yes No
Verified answer

madlad 2,637 Moderator on at

Like (1)

Report

Looks like it's Blank currently - try running OnStart from the 'App' Selection in the Screen view and see if that sets it

Let me know how it goes!

Was this reply helpful? Yes No
Trout19 395 on at

Like (0)

Report

Ok it populated. I moved to the create new button so it would create when I created a new item.

Was this reply helpful? Yes No

Join the conversation