Patching a Combo box with 2 fields

(1) Share

Report

Posted on by CM-07110527-0

Hi All,

I have something that I'm stumped by.

I have a Combobox that shows 2 fields (a surname and a first name, which are based on 2 lookup fields in Sharepoint). Is there any way to Patch or otherwise submit the choice made in the combobox to 2 Sharepoint Lookup Fields?

 
//Code getting an error, obviously
Patch('SharePoint List Name',Defaults('SharePoint List Name'),{LUSurname:ComboBox1.SelectedItems})
 
So, for example, I pick an item from the Combobox that is "Surname Field: Smith" and "First Name Field: John". How do I separate these so that when somebody selects "Smith, John" in the combo box, the Sharepoint list's Surname lookup patches to "Smith" and the First name lookup patches to "John"?
 
Apologies if this is unclear in any way, happy to answer any follow-ups.

Categories:

General Questions

Connecting to Data

Connectors

All responses (1)

Answers (1)

Verified answer

jpespena 264 on at

Like (2)

Report
Patching a Combo box with 2 fields

Hi,

Update the Items property of the combobox to:

AddColumns('DataSource', CustomName, $"{LastName}, {FirstName}")

Then change the Value property dropdown in the properties to CustomName.