cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
GMRaju3
Helper I
Helper I

multiselect check boxes in custom SharePoint form with PowerApps not retaining check box values

Multiselect check boxes in custom SharePoint form with PowerApps not retaining check box values in edit and view mode of the SharePoint list item.

 

As per REZA's tutorial on YouTube. The last form screen code setting to gallery selected category field values cant work as I am converting the dropdown to check boxes on a SharePoint custom form. Unable to retain the selected values at dropdown or check boxes on edit and display modes . Any help please

here is the simple format I was trying this feature with

Test2 item had two choices selected

GMRaju3_0-1642769963290.png

but it shows none at edit mode.

 

GMRaju3_0-1642769692409.png

 

1 ACCEPTED SOLUTION

Accepted Solutions
StalinPonnusamy
Super User
Super User

Hi @GMRaju3 

 

To set or retain  the checkbox values, we need to make sure 2 things

 

  1. Set the Default property of the Card to the collection where you have Gallery (Note: Data Card not the control)
  2. Onvisible property of the screen

 

Clear(CollectioName);
If(FormName.Mode <> FormMode.New)
(
Collect(CollectionName, 
LookUp(SPList,ID=SharePointIntegration.SelectedListItemID,ColumnName)
)

 

 
Thanks,
Stalin - Learn To Illuminate

View solution in original post

4 REPLIES 4
StalinPonnusamy
Super User
Super User

Hi @GMRaju3 

 

To set or retain  the checkbox values, we need to make sure 2 things

 

  1. Set the Default property of the Card to the collection where you have Gallery (Note: Data Card not the control)
  2. Onvisible property of the screen

 

Clear(CollectioName);
If(FormName.Mode <> FormMode.New)
(
Collect(CollectionName, 
LookUp(SPList,ID=SharePointIntegration.SelectedListItemID,ColumnName)
)

 

 
Thanks,
Stalin - Learn To Illuminate

Thank you for the reply. I have tried the formula but didnt work

 

Default property of the datacard

GMRaju3_0-1642779631090.png

 

and formscreen onvisible property

 

GMRaju3_1-1642779700836.png

 

 

Hi @GMRaju3

 

I assume checked data saved to Sharepoint properly. To investigate the issue, Can you insert the label on the form to set the multiDD field to see where the data is able to retrieve properly?

 

Concat(LookUp('Custom SP From Design',ID=SharePointIntegration.SelectedListItemID,multiDD), Text(Value) & ";")

 


Thanks,
Stalin - Learn To Illuminate

 

Yes, label is showing values from SP list and I have managed to get checkboxes ticked as per the default values saved to SharePoint list for that item. 

 

Something wrong and  replacing the items to empty record for dropdown control..😓

I will hide the dropdown control anyways for this form. 

 

Thanks a lot for your quick response. 

 

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on June 15, 2022 at 8am PDT.

PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

PA.JPG

New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

Top Solution Authors
Top Kudoed Authors
Users online (2,027)