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:

General Questions

Connecting to Data

Using Apps Using Formulas

All responses (5)

Answers (1)

Dave-ITMan on at

Like (0)

Report

Re: Dropdown Selection to Patch Straight to SharePoint List

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.
Cat Schneider 488 Most Valuable Professional on at

Like (1)

Report

Re: Dropdown Selection to Patch Straight to SharePoint List

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.
Dave-ITMan on at

Like (0)

Report

Re: Dropdown Selection to Patch Straight to SharePoint List

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.
Cat Schneider 488 Most Valuable Professional on at

Like (0)

Report

Re: Dropdown Selection to Patch Straight to SharePoint List

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

Cat Schneider 488 Most Valuable Professional on at

Like (1)

Report

Re: Dropdown Selection to Patch Straight to SharePoint List

Change it from the OnSelect to the OnChange Behavior Property