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!
Solved! Go to Solution.
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
I copy your code but the Date Display as well:
Can you show the formula on:
DataCardValue36
------------
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.
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.
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
User | Count |
---|---|
254 | |
106 | |
92 | |
47 | |
37 |