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
but it shows none at edit mode.
Solved! Go to Solution.
Hi @GMRaju3
To set or retain the checkbox values, we need to make sure 2 things
Clear(CollectioName);
If(FormName.Mode <> FormMode.New)
(
Collect(CollectionName,
LookUp(SPList,ID=SharePointIntegration.SelectedListItemID,ColumnName)
)
Thanks,
Stalin - Learn To Illuminate
Hi @GMRaju3
To set or retain the checkbox values, we need to make sure 2 things
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
and formscreen onvisible property
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.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
User | Count |
---|---|
202 | |
100 | |
61 | |
59 | |
57 |
User | Count |
---|---|
256 | |
163 | |
90 | |
79 | |
70 |