Updating a sharepoint list based on what user selected in combobox

[acolyter]

Hi all,

I'm trying to figure out how to update a ShP list item based on what user selected in combobox. I have 1 sharepoint list that cointains some information a 2 sharepoint list that I want to copy and paste the information into from the sharepoint list 1. 

What I have is a combobox in which a user can select certain value. If that happens (user selects something), I want to take what he selected and paste it inside a column into a sharepoint list 2. 

I have this line of code, but it seems it doesn't work with comboboxes:

UpdateIf(Catering, 'Subject' = UdalostVar.'Subject', { 'Cost center': Nakl_Stredisko_Combobox.Selected } );

The 'UdalostVar' is variable that I created above so the user can select the row that needs to be updated.

Any idea how to do this?

Thanks!

[RandyHayes]

@acolyter 

This will depend on what type of column 'Cost center' is and what your Items property of the combobox is.

If you can expand on those details, that would be helpful.

[acolyter]

@RandyHayes 

'Cost center' is a Number type column. 

Items property of the combobox is:

Distinct(Filter('Nákladové středisko', Person.DisplayName = User().FullName), Cislo_Strediska)

I'm taking the information from sharepoint list 1, that's the 'Items' property in the combobox.

[RandyHayes · Accepted solution]

@acolyter 

Very good.  Then consider changing your original formula to the following:

UpdateIf(Catering, 
    'Subject' = UdalostVar.'Subject', 
    { 'Cost center': Value(Nakl_Stredisko_Combobox.Selected.Result) } 
);

[acolyter]

Perfect, that works. Thank you!