Power Platform Community Forum Thread Details

Hi All,

I have a sharepoint list integrated with the power apps form. I am trying to edit records in the share point list. There is a requirement, when i change a particular combo box selection while editing, there are dependant combo box which needs to be reset and the values already populated in the list should be reset to blank if the user doesn't select any value.

The current role is the master combo box. I have added the below statements for on change event of the combo box,

/*Reset the dependant combobox*/

Reset(ComboBox5);

/*If the mode is edit, set a variable to reset the default selected items. there is no way to directly reset the default selected items in edit mode*/

If(SharePointForm1.Mode=FormMode.Edit,Set(Varchange,Varchange+1));

Defuault selected items property of ComboBox5:

If(SharePointForm1.Mode=FormMode.View,Table({Value: Parent .Default}),If(And(SharePointForm1.Mode=FormMode.Edit,Varchange<=0),Split(ThisItem.'Current Foundation Skills',","),Blank()))

Update Function:

Concat(ComboBox5.SelectedItems,Result,", ")

After changing values in master combo box, i see the value is changing to blank in the dependant combo box. However when i click on save, the older values are retained in the list and blanks are not updated.

On Save:

SubmitForm(Form1)

Any help here would be much appreciated.

Thanks.

Categories:

Building Power Apps