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

6 REPLIES 6
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. 

 

sachk1
Helper III
Helper III

I also watched hat video. 

 

I have the similar issue with sharepoint form.

 

Is there any method that success?

kindum86
New Member

I have got the same issue, I think it is not working in SharePoint list customization using the integration way, that works when using the canvas app and data source SP list. 

 

If anyone has a solution please share us.

 

Thank you

Helpful resources

Announcements
Ignite 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Users online (1,438)