Combo box default value not displaying edit From

[ezi79]

Hi 

I need help with combo box issue 

I got massive form and it contains over 22 person fields.

I am storing person Display Name and  email   in different SP list. My main list storing the person display name in  a text filed because of the SP limitation on choice columns.

I used Combobox in my app to select person

When I create new item I can select the person  from my SP person list and can save to main SP list as a text ok 

When I try to edit the item all person fields in PA (Combo box fields) are empty. How do I set to default or default selected Items property for combo box so when i choose edit it displays the selected item from gallery?

I set to combo box properties as follows ;

Default : LookUp(PeopleChoices, Lower(Person.Email)=Lower(Parent.Default))

DefaultSelectedItems: LookUp(PeopleChoices, Lower(Person.Email)=Lower(Parent.Default))

Items :Filter(PeopleChoices, Role="PresenterLUX")

Combo datacard Update:  cPLUX.Selected.'Display Name'

Any help would be appreciated 

[RandyHayes · Accepted solution]

@ezi79 

Your problem is...you are storing the Display Name in your column not the email.  So, your DefaultSelectedItems (DSI) will never match.  By the way, you can get rid of the Default formula, it does nothing on a Combobox.

Change your DSI property to:

    DefaultSelectedItems: LookUp(PeopleChoices, Lower(Person.DisplayName)=Lower(Parent.Default))

I hope this is helpful for you.

[ezi79]

@RandyHayes 

Thank you very much for your help .I actually decided to store the person email address in my main SP list and I changed the formula as; 

Update property of the data card to cPLUX.Selected.Email

DefaultSelectedItems to LookUp(PeopleChoices,Lower(Person.Email)=(Lower(Parent.Default)))

I got delegation problem . Any ideas how to resolve it?

I guess my other question is , is there any other way of how to display person columns from another list  and save it to different SP list as email?