Answered

Dropdown Selection to Patch Straight to SharePoint List

(0) Share

Report

Posted on by Dave-ITMan

Hi Experts,

I've got an app that has a dropdown box with 3 items. When the user selects one of the 3 items, I want it to patch straight away to my sharepoint list. The code that i've used in my OnSelect of dropdown box is below but it only seems to select the first option in the list when I click on the arrow of the dropdown box.

Select(Parent);
Patch(
 TicketingSystem,
 'Gallery-Tickets'.Selected, 
 {
 Technician: 
 'Dropdown-Technician'.Selected.Value
 }
)

Thanks in advance!

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Verified answer

Cat Schneider 488 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Change it from the OnSelect to the OnChange Behavior Property

Was this reply helpful? Yes No
Cat Schneider 488 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Also, you're intending for this to be a single-select option, not multi-select, correct?

Was this reply helpful? Yes No
Dave-ITMan on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @CatSchneider ,

Thanks for the quick reply, doh! Can't believe I didn't notice that! That changes it perfectly, but for some reason when you select one from the list, it changes it in the sharepoint list but on the screen to the user it doesn't look like it's changed as it's still just showing the first option in the list, do you know how to change that please? Yes just single option thanks.

Was this reply helpful? Yes No
Cat Schneider 488 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Is the Dropdown default set to the List item field value? If so, after the Patch function, chain a reset (be it a context variable if you're using a form, or call for a Reset(Dropdown1)) and the field should populate with the value from SP. Otherwise, I'd have to know more about how that Dropdown is populated/related to the specific record being edited in SP.

Was this reply helpful? Yes No
Dave-ITMan on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @CatSchneider ,

I've changed the default property to ThisItem.Technician as it was set to the default "1" which looks to have worked! Thank you for your help - much appreciated.

Was this reply helpful? Yes No