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
Solved! Go to Solution.
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.
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.
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?