Answered

How do I get my single line of text datacard to display the data it saved in SharePoint?

(0) Share

Report

Posted on by Spawn10

326

I have a SharePoint person datacard on a form that I am using to display contacts. When a use selects a Contact from the Person column, there is a single line of text Datacard that should display the contact's email address. The default value for the email datacard is

ThisItem.'Contact Email'

and the Update property is set to the control's value...

ContactEmailValue.Value

And the Valu property for this control in the datacard is,

MyPersonColumn.Selected.Name.Email

Then I am using this Patch statement to save the data in my SharePoint list

Patch (
 'MySPList',
 LookUp ('MySPList', ID = ThisItem.ID),
 {
  'Contact Email': MyPersonColumn.Selected.Name.Email
 }
)

So far this is working and the contact's email address is being saved to the list correctly. However if I open my form again, the field that holds the contact email is blank. How do I set this up correctly?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

WarrenBelz 153,775 Most Valuable Professional on at

Like (2)

Report
Copy link

Link copied!
Hi @Spawn10,

The issue is that until a value is selected in MyPersonColumn (I assume this is a Combo Box), only DisplayName exists there. You have two choices - make the Value of your Text Input
Coalesce( MyPersonColumn.Selected.Name.Email, ThisItem.'Contact Email' )

OR make the DefaultSelectedItems of MyPersonColumn
{ DisplayName: YourPersonField.DisplayName Email: YourPersonField.Email }

NOTE: If the Items of the Combo Box are based on Office365Users.SearchUser then the DefaultSelectedItems would be
{ DisplayName: YourPersonField.DisplayName Mail: YourPersonField.Email }

Please ✅ Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider answering Yes to Was this reply helpful? or give it a Like ♥
Visit my blog Practical Power Apps LinkedIn

1 people found this reply helpful.

Was this reply helpful? Yes No
Spawn10 326 on at

Like (0)

Report
Copy link

Link copied!

@WarrenBelz Thanks a million for this.

Was this reply helpful? Yes No
Haque 199 on at

Like (1)

Report
Copy link

Link copied!
Hi @Spawn10,

The email text datacard’s Default property is set to: ThisItem.'Contact Email' - which is a plain text field. But the control’s Value property is set to MyPersonColumn.Selected.Name.Email - which is a complex object path that works only when selecting a person, not when loading existing data.

We can do the following: when opening the form set the Default property of the email text input control to:

If( !IsBlank(ThisItem.'Contact Email'), ThisItem.'Contact Email', "" )

Note: This confirms when the form loads, the email text box shows the saved email address.

Then, please set the Update property of the email datacard to: ContactEmailValue.Text, (considering ContactEmailValue.Text is the text input control inside the datacard)

For the Person datacard (MyPersonColumn), keep the Default property as ThisItem.MyPersonColumn

When patching, do something like you have done:

Patch( 'MySPList', LookUp('MySPList', ID = ThisItem.ID), { 'Contact Email': ContactEmailValue.Text } )

Was this reply helpful? Yes No