Answered

Updating a sharepoint list based on what user selected in combobox

(0) Share

Report

Posted on by 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!

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@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.

Was this reply helpful? Yes No
acolyter 92 on at

Like
a
(0)

Report
Copy link

Link copied!
@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.

Was this reply helpful? Yes No
Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
@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) } );

Was this reply helpful? Yes No
acolyter 92 on at

Like
a
(1)

Report
Copy link

Link copied!

Perfect, that works. Thank you!

Was this reply helpful? Yes No