cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
TxSteve
Regular Visitor

Is it possible to populate Title field with Choice, Date and/or Person fields?

Hello, I am new to Power Apps. I am using with a SharePoint list,  and want my title field to populate from other data on my form. I've seen a reference in this forum, but it is for single line text boxes. My form does not contain single line text boxes. For example:

 

DataCardValue3 - Product (Choice): Chair, Table, Lamp, Picture

DataCardValue4 - Is the Product Available (Choice):  Yes, No

DataCardValue5 - Product Availability Colors (Choice):  Red, Blue, Green, Orange

DataCardValue1 - Created (Date):  12/02/2019

DataCardValue2 - Created By (Person): Doe, John

DataCardValue6 - Title (Single Line):  Default = Parent.Default

 

I'm looking to make Title not visible on the form, but upon submit from a Save button, it would display in my SharePoint list as

Lamp-Red-12/02/19     or even something with the users name: Table-Orange-Doe, John

 

If I changed Parent.Default, what should I type in to replace?

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Is it possible to populate Title field with Choice, Date and/or Person fields?

@TxSteve 

To generate a Title in the style of Lamp-Red-12/02/19 you would use code similar to this.

 

DataCardValue3.Selected.Value & "-" &
DataCardValue5.Selected.Value & "-" &
Text(DataCardValue1.SelectedDate,"mm/dd/yyyy")

 

Or to generate a Title in the style of Table-Orange-Doe, John you would use code similar to this.

 

DataCardValue3.Selected.Value & "-" &
DataCardValue5.Selected.Value & "-" &
DataCardValue2.Selected.DisplayName

 

I am certain you are already aware that to make the Title datacard hidden you must change the Visible property to

 

False

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

View solution in original post

1 REPLY 1
Super User
Super User

Re: Is it possible to populate Title field with Choice, Date and/or Person fields?

@TxSteve 

To generate a Title in the style of Lamp-Red-12/02/19 you would use code similar to this.

 

DataCardValue3.Selected.Value & "-" &
DataCardValue5.Selected.Value & "-" &
Text(DataCardValue1.SelectedDate,"mm/dd/yyyy")

 

Or to generate a Title in the style of Table-Orange-Doe, John you would use code similar to this.

 

DataCardValue3.Selected.Value & "-" &
DataCardValue5.Selected.Value & "-" &
DataCardValue2.Selected.DisplayName

 

I am certain you are already aware that to make the Title datacard hidden you must change the Visible property to

 

False

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

View solution in original post

Helpful resources

Announcements
MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

‘Better Together’ T-Shirt Contest – Winner Announced!

‘Better Together’ T-Shirt Contest – Winner Announced!

And the winner is...

firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Apps Community!

Power Platform 2020 release wave 1 plan

Power Platform 2020 release wave 1 plan

Features releasing from April 2020 through September 2020

Top Solution Authors
Top Kudoed Authors
Users online (6,585)