Updating a SharePoint list choices column with gallery selections

[westerdaled]

Yesterday,  I had an issue  with positioning a gallery control in a Data Card.  Ironically , I was still able update the Data Card choices column with a collection built up of choice values.  Just when I placed the gallery in the Data Card this seem to stop working🙄

Just to recap, I have DataCard for a choices column which is hidden, but highlighted in the pic below.. I have expanded the DataCard and placed a Gallery control which hosts a single checkbox control :

The Gallery Items are populated with a SharePoint list.  Oddly I am having to use the Title column as otherwise I don't see any choice values  next to my checkboxes

'Supervision Types'.Title

I use the checkbox->check event  to simply keep collection maintained of choices

Clear(colSupervionTypesSelected);
// get each selection
ForAll(Filter(galSupervisionTypes.AllItems, chkSupervisionTypeSelected.Value = true), Collect(colSupervionTypesSelected,Title));

Now in the Update method of the DataCard , I attempt to update this required column - but this is not currently working, so the form submit shows a missing required column error. The colSupervisorTypesSelected does indeed have 2 rows matching the user selected choices shown in the pic.

//DataCardSupervisionTypeValue.SelectedItems
colSupervionTypesSelected

[RandyHayes]

@westerdaled 

Your Gallery will not work properly in a DataCard of a form.

You will need to have the gallery outside of the edit form, or replace the edit form interface.

The reason is that there is a long running bug with Galleries in DataCards of edit forms in regard to referencing the controls within the gallery.  In your case, you are trying to reference the checkbox in your gallery.

It will not work and your results will not be accurate.

I hope this is helpful for you.

[CNT]

@westerdaled Place this code in the Update property of the DataCard

Filter(galSupervisionTypes.AllItems, chkSupervisionTypeSelected.Value=true)

[RandyHayes]

@CNT 

That will produce blank results.  Using a Gallery in a form datacard and referencing child controls from the AllItems is not supported.

EDIT: That is...unless they have resolved this long running bug!  I will look at an old app to determine if it is still an unresolved issue.

[RandyHayes]

@westerdaled 

To do this properly, I assume your underlying column is a multi-select choices column in your list.

Based on that assumption...

(this part for those that are trying to follow this and learn from it - you can ignore this paragraph because you already still have your combobox that was originally there)

Return your datacard back to its original settings (remove it and add it back).  You should have at that point a datacard with a combobox control in it.  Leave the combobox as-is.  Unlock your datacard.

For purposes of explanation, I will refer to the cobobox in your datacard as Combobox1.

If it is still set as default, it should have a DefaultSelectedItems property of: Parent.Default

Add a Gallery into the datacard and set its Items property to: Choices([@yourDataSource].ChoiceColumnName)

In the Gallery add a Checkbox control and set the following:

   Text property : ThisItem.Value

   Default property:  Self.Text in Combobox1.SelectedItems.Value

   Reset property: !IsBlank(lclChecks)

   OnCheck Action:  UpdateContext({lclChecks: lclChecks & Self.Text & "|"})

   OnUncheck Action: UpdateContext({lclChecks: Substitute(lclChecks, Self.Text & "|", "")})

In the Update property of the DataCard in your form, set the formula as follows:

   ForAll(Filter(Split(lclChecks, "|"), !IsBlank(Result)), {Value: Result})

And finally - in the OnSuccess Action of your form, add the following formula:  UpdateContext({lclCheck:Blank()})

This will give you the functionality you are looking for while avoiding the bug of galleries in the edit form.

[westerdaled]

@RandyHayes and @CNT  Thanks so much for your responses.  I seem to have unwittingly stumbled on the bug - the only reason the gallery is in the datacard  ,  to handle the when the user scrolls. and I can move my checkboxes accordingly. Ok I shortly try out your suggestion @RandyHayes  . Got some admin and compliance stuff to do first unfortunately . 

[RandyHayes]

@westerdaled 

No problem.  You can utilize the solution I provided to work around the bug in the form issue, but I still recommend revisiting your first attempt at having the Gallery outside of the form...it will be MUCH easier.  

As mentioned in the other post where you were told to put it in the Form, you can move your entire form and gallery into a scrollable canvas datacard and then you will not have to worry about the form scrolling without the gallery...and you're done!

[westerdaled]

@RandyHayes 

Ok, reading the other post , it looks like there are now 2 approaches on the table .  If I go down the scrollable DataCard , will I still be able place the gallery where it is now albeit not  inside the current Supervision _Types Data Card? The "keep it looking the same" UI is important to my users

[RandyHayes]

@westerdaled 

Absolutely.  You would be essentially putting the form and the Gallery into a canvas datacard.  Your canvas datacard should be as large as the edit form - so that the form never scrolls.  The Gallery can be placed where you want in respect to the form.  Then the canvas would be made smaller (so it will scroll) and placed where you like it on your screen.  Then, everything will scroll together.

[CNT]

@westerdaled @RandyHayes 

Just checked on it and it seems to be OK.