Convert Multi-Select Choice Field to Checkboxes in Power Apps

[@Hesamiii]

Self.text also works

[@andrewhess123]

Thanks! Yep!

[@orleevelarde9997]

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

[@andrewhess123]

Yes collections are only stored in the memory of the app. But deleting what was written in SharePoint is another issue. Not sure how that could happen.

[@chinmaykadambalu6331]

Hi I am facing the same issue can you help me how to resolve this issue? Thanks in advance.

[@chinmaykadambalu6331]

@@andrewhess123 Hi I am facing the same issue can you help me how to resolve this issue? Thanks in advance.

[@andrewhess123]

When reloading the app, the collections should be blank this is not an issue, but the functionality. @@chinmaykadambalu6331

[@orleevelarde9997]

@@chinmaykadambalu6331 You will need to get the data from sharepoint and save (ClearCollect) it in the collection. Add this command on Main Screen (OnVisible).

[@susanteng3592]

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?

[@andrewhess123]

Hi Susan, Most likely the datasource is SharePoint and the submit button is just submit(form1). And I am writing the selection as a single line text

[@Vikki-zj4ss]

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

[@andrewhess123]

Hi Vikki, yeah with Dataverse Choice types are a little bit different! There's a couple tricks here or there that. I don't have a video on it specifically but I know Shane Young does at around 13 : 29 in his video kzbin.info/www/bejne/i3uVm6qFeMSHobssi=Bt8nUDh0zGJNVaeJ&t=809 .... I will have to make a video on it myself!

[@kenpennuto2590]

Thanks - if you read this. I followed another example of how to do this same thing except using gallery and then putting checkbox control inside it. Everything seems to work fine, with the exception of when my users create a new entry into the SP list, using the custom form, if they hit submit, and the form remains, waiting for another entry to the list to be made, there are ghost entries in the gallery checkboxes. I am using collections to store the values of what is selected but having no luck clearing that when the user would just continue to add another list item. I have labels present also that displays the selections / or contents of the collection when selections are made. They are incidentally clear when the new form appears, even though there is a ghost check in the boxes. Have you seen this behavior before/ any thoughts recommendations? Sorry, this was long, seems like there is a lot to explain and it's a complicated setup (to me).

[@andrewhess123]

I have a couple guesses but if when the user submits and it makes a ghost entry, and you are using collections. You will need to recollect to populate your gallery, if your gallery is attached to the collection. When you say ghost in the check boxes, does that mean you have to click it more than once for it to recheck? Try modern and classic checkboxes too, is there a difference?

[@kenpennuto2590]

@@andrewhess123 so the first time through the form, works fine. It is when the user begins a new form, after a submit action. The selections from the previous form submission are still checked, which is undesired. Interesting also is the label I have to troubleshoot and display what is in the collection indicates that the collection is empty at that time. User has to select another checkbox or uncheck and recheck to activate. So my issue is what remains after the first submission. Hope that helps clarify my issue. I used a gallery to set it up which is different from your method. I am going to try and set it up the way you did in video. Seems much less complicated.

[@kenpennuto2590]

@@andrewhess123 thanks for the reply BTW! 🥹

[@andrewhess123]

@@kenpennuto2590 So I have seen something similar I can't remember exactly what I did... but on the OnCheck and UnCheck Property set it to UpdateIf(colDetails,ID=ThisItem.ID,{varCheckbox:!varCheckbox}).... and on the Checked Property set to ThisItem.varCheckbox

[@andrewhess123]

@@kenpennuto2590 I remember when I did this video there was this "Ghost Checkbox" as you were calling it. kzbin.info/www/bejne/nnqng6imabGWfqc I think this video is very valuable and one of my better videos 😋this one were commenting on is old and outdated.

[@PowerAppsTutorial]

Very nice! ...and I love that mic!

[@andrewhess123]

Thanks Darren! 1 step at a time, now I need a green screen 😃

[@analyticsadda6080]

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

[@andrewhess123]

My assumption is the issue is with the collection, when you add the collection to the Listbox does it appear correctly?

[@gyanibaba5189]

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

[@andrewhess123]

Hi Gyani! On the OnCheck property of each of the boxes, have it either Reset the other checkboxes or set their values to false. Those are 2 options you could do.

[@gyanibaba5189]

@@andrewhess123 SharePoint choice column converted to check box in power apps using vertically gallery and check box, but all choice option display as same check box properties and not getting on check property for each choice options

[@christerrussberg3059]

Hi Andrew, thanks for this tip.

[@andrewhess123]

Hi Christer, thanks for watching! 😀

[@christos-spyridonmoschofid3978]

What does the galProjects stands for?

[@andrewhess123]

galProjects is the name of my gallery on my Home Screen, the one with the red/yellow/greens

[@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.

[@andrewhess123]

Hi Lance, for 30+ checkboxes I would probably make each of those a single line text field and convert them to checkboxes in Power Apps, I would separate them, instead of a large choice field. Thanks for watching Lance!

[@Jonathan_Vlog]

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

[@andrewhess123]

Hi Jonathan, I'm not sure about a Model Driven app using Dataverse. Model driven apps are limited in their functionality. I do think you could create a canvas app that has a Dataverse backend or use a Dataverse for Teams app and do this.

[@Jonathan_Vlog]

@@andrewhess123 Yes, it is very limited, specially this new field multiselect choices. If one tries to add check boxes, it asks you to connect it with some boolean field before dropping jn the form, so your multiselect field here is not visible. I had to achieve this using a long workaround, I thought you might have some shorter workaround like the one on the video. Thank you.

[@andrewhess123]

@@Jonathan_Vlog Yeah...not sure about how to get around it... yet

[@palikaanusha3043]

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

[@andrewhess123]

Hi Palika, it depends on how you have it set up, but you can set the default property to blank depending if its a new item, or edit item.

[@palikaanusha3043]

@@andrewhess123 thanks for your response

[@andrewhess123]

@@palikaanusha3043 Sorry for the late response, Holidays have taken a lot of my time 😀

[@meliajones4690]

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?

[@CaptCJ1969]

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!

[@andrewhess123]

Awesome Craig! Sorry I'm just getting back to you, glad you got it to work!

[@CaptCJ1969]

Hi Andrew,@@andrewhess123 I've used this on 3 apps now, it's been great. That said on the current app (which I started last year and I'm now revisiting), when I create a new form, all checkboxes are empty, however if I check a box and submit the form, when I view the form, it has pulled the results from the previous saved form as well. New form submitted with checkbox 1 only, new form submitted with checkbox 2 only, when viewing form 2, checkboxes 1 and 2 are checked. When I looked at my SP list, 1 of my submitted forms had multiples for the selections! If I add the list box back in to see what's in the collection, it is already populated when I create a new form, even though my checkboxes are correctly unchecked. It seems like the ClearCollect on the FormScreen isn't working. Any help would be welcome. Thanks Craig

[@neilstone6751]

Very helpful! Thanks

[@andrewhess123]

Thank you neil!

[@javierpereyra7098]

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

[@andrewhess123]

Thanks so much Javier! thanks for always supporting me! I appreciate it a ton!!!

[@shgall02]

How would you do this without a gallery?

[@mayankloayalka9635]

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

[@andrewhess123]

Hi Mayan, there's many things that could make this happen. Is your backend SharePoint? What does your OnCheck property say? On one of the check boxes, is it similar to Collect(colLifecycle, "Plan"), or is your column type a lookup instead of a multi choice field? Does it say Expected Record, and found what? Try this also, Collect(colLifecycle, {Value:"Plan"})..notice the curly brackets. There's lots of things that could be happening from that error message.

[@PauloHenrique-ln1vm]

Very good, thanks!

[@andrewhess123]

Obrigado amigo! Made an assumption you knew Portuguese, hope I was right 😅I also love learning other languages

[@geralddahl9159]

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!

[@andrewhess123]

Yes I believe you could make this work with Dataverse. SharePoint is only the backend, could work with any datasource I would think.

[@samk-ye1ev]

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?

[@andrewhess123]

Hi sam k, not sure about that one

[@northcastleintegration6066]

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

[@andrewhess123]

You are using Excel as a backend? I believe the steps would be different, you would want to convert the Update Property to a text instead of a choice.

[@andrewhess123]

A collection will not write to an Excel cell. You can write the Concat statement as a text field and then write that to Excel.

[@northcastleintegration6066]

@@andrewhess123 Thanks. I will try that and let you know!

[@northcastleintegration6066]

It populated, now I just need to figure out the if() statement to write only checked values.

[@andrewhess123]

@@northcastleintegration6066 Awesome, glad you got it! Feel free to reach out, willing to help any time.

[@jl1399]

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

[@andrewhess123]

Yes