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
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

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