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

 

View solution in original post

7 REPLIES 7
eka24
Super User III
Super User III

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.

Katrina96
Frequent Visitor

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.

 

Katrina96
Frequent Visitor

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.

Katrina96
Frequent Visitor

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

 

View solution in original post

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

secondImage

Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Top Solution Authors
Top Kudoed Authors
Users online (57,541)