cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Katrina96
Frequent Visitor

Automatic title Solution with Now() function

Hi all,
i need to create automatic title as "Request_ClientLastNameClientFIrstNameYYYY-MM-DD"
i put fomula in Default property "Requested_"&DataCardValue36.Selected.DisplayName&Text( Now(),"[$-en-US]mm/dd/yyyy hh:mm:ss"), but it doesn't display Date in my solution only this part "Request_ClientLastNameClientFIrstName" 
I am begginer in PowerApps and maybe somebody know how to solve it right 
Thanks!

1 ACCEPTED SOLUTION

Accepted Solutions

Hi@Katrina96,

Do you want to save the customized string to the Title column in your SP list?

Could you please tell me that how you save data, a Patch or SubmitForm()?

1). If you use the SubmitForm()

set the Update property of the Title data card as below:

DataCardValue1.Text

set the OnSelect property of the submit button as below:

SubmitForm(Form1)

2). If you use a Patch() 

set the OnSelect property of the submit button as below:

Patch(UserStatus,Defaults(UserStatus),{Title:"Requested_"&DataCardValue5.Selected.Value&Text( Now(),"[$-en-US]mm/dd/yyyy hh:mm:ss")})

Note: UserStatus is my SP list name, please replace it with yours.

Regards,

Qi

 

Best Regards,
Qi

View solution in original post

7 REPLIES 7
eka24
Super User
Super User

I copy your code but the Date Display as well:

Can you show the formula on:

DataCardValue36

 

Date2.JPG

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

It doesnt display on my SP list , you can see only 'Request_ClientLastNameClientFIrstName'  
DataCardValue36 consist info about ClienName or Group Name

Do you want to save  "Requested_"&DataCardValue36.Selected.DisplayName&Text( Now(),"[$-en-US]mm/dd/yyyy hh:mm:ss") into your Sharepoint List or you want to display that in power apps?

 

If you want to save, are you using a SubmiForm or Patch

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

 

when i submit form , this should save in my SP list 

Can you show  a screen shot of the Datacardvalue  or the form and the formula in that default?

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Yep

Hi@Katrina96,

Do you want to save the customized string to the Title column in your SP list?

Could you please tell me that how you save data, a Patch or SubmitForm()?

1). If you use the SubmitForm()

set the Update property of the Title data card as below:

DataCardValue1.Text

set the OnSelect property of the submit button as below:

SubmitForm(Form1)

2). If you use a Patch() 

set the OnSelect property of the submit button as below:

Patch(UserStatus,Defaults(UserStatus),{Title:"Requested_"&DataCardValue5.Selected.Value&Text( Now(),"[$-en-US]mm/dd/yyyy hh:mm:ss")})

Note: UserStatus is my SP list name, please replace it with yours.

Regards,

Qi

 

Best Regards,
Qi

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Power Apps Ideas

Changes to Ideas Coming

We are excited to announce a new way to share your ideas for Power Apps!

Top Solution Authors
Top Kudoed Authors
Users online (1,598)