Convert Multi-Select Choice Field to Checkboxes in Power Apps

This question came from one of you, and thank you for asking. Such a great idea! In this video we use a multi-select choice field in SharePoint and covert it into multiple checkboxes in Power Apps.

As you select a checkbox and submit the form the data is saved as a multi-select choice field.

0:00 Introduction
1:20 Creating a Multi-Choice Field in SharePoint
2:00 Refreshing the Datasource
3:00 Replace combobox with check boxes
4:15 Collect OnCheck Property
5:04 RemoveIf OnUnCheck Property
6:20 View Collection in a Listbox
6:45 Update Property of Combobox Card
8:28 Concat Selection for Default Property
9:45 If Find() IsBlank()
11:14 OnVisible Property of New Form ClearCollect
13:50 Conclusion

Concat ThisItem Formula:
Concat(ThisItem.LifeCycle,Value,",")

Default of Checkbox Formula:
If(IsBlank(Find(Checkbox1.Text,Label15.Text)),false,true)

Update Card Formula:
colLifeCycle

OnVisible of Screen Formula:
ClearCollect(colLifeCycle,galProjects.Selected.LifeCycle);

[Vikki-zjss]

Hi Andrew, Thank you so much for the tutorial. Have been looking for this kind for many days.
I have been using data verse choice column with recommended type, which will refer choices from a choice table. Any thoughts or help on implementing these on those type of choice columns please? Thank you

[susanteng]

What is your code in submit button? Do you use patch? Do you have the code to patch the checkbox values to a multi-choice column in Dataverse table?

[carlilelance]

Nice. One of the clearest tutorials out there on this subject. Unfortunately, your method isn't very dynamic. What if you have a list of 30+ checkboxes. Becomes very tedious to hard code that.

[javierpereyra]

Very good content Andrew! thanks for always bringing something to teach us :)

[analyticsadda]

I want not able to use collection in data card update properties. It is throwing error. Expected record value

[Jonathan_Vlog]

Hi Andrew, thank your your video. Can you achieve this on a Form (For CRM) using Dataverse, how?

[orleevelarde]

I'm encountering an issue when reloading the powerapp. The collection is cleared upon reload and it deletes the data saved in sharepoint.

[gyanibaba]

Thanks for the useful content, But I just want to select only one check box at a time, means Single select check for list option, Could you please assist

[geralddahl]

Does this method work without forms? (I know your presentation is based around SharePoint but I'm envisioning Dataverse where I'm working with a multi-select combo-box in a gallery and wanting to display the results of the combo-box as checkboxes - as opposed to the combo-box just saying 5 items etc.) Thanks for this video - much appreciated!

[CaptCJ]

Hi,
I've been looking for a while on how to do this, thanks for the video.
I do have one issue, my collection doesn't seem to update with the selections
Thanks

It looks like using the 'Alt' key to test didn't work. When I went into full play mode, it kicked it into life!

[meliajones]

I have noticed when selecting a checkbox that selection is showing on all SharePoint records, not staying unique to the one editing. Can you assist with fixing that?

[mayankloayalka]

Hi whenever I enter colLifecyle in the update . I get an error stating expected Record Value can u please help

[palikaanusha]

How do I do reset the checkbox using customize forms, could you please help me that

[shgall]

How would you do this without a gallery?

[samk-yeev]

Hello, I tried the same approach for Data Verse as data source, it is giving "Expected OptionSetValue value" error on the update property when i entered collection name. any idea?

[northcastleintegration]

Every thing worked for me EXCEPT the Update. I put in the collection name (I double checked the spelling) but I get the red squiggly lines. I know the collection works because the list box test worked. When I submit the form, all of the fields get written to my Excel sheet, except for the collection. Is it because my "update" is in error? Thank you. - Paul

[jl]

Concat(ThisItem.LifeCycle, Value, ", ") what does LifeCycle in this formula represent? The column name?