cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
modernoddity
Level: Powered On

Cannot save combo box

Had a combo box in a form that is getting data from a different Sharepoint list than the rest of the form. Thanks to you guys I was able to get it to save correctly using the update function of the data card. 

 

Unfortunately that produced a new problem that I can't seem to solve. Later in the app, the information from that combo box is displayed in another combo box in view mode but can be edited by the user. I can get the combo box to display the previously selected items, I can get it to allow user's to add and remove items..... I CANNOT get it to save back to the Sharepoint list. 

 

Combo box properties currently: 

DefaultSelectedItems: Gallery_Select_Employee_1.Selected.Distribution_Lists

Items: Distinct(Filter('Distribution Lists', Department=CDD_Department_1.Selected.Value),Title)

 

Current save properties: 

 

Patch('Config Sheet', Defaults('Config Sheet'), {
    Full_Name:CT_FullName_1.Text,
    Title:CT_Title_1.Text,
    Cell_Phone:CT_PhoneNumber_1.Text,
    Personal_Email:CT_PersonalEmail_1.Text,
    King_Estate_Email:CT_KE_Email_1.Text,
    Extension:CT_Extension_1.Text,
    Department:CDD_Department_1.SelectedText,
    Supervisor:CT_Supervisor_1.Text,
    Start_Date:Date_StartDate_1.SelectedDate,
    Status:CT_Status_1.Text,
    Microsoft_License:CDD_License_1.SelectedText,
    Revel:Combo_Revel_1.SelectedItems,
    HotSchedules:Combo_HotSchedules_1.SelectedItems,
    NVPOS:CDD_NVPOS_1.SelectedText,
    Computer:CDD_Computer_1.SelectedText,
    Computer_Model:CT_Model_1.Text,
    Computer_Serial:CT_Serial_1.Text,
    Company_Phone:CDD_CompanyPhone_1.SelectedText,
    Change_Log:CT_ChangeLog_1.Text,
    Activation_Date:Date_ActivationDate_1.SelectedDate,
    Deactivation_Date:Date_DeactivationDate_1.SelectedDate,
    Printer_ScantoEmail: Check_ScanToEmail_1.Value,
    G_Drive: Check_GDrive_1.Value,
    Revel_Management_Console: Check_Mgmnt_Console_1.Value,
    HotSchedules_AboveStoreConsole: Check_ASC_1.Value,
    Butterfly: Check_Butterfly_1.Value,
    Cameras: Check_Cameras_1.Value,
    Distribution_Lists: Combo_DL_1
    
});

 

When I run this, it deletes the entire record. No idea why... it doesn't do that when I don't include the Distribution List. 

Have also tried removing the Distribution_Lists from the Patch statement and doing an Update or UpdateIf. Tried pulling everything into a collection first and then transferring data to Sharepoint. 

I'm sure I'm missing something simple.... but any help would be SUPER appreciated. 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Cannot save combo box

Hi @modernoddity 

 

Could you please share more details of your two SP lists's column type? Choice?look up or what?

Could you please share more details of your combobox?

 

This case is Patch Patch-Combobox-to-SharePoint-Choice-Coloum, you can reference it firstly:

https://powerusers.microsoft.com/t5/General-Discussion/Patch-Combobox-to-SharePoint-Choice-Coloum/m-...

 

Best Regards.

Yumia

View solution in original post

1 REPLY 1
Community Support Team
Community Support Team

Re: Cannot save combo box

Hi @modernoddity 

 

Could you please share more details of your two SP lists's column type? Choice?look up or what?

Could you please share more details of your combobox?

 

This case is Patch Patch-Combobox-to-SharePoint-Choice-Coloum, you can reference it firstly:

https://powerusers.microsoft.com/t5/General-Discussion/Patch-Combobox-to-SharePoint-Choice-Coloum/m-...

 

Best Regards.

Yumia

View solution in original post

Helpful resources

Announcements
New Ranks and Rank Icons in April

'New Ranks and Rank Icons in April

Read the announcement for more information!

Better Together’ Contest Finalists Announced!

'Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

thirdimage

Community Summit North America

Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (4,474)