Multi Select Checkbox in Power Apps

[@francisnoonan2314]

You, Sir, have taken my PowerApp experience, albeit in it's infancy, from a discombobulated mess and given it structure and direction. Thank you so much for your help and ability to articulate clearly the steps to make this program behave. Two thumbs up!

[@RezaDorrani]

Thank You so much Francis.

[@fireflecked]

Finally - I've found the tutorial I needed! I've spent a week contorting various options in the hope of achieving EXACTLY this solution. Thank you sooooooo much for publishing this content - now I can finally move forward. It's been here for two years... yet had I only known a week ago... lol

[@RezaDorrani]

Wow! Looks like KZbin search relevancy is not good :)

[@fireflecked]

@@RezaDorrani it’s me too. I’m a baby power apper. So I didn’t know the right search terms.

[@RezaDorrani]

@@fireflecked :)

[@alexegharevba1026]

What's great about your video is you are addressing everyday issues we see in powerapps clear and straight to the point. Some Powerapp videos just have too much going on but yours are straight the point. Excellent stuff my friend.

[@RezaDorrani]

Fabulous feedback this. Love it. Thank You.

[@xclone2k]

Reza, one more time you deliver. Thank you for taking ideas from your viewers and taking the time to explain them in detail!

[@RezaDorrani]

This channel is for viewers. I only make videos for them. I am always on the lookout for video ideas. Once I get multiple requests that have a similar pattern, it triggers the creation of the video.

[@janesheng7113]

Hi Reza, Thank you! I have watched most of your videos. All brilliant. I have watched this video more than 10 times. Somehow I was still unable to get the checkbox checked for a selected item. The missing part is the checkbox's default value. I have fixed the issue by setting checkbox's default value as "ThisItem.Value in collection.Value".

[@RezaDorrani]

Hi Jane, that part got missed out in video edit. I had added the formula in the video description 😊

[@karthikathirooban7070]

Yeah, I spend 4 hr to find out the missing point. Finally saw this comment.:)

[@joanconnelly9547]

Thank you Jane, I've spent a bit of time on this and went back to the video 3 x's before looking here. I thought it was something I did incorrectly - thank you!!

[@joanconnelly9547]

@@RezaDorrani Reza, you can ignore my previous comment - thank you for the great video! Jane helped me fix it here. Unfortunately, I did what Karthik did and spent about 2 hours trying to see what I did wrong (I'm learning, so that happens fairly often :( ) Anyway, I never look here until I exhausted my potential errors, As always, your video's are fantastic - I greatly appreciate all your hard work on these. they are invaluable. Thank you, thank you, thank you!

[@RezaDorrani]

You are most welcome and sorry for giving you a tough time (I missed showcasing that default property in the video). It got edited out by mistake.

[@AnoopKumar-qx8to]

I noticed this behaviour but never deep dived.Reza Sir you nailed it as you usually do and everytime amazes power platform users with your useful tricks & hacks 👏👏

[@RezaDorrani]

Thank you Anoop

[@danielrumbak2530]

Brilliant Reza! I needed help with exactly this topic this week! Great timing! Thank you again as always for your brilliant content!!!

[@RezaDorrani]

Perfect!

[@anattal1639]

Thank you for a great video Reza! In my case, form is not loading from a Gallery, rather directly from SharePoint. The only missing piece now is how to load the existing data into colCategoryData. Unfortunately it doesn't work. I tried Collect(colPermissions,SharePointIntegration.Selected.Category) -> no luck. I think the OnVisible event is completed prior to loading the data, or something along that line. Can you please point me in the right direction?

[@RezaDorrani]

Might be a caching related issue. You may want to call or use the OnVisible fiunction of screen and clear collection on close of the customized form. I do not have a video reference on this scenario and would have to try it out to provide guidance. I recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.

[@ReinerKnudsen]

As always, my friend Reza, your video was a life-saver :) Sort of. I was able to adapt this in an app, I'm bulding for a client and it looks and works awesome.

[@RezaDorrani]

Fantastic!

[@shaiksamad1562]

Excellent Video Raza.. This video will be useful for most of the People as they are coming across these types of requirement...

[@RezaDorrani]

Thank You

[@tihralahn]

Thanks!

[@RezaDorrani]

Thank You!!!

[@alexmedialand7460]

Absolutely brilliant solution! I didn't like the multi-select choice in PA and your solution is perfect from the start to the end.

[@RezaDorrani]

Great to hear! Thank you for watching.

[@alexmedialand7460]

@@RezaDorrani In your demo, the gallery with checkboxes is displayed in a detail screen. The main screen records the value of the checkboxes in the datasource and populate the collection. What if the gallery with the checkboxes was in the main screen. How would you save and retrieve the checkboxes values? I tried witout success...

[@RezaDorrani]

@@alexmedialand7460 The collection should be loaded on select of item in the gallery. Also, on visible on main screen, the default selected item in gallery would need to be the data loaded in the collection.

[@alexmedialand7460]

@@RezaDorrani After many trials and errors, I found a solution which works for me: the checkbox default formula needs to be updated: Default= If(ThisItem.Value in CollectionName.Value, true, false). All the rest is exactly as you describe in the video. Alex

[@RezaDorrani]

@@alexmedialand7460 This was mentioned in the video description :)

[@roundearther]

There as always with an on-point and clear video. Thanks Reza!

[@RezaDorrani]

Much appreciated!

[@ImranAmiKh4n]

Thanks Reza this has been an immeasurable help as opposed to using a combo box

[@RezaDorrani]

Thanks for watching

[@arshad801]

Thanks a lot Reza..you have been a great help for this community. This is an amazing video

[@RezaDorrani]

Thanks Arshad

[@drbobmusic7401]

thanks for a great video Reza - I followed the steps to create the multi check boxes and it has worked in that it connects to the datasource (Sharepoint) and displays the choices however the update and default properties for the DataCard are coming up with an error - "The property on this control expects Record values. The rule produces Table values which are incompatible" I must have missed something - hellppp!!

[@RezaDorrani]

Make sure your column is of type Choice and multi select. I would have to look at your App in action to know the exact cause of your issue. I would recommend posting your issue with screenshots on the forums at powerusers.microsoft.com

[@radiosonicfan1726]

@Dr Bob. I had the same issue too. Even after changing column to allow multiple selections and refreshing data source, the datacard kept throwing the error. I started fresh by adding a new column with allow multiple selections, no error when pasting in collection as default property for datacard. Hopefully, this helps. I don't understand why sometimes PowerApps won't acknowledge SharePoint updates and new columns work. But it does.

[@tausifshaikh312]

I love your videos Reza sir you are lendor of last resort in power platform community 🎉🎉❤❤

[@RezaDorrani]

Wow, thanks

[@АйдарСитдиков-ъ2х]

Intelligible, clear, understandable! Thank you! God bless health!

[@RezaDorrani]

Thank you 🙏

[@priscilacs]

thank you so much, i watched a lot of videos, only your video worked.

[@RezaDorrani]

You are welcome!

[@StanOlbrot]

Superb ! I have 1 question : How to build the menu filter on left side of the home screen ? Have you any video about this ?

[@RezaDorrani]

Cascading dropdown filters - kzbin.info/www/bejne/f4iogqp9gciKbbM Gallery designs + filters - kzbin.info/www/bejne/mJ-maahpnMmKqdU Power Apps Multiple Gallery filters - kzbin.info/www/bejne/a5W2nGifhMyHbJo

[@xuyennguyen7110]

Thank you so much. Always learning abundance of knowledge from you.

[@RezaDorrani]

You are most welcome

[@scarmentube]

This is a great video, thank you for that. However I am struggling with a similar issue and I can't get over it. My scenario is more simple: I have a sharepoint list and I am modifying the form for it. I just want to show my multiple choice field as Checkboxes. How can I still acomplish this? Everything on your video worked for me except for tthe part where you check if the form mode is different from new and you want to keep the previously selected values. Any tip for this more simple scenario? Thanks in advance!

[@RezaDorrani]

I missed 1 key part in the video which is default value of checkbox. The missing formulas are in the video description.

[@minhvinhtube]

I like your process because if it's simpler that other method. However, the clear(collection) didn't clear the collection. Any thought?

[@RezaDorrani]

Check video description for a missing formula.

[@offthehookvideos1870]

Love your videos. I want to do something similar but trying not to use a form. Instead, use individual controls. One is a multi select choice and want to use checkboxes. I'm having trouble getting the checkboxes to show data for the item selected from a previous gallery.

[@RezaDorrani]

Thanks! I don’t have a specific video reference on that scenario. I will recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com

[@markjacobson9532]

Hi Reza, Great video and clear step by step instructions. Does the same approach that you have provided for Sharepoint list data source work for a dataverse table using a choice column. I currently have a combo box, but would like to change to a checkbox. It doesn't seem to like setting the Datacard "default" nor the "Update" fields to the "collection" per your instructions at 9mins 40s Any suggestions much appreciated. Cheers

[@RezaDorrani]

Approach should work but the formulas would be different. I would have to try it out to know what the exact formula would look like. I will recommend you check on the forums at powerusers.microsoft.com/

[@Empriction]

Excellent tutorial. Highly appreciated.

[@RezaDorrani]

You're welcome!

[@gayathriraja7098]

Hi Reza, Thank you for the video. But the last part I was unable to achieve with SharePoint custom form. How do I set these check boxes to category data card value in edit and view mode of the SharePoint custom form? Please let me know if not possible. Thanks

[@RezaDorrani]

I would have to look at your App in action to know the exact cause of your issue. I would recommend posting your issue with screenshots on the forums at powerusers.microsoft.com

[@boqunyin2797]

Thank you, Reza! This video is what I've been looking for! I am new to PowerApps, one quick question. Did you use SubmitForm() for the Submit button, or something different to address the gallery added to the form? Thank you!

[@RezaDorrani]

SubmitForm. It is a form control in which I have added a gallery to a data card. I believe the steps are in the video. There was 1 formula I missed which is in video description.

[@boqunyin2797]

Thank you

[@desikaunhai8983]

Hello Reza, You're amazing, love you videos. Question: I have followed this tutorial to the T but I can't see to clear collection when adding a new record. Any idea what might be happening? Thank you,

[@RezaDorrani]

Yes that is because of me :) Missed a part in the video. Formula is in video description.

[@desikaunhai8983]

@@RezaDorrani You're the best. Much appreciated.

[@balaram.ananda]

Hi Reza Dorrani, thanks for all your video tutorials on PowerApps. I have a question regarding number format with % symbol displayed in Edit and View form . appreciate your help here.

[@RezaDorrani]

If I can provide a quick response then post your question. Ideally the best place for questions/issues is on the community forum - powerusers.microsoft.com/t5/Power-Apps-Community/ct-p/PowerApps1

[@sanjaykarnoor8213]

Hi Mr.Reza Thanks for your video! What if we have an “All” options along with 5 existing and on select of “All” I want to check all 5 options and proceed. Do you have solution for this?

[@RezaDorrani]

I have done a video on select all for gallery where I have shown this concept. Do not remember in which video though. Idea would be to simply collect all items in collection when all is checked. I would also recommend posting your query on forums at powerusers.microsoft.com

[@conniemaldonado4884]

This is awesome, and I appreciate your step by step. Do you have a video which explains how to create the Work Progress Tracker form that you start with with the filters on the side? Thanks.

[@RezaDorrani]

Thank You. Side Filters - kzbin.info/www/bejne/eaaboXela7yjiKs

[@Adelina-s8d]

Hi Reza, very good video on how to work with a multiple-choice column, but even with this video I am facing some difficulties and I hope you can help me. How can I create a Select All checkbox, to have all options selected at once, and the value to be displayed in the SharePoint list when viewing or editing the item? I would very much appreciate an answer as soon as possible, thank you.

[@RezaDorrani]

I would have to try out select all in this scenario to know the steps and provide guidance. I will recommend checking or posting your query on the forums at powerusers.microsoft.com/ in case someone has done something similar.

[@Adelina-s8d]

@@RezaDorrani Thank you for your reply and advice, but unfortunately, I already checked their forum regarding " select all checkbox, and nobody could give the steps to follow from the beginning till end...

[@RezaDorrani]

@@Adelina-s8d May be you would need to look at getting consulting help for step by step guidance.

[@josuehurtado2749]

Thank you very much for the video. I have a question, when creating a new form it does not clear the boxes. Do you know what it could be?

[@RezaDorrani]

When creating a new form, you would need to ensure you Clear the collection. I show this in the video.

[@LAtotheZ]

Same as mine. I repeated the video over and over but the checkboxes remain ticked even if the collection is empty.

[@RezaDorrani]

@@LAtotheZ Check video description. It has a formula for default value of the checkbox. It got missed in the video.

[@Voltzz1982]

Thank you very much for your great videos! I run into an specific issue : the Form.Unsaved status doesn't change if we use this. Any idea how to get a save button that is available when a change is made in the form? (including the checkboxes)

[@RezaDorrani]

You can always check if collection was updated. You can create an additional collection on screen visible. When saving, if both collections do not match, that means a change was made. As for the steps, I do not have a video reference on this scenario and would have to try it out to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com

[@Voltzz1982]

@@RezaDorrani thank you very much for the quick reply. I'll work on this today!

[@hazehaze7820]

Very helpful just learned that I can add a gallery in a field

[@RezaDorrani]

👍

[@rpremaza]

This is great! just what I'm looking for. I need to expand this functionality a little I'm using this concept to create training requirements. Outside of the Checkbox gallery (but on the same screen) I have 2 dropdowns. One is employee name the other is instructor name. In the ONCHECK Collect statement, how do I include the selections in the 2 dropdowns. thanks

[@RezaDorrani]

Thanks Rob. It depends on how your backend data is structured. Oncheck add to collection where you maintain properties for checkbox selected and its associated employee and instructor names. I would have to look at your app in action to provide further guidance. I would recommend to post your query with screenshots on the forums at powerusers.microsoft.com

[@ahiqtidar]

Thanks for the tutorial, I used the same method as yours and made multiple choice selections in my app. On checking the boxes, it stores them in a collection. When I patch that collection to share point list, it only pushes one checkbox (the first one user selected) rather than pushing all the selected checkboxes

[@RezaDorrani]

I will have to look at your app in action to know the cause of your issue. I will recommend posting your issue with screenshots on the forums at powerusers.microsoft.com

[@ahiqtidar]

@@RezaDorrani ok I ll post, please check at earliest. Thanks

[@RezaDorrani]

@@ahiqtidar I only go to forums to assist in my free time. There are many other experts on forums. If this is a time sensitive issue, then I would recommend to get consulting help.

[@ruparamachandran2460]

Hi Reza, thank you! Exactly what I was searching for. But how did you patch multi selected values like group (you have used in this video) into the share point list?

[@RezaDorrani]

Video shows how to patch multi select values. Are you running into any issues? I would recommend you post your issue/query with screenshots on the forums at powerusers.microsoft.com

[@MirageC]

You are the best! Thank you :)

[@RezaDorrani]

You're welcome!

[@melc8895]

As with all your videos, this one is great too. Very easy to understand. Only one thing missing. What if the multi-select field also allows for fill-in choices? How do you add that ability and get that additional information into the collection as well? Sorry if you answered this already and I missed it in the comments.

[@RezaDorrani]

Fill in choices is not a direct option in Power Apps like SharePoint form has. I have not looked into how this can be done. I will recommend checking on forums in case someone has done something similar powerusers.microsoft.com

[@melc8895]

@@RezaDorrani Thank you. I did check the forum. I couldn't find anything that combines changing the multi-select column to check-boxes and allowing fill-in choices. I was thinking to add a text box to the card below the gallery and add that content to the collection as well but, I don't know how to do that,.

[@RezaDorrani]

@@melc8895 I'm not sure either until I try it

[@priyankagupta-wt5os]

Hi Reza, thanks for amazing video with step by step instructions, Can you please share the values and functions for gallarytask ?

[@RezaDorrani]

This video is focused on multi select checkboxes. I have done many videos on gallery connected forms which can help.

[@priyankagupta-wt5os]

@@RezaDorrani Thanks a lot, I will check..

[@danieldittert8571]

This is great. I can see the all the possible value defined in my SharePoint list as a checkbox. Also, the collection shows the right values BUT my checkboxes do not get checked based on the loaded data. Any idea what I am missing? Seems to be a connection issue between the gallery and the value of the checkbox. I have no idea what I am missing. Watched your video 3 times already. I deleted everything and started over and just wanted to see that the checkboxes are ticked before I even started with the collection to update the source. And still, it does not get checked. And ideas are highly appreciated.

[@RezaDorrani]

Video description has a missing formula. Please check that.

[@danieldittert8571]

@@RezaDorrani Perfect. That did the trick. Thanks a lot!

[@rajaamohammed6965]

Hi Reza, Thanks for this video. Just to check, User assigned with license 'Power Apps for Office 365 K1' will able to consume or preview Power Apps ?

[@RezaDorrani]

Yes - as per powerapps.microsoft.com/en-us/blog/powerapps-and-microsoft-flow-now-available-in-office-365-enterprise-k1-plan/#:~:text=The%20Office%20365%20Enterprise%20K1%20plan%20A%20core,apps%20without%20writing%20a%20single%20line%20of%20code.

[@sahilthakur03]

Thanks for sharing. I was overdoing this one by creating a new collection everytime when the New form was not opened. But Gallery control is a better approach. Even if someone changes the sharepoint list in the backend the gallery will read it and Edit form will still show the updated values.

[@RezaDorrani]

Thank you Sahil. Agree with all your comments.

[@dieterleyendecker5685]

Hi Reza, thanks a lot for the excellent idea to use checkboxes for multiple choices. I have integrated this in my app successfully. Unfortunately I have the situation, that the choices might change during the months, but I don't want to manually check if a choice has changed. I have stored all possible choices in a collection. Do you have an idea how I can use this collection instead of the fixed choices? I tested many hours on this but without success. Do you have an idea or a video where you can point me to? Many thanks in advance.

[@RezaDorrani]

I would have to try this scenario out to give proper guidance. Dynamic choices would be complex. I will recommend you check on the forums at powerusers.microsoft.com/

[@TheKillingExpress]

Great solution. Is there a way to customize the checkbox names to make it different than those from the list in Sharepoint?

[@RezaDorrani]

Possible. You would need to maintain the mapping somewhere (App or data source) and then add formulas to transform the values prior to saving.

[@RezaDorrani]

❗ Set default value of checkbox as follows: ThisItem.Value in colCategoryData.Value

[@onkarmajage3368]

That's what I was about to ask.. Why my selected options are not being checked. Thanks Reza🙏

[@RezaDorrani]

I will have to look at your App in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com

[@JaclynTatman]

Hello - This is a helpful video for creating the checkboxes. I tried to combine this video and your video on creating cascading dropdowns to create a cascading checkbox, however it is not working properly. I cannot get the checkboxes to display correctly with the right names. Do you have any videos or tips on this topic?

[@RezaDorrani]

I do not have any other specific video combining the 2 topics. I will have to look at your App in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com

[@JaclynTatman]

@@RezaDorrani I got it to work, but now my issue is that my form is not putting the data from my collections for the checkboxes into the SharePoint. I updated the Default and Update fields of my data card to the collections, but it still does not seem to be recording the selections correctly, even though my collections populate correctly when I am working on my app.

[@RezaDorrani]

@@JaclynTatman I cannot know about the reason for it not working on chat. Forums will be your best bet.

[@nnelson4192]

Great Video! how do we use show/hide feature using multiple selections. I have seen one of your videos on Show/hide options when it comes to multiple check boxes how do we handle it?

[@RezaDorrani]

Not sure if I understood the question. Show/hide feature? You can read the selections of the checkboxes and accordingly add formulas.

[@ayugmaacharya4487]

Hello sir! Thank you for the great video. I was wondering if you know a way where I could hide other fields when a certain checkbox was checked?

[@RezaDorrani]

On the visible property for those certain fields check to see if the combobox has that item selected.

[@crimsoncrayon]

@@RezaDorrani Would you be able to provide an example of what that formula would look like using this "multi select checkbox" video of yours?

[@RezaDorrani]

@@crimsoncrayon I would have to try it out to provide guidance. I will recommend posting your query with screenshots on the forums at powerusers.microsoft.com/

[@crimsoncrayon]

@@RezaDorrani I literally just figured out what I was doing wrong after posting that comment. Thank you for your videos. I am learning so much from you!

[@RezaDorrani]

@@crimsoncrayon 👍

[@anjaniniranjan4574]

Thank you Reza, its amazing to learn SharePoint with you. I need to patch multi selection lookup column, please share details.

[@RezaDorrani]

Patch function kzbin.info/www/bejne/nWqmmYyricmBmpY

[@maryannvinespacoma2758]

Hi Reza! This really helped me! I'm thinking if I use nested galleries of checkboxes, Is it the same as above?

[@RezaDorrani]

Yes, but the logic of setting the default value for data card would be different I guess.

[@maryannvinespacoma2758]

@@RezaDorrani I'm having trouble on setting the Default values of checkboxes in nested gallery. Would like to ask what syntax should I use

[@RezaDorrani]

@@maryannvinespacoma2758 ​ I will need to look at your App in action to provide guidance. I will recommend posting your issue with screenshots on the forums at powerusers.microsoft.com/

[@namananand2725]

Hi Reza, great video. Had one question, I want to add conditional required on select of these checkboxes. For eg if I select planning I want a description question, which I am able to do. But In case I select Planning and design I want both description and priority to be marked as required. Thanks in advance

[@RezaDorrani]

I do not have a video reference on this scenario and would have to try it out to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com

[@ilanneisse673]

Hi Reza, It's a brilliant solution. When trying to implement it with dataverse as a data source and choice list (rather than Sharepoint) The default and update properties of the datacard do not respond. The collection is populated but the records not updated accordingly. I suppose the collection is trying to pass text values to a "choices" column which wouldn't work. is there a workaround? Thank you very much for your insights.

[@RezaDorrani]

Thanks. Dataverse is a different database and the choice column logic will be different from SharePoint. Check my power apps playlist. I may have a video that cover that - kzbin.info/aero/PLTyFh-qDKAiEIVlidnhELx5BusnzlDzkR I will also recommend checking on the forums at powerusers.microsoft.com/

[@shellybarrett2960]

Thank you Reza, this was awesome. I do have a few questions because I kept getting an error on the Update and Default property. My field that I am using is not a multiple select choice field. It is a multi-line column in SharePoint. Would this not work, due to the data type? Also, if it does work, is there a video that shows how to submit the collection with a different delimiter than a comma. My items have commas in them and I would like to use a "/" or some other type of delimiter. Similar to when you used the concat statement and was able to identify how to separate your selections. Thank you again for the how to.

[@RezaDorrani]

It should work but the code would not be the same. That would be something I would have to try out and check. I do not have a video with that scenario. I would recommend you post your query with screenshots on the forums at powerusers.microsoft.com/

[@shellybarrett2960]

@@RezaDorrani So, I did post this to the Powerusers forum, but a question concerning your actual process. I have tweaked my process a little bit, where it is a multi-choice field like you have. I added the collection item as the Default and Update properties. However, when it submits to SharePoint, I have the collection getting formed as you did and set my Default and Update. However, the data wouldn't submit to SharePoint. I am doing a SubmitForm(FormName). Any thoughts?

[@RezaDorrani]

@@shellybarrett2960 I would have to look at all your formulas. If your values are not get saved then either the collection is empty or the data is not in the format that the column being updated expects.

[@shellybarrett2960]

@Reza Dorrani one difference between our two situations is I am pulling in the multi choice field as a container. The values stored in the choice field on share point are not the values that will be used in the form. I am pulling values from a share point support list. So I may need to rethink this process as the way you set it up will not work.

[@syedrafeahmed3644]

Hi Reza, thank you soo much for uploading this videos. I have a query regarding this, while updating Clear(CollectionName) on OnVisible property of screen, still items are checked on gallery. Please assist me for this. Thank you very much.

[@RezaDorrani]

Checking video description for missing formula

[@galinagolant]

Thank you!!!! Exactly info I need now.

[@RezaDorrani]

Glad it was helpful!

[@zattaka]

Hi Reza, many thanks for this. One question, the Valid property for the card remains false even though I have one or more checkboxes checked. Is this a limitation of how this is implemented, or is there a way of getting the Valid property of the card to correctly reflect whether one or more checkboxes has been checked?

[@RezaDorrani]

The Valid property should work. I did not run into any issue related to required field validation for the data card. I would recommend you post your issue/query with screenshots on the forums at powerusers.microsoft.com

[@dishankashetty9191]

Even i am facing issue with required field

[@DinaButros]

Hi Reza! thank you for this great video I followed step by step and everything is functional, I only wanted to have 2 boxes checked at all times, when someone wants to submit the form I want to have those boxes checked by default. how can I do that?

[@RezaDorrani]

If there are 2 check boxes all time and only 2 would always be selected, then why do we need to show the option of selection to user? I would have to try this to give the steps. I recommend posting your query on forums in case someone has done something similar powerusers.microsoft.com

[@DinaButros]

I have about 10 choices, but I only want 2 of them to be selected all the time

[@RezaDorrani]

@@DinaButros Ok. I would have to try it out to know the steps. Please post your query on the forums in case someone has done something similar

[@andrejam8939]

Thank you Reza. This helped me a lot but I still have problems. I have simple one FormScreen with one SharePointForm. That Sharepoint form I created gallery with checkbox. I follow your video and the problem is that one I select something as checkbox the list is populated but if I open that item the gallery with checkbox is either empty or check from previous selection.

[@sandrasitar5595]

Hi. I had the same problem. Found this in one of Reza's answers: Set default value of checkbox to - ThisItem.Value in colCategoryData.Value and this solved it for me. Hope it helps.

[@RezaDorrani]

Set default value of checkbox to - ThisItem.Value in colCategoryData.Value

[@andrejam8939]

@@RezaDorrani Thank you. I really missed that comment

[@andrejam8939]

@@sandrasitar5595 Thank you. I really missed that comment

[@1Pt21Jigawatts]

@@andrejam8939 me too and then it took me a minute to realize I needed to put that whole "ThisItem.Value in colCategoryData.Value" in the default after spending a couple minutes looking for a colCategoryData.Value section on the checkbox :)

[@ev689]

Reza, one quick question, what is the formula to be able to see the selected items on your Main Gallery Screen? I can't get them to show the "Combobox/Gallery" items in the main gallery. Thanks in advance Master!

[@RezaDorrani]

Assuming the data for multi-select column is being saved in your backend SharePoint List. Formula for main gallery label control text column would be Concat(ThisItem.ColName,Value,", ")

[@ev689]

@@RezaDorrani Amazing! it worked out thanks!

[@gsrinivas1293]

Hi Reza, I am using Custom powerapp form in sharepoint. Form submit is working, values are also getting saved to list but when i open edit form the check box values are not populated. I followed your approach but since I am using sharepoint form I need your help on what formula should i use onedit form as I have only 1 screen and 1 gallery(holding checkboxes)

[@RezaDorrani]

Check video description. It has a formula to set default value for checkbox (missed showing it in video).

[@kirankatkar2665]

Brilliant Reza👌Keep PowerApping

[@RezaDorrani]

Thank you

[@diltoncesarjunior1848]

Great Job Reza. Please do you have a content about How Alternate Selection Between Two CheckBoxes?

[@RezaDorrani]

I do not have any references on alternate selections.

[@diltoncesarjunior1848]

@@RezaDorrani Tks my friend!

[@ASHISHKUMAR-fi2kn]

Thanks for the video Sir. I'm stuck in one scenario, I have a combobox which is connect to a data source and based on the item selected in that combo box items are filtered in gallery. I want to select all the items in that combo box automatically when the page load where the combobox is placed. How I can achieve that?

[@RezaDorrani]

I do not have a video reference on this scenario and would have to try it out to provide guidance. I recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.

[@ASHISHKUMAR-fi2kn]

@@RezaDorrani Thank you for the response. Let me check it.

[@beccad3296]

Thanks Reza, this is a great tutorial. I just appear to have one issue. I am using this in a multi screen form and when I click the next button to go to the next screen it checks FormName.Valid and then attempts to do a SubmitForm if it is not valid in order to trigger the validation errors to appear. For some reason, with this checkbox method, I have to click the Next button twice before it registers that there is a value in the checkboxes that applies to the datacard. Do you know of any way around this?

[@RezaDorrani]

You should not have to click twice. Check to see what data is loaded in collection the first time. I will have to look at your App in action to provide any guidance. I would recommend you post your issue/query with screenshots on the forums at powerusers.microsoft.com

[@satyajitachary6358]

Facing the same issue , any one has any suggestions ?

[@RezaDorrani]

@@satyajitachary6358 Video description has a default property formula for the checkbox. Hope you have that set.

[@RezaDorrani]

Video description has a default property formula for the checkbox. Hope you have that set

[@beccad3296]

I ended up rewriting the validation for the form and not using the default validation.

[@jeevakumartimirilakshmipat8468]

Hi Reza, Awesome Video. I have used master checkbox outside gallery to check and uncheck all checkboxes with in a gallery. But when I submit the form data is not feeding into SharePoint column. If i select individual checkboxes in gallery it is working fine. Kindly help on this. Thanks.

[@RezaDorrani]

I would have to see the code base or try it out. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com/

[@amigomusa]

Excellent video again Reza... I have a question for you though: I implemented this concept on a form that pops up and it's working when the form mode is New, however, when I click on the Edit Button, the previously selected checkbox never defaults. Could it be because the OnVisible property code does not execute on a Popup form?

[@RezaDorrani]

Check the video description for the formula to set checkbox default. That was 1 part I missed in the video which is related to setting checkbox default value.

[@amigomusa]

@@RezaDorrani Thank you, Reza, it is working now...

[@knightliu7247]

@@RezaDorrani I watched your video over 10 times and finally, I solved the issue. I want to remind you here but I notice you wrote ******Set default value of checkbox to - ThisItem.Value in colCategoryData.Value *****. I didn't notice it at during 10 times' watching because it is hidden if I didn't expand description lol

[@RezaDorrani]

@@knightliu7247 So sorry for that. I missed showing that part in video and realized it later. I thought description was a good place to post it :)

[@gsrinivas1293]

Hi , can you tell me you used a sharePoint custom form and on visible property what formula didi you use as i have only one gallery( holding checkboxes).

[@Ezra-xc9rz]

In this demo you are using a Gallery to manage the selection of items. I am relying on standard SharePoint UI and, as such the conditional logic assigned to the OnVisible property of the "Form Screen" does not apply in my case. In the Collect() function, inside the IF statement, what should I be using to reference the current item/record? "ThisItem" does not work/resolve.

[@RezaDorrani]

I would have to try it out to know the steps. I recommend posting your query on forums at powerusers.microsoft.com

[@Ezra-xc9rz]

@@RezaDorrani will do, thank you

[@engineeringcanvas8073]

Excellent video, I am currently trying to save several users in the same field of a sharepoint list from a power apps form but it only saves the last selected user in my combobox, any idea how to solve it? Thank you very much.

[@RezaDorrani]

I will have to look at your App in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com

[@dwisniow]

Hi Reza, again great video! I would like to use multi select check box feature to select few attachments from a gallery (which is connected to a sharepoint document library) and send them via email in power apps. Wondering if you captured this option already in some of your videos or maybe planning for the future. Thanks!

[@RezaDorrani]

I do not have a video on the check box feature for attachments from a gallery. I will recommend you check on the forums at powerusers.microsoft.com/

[@veronikamaurer8411]

9:45 you put your collection into update and default of the card, it does not working, if data are connected to excel ?

[@RezaDorrani]

I have not come across the mentioned issue and hence not sure what the reason for your issue is. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com

[@fatimakabir1]

Thank you so much for this video. I have followed your video to create the "multi select check boxes". In the view form, for the Update and Default properties, if I set it to the collection, I get an error saying "There is an error in the formula. Try revising formula... Data Type: Table". Strangely I don't get this error on my Edit form. Any ideas why I get this error.

[@RezaDorrani]

I will have to look at your App in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com

[@fatimakabir1]

@@RezaDorrani thank you for your response. I will do that .

[@sachinjain3482]

Hello Sir, This video is very helpful for me and it helped me lot. I am currently facing Delegation issue with filter in Multiline of text field and the Dropdown/Combo box which are not showing more than 500 records, Please let me know how we can manage these delegation case. Thank You

[@RezaDorrani]

Multi line and combo boxes do not support delegation.

[@aliasadi8058]

Hi Reza, Thanks for this great tutorial. When I want to assign my collection as Default and Update properties of the data card containing the gallery, I receive error. Could you tell me what am I doing wrong?

[@RezaDorrani]

I will have to look at your App to know the reason for your issue. I will recommend posting your issue with screenshots on the forums at powerusers.microsoft.com

[@aliasadi8058]

@@RezaDorrani Thanks for your response Reza. I'll post it there.

[@grammarcheck3471]

Excellent, I would like to know if you a video where we can see from scratch how did you build the app, due to I'm seeing a lot of things that I want to learn how make it. Thanks

[@RezaDorrani]

Thank You. I would recommend my Power Apps playlist which includes a lot of concepts spread across multiple videos - kzbin.info/aero/PLTyFh-qDKAiEIVlidnhELx5BusnzlDzkR

[@chintandd]

thanks Reza for this video, it was very informative. However, at 9:57 step, when I tried assigning collection variable to Default/Update property of choice datacard, it says "Expected Text Value". I tried the same in test form but result is the same. What am I missing here?

[@RezaDorrani]

Your column must be of type Choice (Multi-Select).

[@jessicafonseca6126]

@@RezaDorrani I have the same issue and my column it's a type choice column

[@RezaDorrani]

@@jessicafonseca6126 But is it multi select? Its difficult to provide guidance here on chat without looking at screenshots of your scenario. I would recommend posting your issue with screenshots on the forums at powerusers.microsoft.com/

[@IggyVanca]

You are a great teacher, Reza. Thank you very much for explaining such an important topic in Power Apps. I have learned a lot watching your videos. Please keep them coming. By the way, speaking of multiple check boxes selected in a gallery, is there any way to make the first check box in a gallery visible (unchecked) then the second check box be visible when the first check box is checked, then the third check box to be visible when the first two check boxes are checked, and so on.. I have 3 check boxes in my gallery (Stage 1 completed, Stage 2 completed, Stage 3 completed)..Thanks!

[@RezaDorrani]

Thanks so much for your kind words. I'm sure what you mentioned as your scenario is probably possible but it is not something I have done. I would have to try it out to know the steps. I will recommend checking or posting your query on forums in case someone has done something similar community.powerplatform.com/

[@IggyVanca]

@@RezaDorrani Thanks for your response, Reza. I'll keep searching for a solution including forums.

[@IggyVanca]

I found a workaround with creating rectangles over checkboxes and changing their visible property as needed. Created a label named Label3,Text property of the label = concatenated function of 3 checkboxes in the gallery: Concat(DataCardValue5.SelectedItems,Value &",") Visible property of 1st rectangle (over Checkbox1): Switch(Label3.Text, "Stage 1 completed,", true, "Stage 1 completed,Stage 2 completed,",true, "Stage 1 completed,Stage 2 completed,Stage 3 completed,",true ) Visible property of 2st rectangle (over Checkbox2): Switch(Label3.Text, "",true, "Stage 1 completed,Stage 2 completed,",true, "Stage 1 completed,Stage 2 completed,Stage 3 completed,",true) Visible property of 3rd rectangle (over Checkbox3): Switch(Label3.Text, "",true, "Stage 1 completed,", true, "Stage 1 completed,Stage 2 completed,Stage 3 completed,",true)

[@RezaDorrani]

@@IggyVanca Thanks for sharing

[@chadstone345]

Thank you Reza, for this really appricate it. I got the same situation, but I notice when you are creating a new record your form is in edit mode and I figure out gallery control is only visible in edit form mode. So, I got an issue with form control that if I change the form to new mode when crating a new record it is not showing gallery data coming from SQL server and if I change the from mode to edit nothing showing when I run the application. Any idea how to solve this please?

[@RezaDorrani]

The gallery control shows up in all form modes. The choices are loaded from my choice column. If your gallery is not loading, it mostly means the items property is not set correctly. I would recommend posting your issue with screenshots on the forums at powerusers.microsoft.com

[@chadstone345]

@@RezaDorrani Thanks Reza for this. You were right with gallery. In my case I am using SQL table which I need to show data in check box so using Distict I am able now show the data on gallery when form mode is new. Thanks a lot for this.

[@yedadashu9192]

Hi Reza, it's really useful and I am excited about every time you release, I have more than two choice fields and facing an issue of patching in fact I am able to create a collection, and the value displayed on the SharePoint list while editing the form the value became null. Do you have any suggestions? Thanks in Advance.

[@RezaDorrani]

Might have to do with a missing formula that I added in video description

[@zewdumaru7482]

Hi Sir !!! Can I ask you A question??? I have single line and choice SharePoint list column . I want to customize this list with power apps. If I want to replace the Choice column with Checkbox in the customized form, like you did this video in the category column ,how can I retain/keep the selected check box values while I am editing the SharePoint list Item( in the list) ??? Many thanks

[@RezaDorrani]

Video description has a formula that was missed. Try that and see if it works. If issue persists, I would recommend posting issue with screenshots on the forums at powerusers.microsoft.com

[@huntergamingyt5313]

Hi Reza, loved your videos. Helped me a lot in my work. I am stuck in one thing hope you could help. Could we apply onvisible property to true when 1 check box is checked and when it is unchecked the onvisible property sets to false to another item in the list. Example : i have applied your .slected.value = "" syntax in the desired item but when i check one of the box it shows the that item but when unchecked it still remains visible until another checkbox is checked. Waiting for your response.

[@RezaDorrani]

Thanks for watching & liking my videos. Possible. But I would have to try it out to provide the steps. If you have given it a try and running into issues, then I would recommend to post the issue with screenshots on the forums at powerusers.microsoft.com/

[@outhouse23]

Hi Reza, this was so helpful and awesome! I just had a question, regarding the last part where if you're editing it knows which checkboxes have been selected. If you're not using a gallery and instead want it to reference the item in Microsoft Lists, what would be the code? I have this but it's not working If( SharePointForm1.Mode FormMode.New, Collect( colCategorydata, LookUp('Name of List', ID = SharePointIntegration.SelectedListItemID).'Name of multi select choice column' ) )

[@RezaDorrani]

I do not have a video reference on the mentioned scenario and would have to try it out to know the code or confirm the code. I will recommend checking or posting your query on forums in case someone has done something similar community.powerplatform.com/

[@lauraolveravazquez3323]

The explanation is very good. I need to help, there is a problem whit my formula, i dont know how eliminate the error. The error is in value DataCardValue. Do you any suggestion?

[@RezaDorrani]

I will have to look at your App in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com

[@lauraolveravazquez3323]

@@RezaDorrani Thank you

[@christos-spyridonmoschofid3978]

Is there a way to also include check box option dynamically. E.g If there is an "Other" option in a checkbox, a text input appears that takes the required value.

[@RezaDorrani]

Possible but I do not have a video reference on this scenario. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.

[@jevkennedy]

Reza, thank you for your excellent work. I am having issues submitting my form. It does not populate my Sharepoint List with the items selected in the drop dox gallery. Can you share the code from your submit button please?

[@RezaDorrani]

All submit button does is submit the form. All the main logic is as showcased in the video. Check the video description, there was one extra formula for maintaining the default value that got missed in the video. Apart from that, if you follow all the steps, it will submit the data.

[@jevkennedy]

@@RezaDorrani That was it. Thank you so much!

[@zachbarnard7495]

Hi Reza- this video has SAVED US! My organization couldn't do the things we do in PowerApps without your help, so thank you, thank you, thank you!!! Out of curiosity, when you have a gallery with checkboxes and set the Wrap Count to x>1, eg, 3, is there a way to sort the checkboxes alphabetically down each column instead of across?

[@RezaDorrani]

You are most welcome. I don't think the alphabetical column type sort is possible.

[@jcweis469]

Hi Reza... Thank you so much for sharing your skills. This is helping me so much. I do have a question - how do I get the multiple selections to show in the gallery, like in your example app? Is it necessary to have that there for the OnVisible property of the edit formula to work? I got everything set up, no errors, but when I select different items in the gallery, the checkboxes in the edit form are not showing the correct selections for the selected item... Any help would be much appreciated.

[@RezaDorrani]

Be sure to follow all steps highlighted in the video. Its important to have the default property set for the data card and to reload the collection on which the gallery is based. For the checkboxes in the gallery, make sure to set the default formula.

[@jcweis469]

@@RezaDorrani Thanks for responding. I can't get Clear(colCategoryData) to actually clear out the collection when landing on my edit form. Thats one issue. The other is, I can't find in the video where it shows to set the default formula for the checkboxes in the gallery. I can see that the default is set to false in your video when you show the OnSelect and UnSelect properties... Is that what you mean?

[@RezaDorrani]

@@jcweis469 Set default value of checkbox to - ThisItem.Value in colCategoryData.Value

[@danielrumbak2530]

@@RezaDorrani Thank you for this! Huge help!

[@rutica]

@@RezaDorrani Set default value of checkbox to - ThisItem.Value in colCategoryData.Value was the part I was missing also. Thanks so much!

[@suniljogi99]

As always neatly done :)

[@RezaDorrani]

Thank you! Cheers!

[@ankushkhosla]

Hi Reza, This is nice.. Is there an option to use combobox (with multiple selection) for a field in SharePoint and save the data from the powerapps form into the sharepoint list... I am trying to use that option but getting an error.

[@RezaDorrani]

Yes. You would have to handle the default and update properties of the data card accordingly. Multi choice column schema is different. rezadorrani.com/index.php/2020/05/04/power-apps-patch-function-with-sharepoint/

[@brettgreve]

Hello - Great Video. Once checkboxes are created and working how do we go about being able to send all the information enter onsubmit to send email?

[@RezaDorrani]

The collection will have all the info you need. You can get the selected items from it and send it in email. I would have to try it out to provide the exact steps. I would recommend giving it a try and in case of issues posting your issue with screenshots on the forums at powerusers.microsoft.com

[@AmitPatel-oc8ix]

Hi Reza, Thank you. I followed the steps in your video but i have three screens New, View & edit so how do i get the checked values from the checkboxes to appear on view & edit screens.

[@RezaDorrani]

Ideally you should be using 1 screen for all form modes (best practice). You can change form mode on demand, show hide cols, etc. If you are using 3 screens you would have to repeat logic on all 3 screens. If you have tried and running into issue, then I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com

[@redbug2011]

Hi Reza, After creating the checkboxes, i want to be able to make another field visible when one or two checkboxes are selected. how do I configure the Visible on that field? Tried several ways and it is not working for me. I hope you spare some time to answer this. Thank you.

[@RezaDorrani]

You can always check the count of items in the collection for checkbox. If countrows(collection) > 1 then do something.

[@redbug2011]

@@RezaDorrani what i meant was a field is dependent depending on the checkboxes I select. Example, if I checked Item A, ItemA1 should be visible.

[@RezaDorrani]

@@redbug2011 You can check and see if collection includes that item. I dont have a specific video reference on it hence I can only guide. I would recommend checking on forums in case someone has done something similar powerusers.microsoft.com/

[@termeric]

Great video, but i am wondering if somehting changed in powerapps since this was published, i followed the instructions but cant get my check boxes to reset,

[@RezaDorrani]

Check video description

[@termeric]

@@RezaDorrani Thanks Reza, it's working now. really appreciate the response. your videos are the gold standard for learning power apps.

[@Farazkhan-xm9qn]

hello sir, what is the function to view the collection items from the record selected in the sharepoint form, for me it is showing empty!

[@RezaDorrani]

The video description has a formula that needs to be added to the default property of the checkbox. That got missed in the video.

[@AmrAlOmari]

Good evening sir Thanks a lot for your awesome videos I've watched couple of them. Regarding the Multi Select Checkbox, I have a SP list where I have durations, and when I chose a specific duration I want another column to be changed according to the choice duration, for example If I chose 1 month the column date will be 11-04-21. I successfully done it for one choice (not using patch nor collection) but if I wanted to choose 6 choices and patch it for 6 different columns how can I do it??? What I used is putting the following equation in the drop box’s item field Table( { Name: "1 Week", Days: 7 }, { Name: "2 Weeks", Days: 14 }, { Name: "1 Month", Days: 30 }, { Name: "2 Months", Days: 60 }, { Name: "3 Months", Days: 90 }, { Name: "6 Months", Days: 180 }, { Name: "9 Months", Days: 270 }, { Name: "12 Months", Days: 365 }, { Name: "24 Months", Days: 730 }, { Name: "36 Months", Days: 1095 } ) And the following formula in the Update field in the data picker DateValue2.SelectedDate + Time(Value(HourValue2.SelectedText.Value), Value(MinuteValue2.SelectedText.Value), 0) Now I don’t care showing the future date but I want when the user choses 3 periods, 3 dates will be updated in the list.

[@RezaDorrani]

I see your use case but this would not be possible to solve here in the chat. I would recommend posting your query with screenshots on the community forum at powerusers.microsoft.com

[@AmrAlOmari]

@@RezaDorrani Thanks a lot and sorry for my late replay. I've posted it couple of days ago here powerusers.microsoft.com/t5/Building-Power-Apps/Multiple-checkboxes-that-will-create-multiple-dates/m-p/869573#M276364

[@RezaDorrani]

Try posting again for more visibility. You would need to explain your issue better.

[@BoyTukaness]

HI Reza, how could i call the selected value directly from the Column instead of going thru "GalleryTask.Selected.Category"? The problem is I cannot store the value in the collection because I am only using a singular screen and SharePoint Integration Form.

[@RezaDorrani]

The code and logic for SharePoint customized list forms would be different. I would have to try out that scenario to provide the steps. I do have that video idea in my backlog. For now, I will recommend you check on the forums at powerusers.microsoft.com/

[@julireid9574]

@@RezaDorrani for the SharePoint customized list form , everything except this part works as you described in the video. It's a matter of capturing the selected items from the lookup list into the collection. I haven't figured it out yet, but am working on it, so if you come up with something......................

[@RezaDorrani]

@@julireid9574 Keep trying 👍

[@kauser7964]

@@RezaDorrani I really having issue making this formula work with single screen. I followed everything from this video but this formula is giving issue. can you please suggest what will be formula for single screen. When i go in edit mode check box is blank. Please advise. Thanks

[@RezaDorrani]

@@kauser7964 Not sure what you mean by single screen. Video shows form on single screen. Video description has a missing formula for default property of checkbox.

[@Kim-qj1vz]

Thank you for a great video! Where can I find a previous video that explains how to make a Category dropdown list so that you can choose multiple items? I'd love to watch that video too!

[@RezaDorrani]

The dropdown is coming from the form control which is connected to SharePoint list that has a multi select choice column. Check videos related to form control on my channel.

[@Kim-qj1vz]

@@RezaDorrani Thank you, I will check it out!

[@mikehubbard3178]

This is supper helpful Reza, thank you! I am having an issue clearing the collection though. When I add the "Clear(ColData)" function the data in the collection clears, but the checkboxes do not uncheck. Also, when I click on an existing record the form does not show the checkboxes that should be checked per that record, it instead shows whatever checkboxes I selected last. Any ideas on this? thanks again!

[@RezaDorrani]

Check video description for default property formula of checkbox. I missed showcasing that in video.

[@mikehubbard3178]

@@RezaDorrani Thanks Reza, that worked perfectly. One last question if I may. I am now trying to create a meeting invite that displays the Items selected by the checkbox's in the body of the meeting invite. So essentially, I have a "Submit" button on my form in which the "OnSelect" function of the button sets up the MS Teams invite. All of the functionality of the invite works but I'm getting "blank" when I try to pull the values selected within the gallery that the checkbox's are located in. The formula is "Gallery3.Selected.Value". Any advice here would be great. thanks!

[@RezaDorrani]

@@mikehubbard3178 I would have to try this out to provide any guidance. I will recommend to post your issue with screenshots on the forums at powerusers.microsoft.com/

[@mikehubbard3178]

@@RezaDorrani Thanks Reza, I went ahead and posted in the forum with screenshots.

[@mikehubbard3178]

@@RezaDorrani Finally figured it out. Within the formula where the input for the body of the MS Teams invite goes I placed a Concat function for the information in the collection that houses the items that were checked for that particular record. Now, the information shows up in the body of the invite in Outlook and Teams calendar