@Reza Dorrani is the kind of man that I wanted to meet in person and hold! His videos help me an awful lot and if i know Power apps, i owe him. I am really thankful 😍
Thanks a ton for this video! I generally prefer written tutorials, but I was unable to find this solution anywhere else. This was a huge help as I revamp our current SP forms using PowerApps!
Hi Reza, I've implemented the combo box to multi select checkbox in normal forms and data source as Sharepoint list I've done as it is you've shown I'm able to update the values from the form buy while viewing and editing the form from gallery control in my main screen I'm not able to see default selected items from the sharepoint list it's showing blank boxes instead. Could you please help me with that. Thank you.
I have not come across this and hence not sure what the cause could be. I recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
Fantastic video Reza! I have a question though. I created a form using a blank vertical gallery and connected it to my sharepoint list. However, when I click on Preview, it shows me a blank screen. There is also no option for "New" in Display mode. What am I doing wrong?
I have not come across this issue and hence not sure what is the cause for your issue. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Excellent explanation and demonstration, thank you!! I'm running into one issue after submitting the form to the SharePoint List - which works perfectly, however after submitting I want to ResetForm - the checkboxes don't clear. The related drop-down (which is hidden) clears, but the ResetForm doesn't appeara to clear the checkboxes. What am I doing wrong?
Thanks. I have not come across this issue hence not sure what you may be doing wrong. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
Hi Reza, thank you very much for all your amazing videos. I have learned so much.. I have a question. I followed along with this video and tried to implement the choice column the same way you demonstrated in my own application. The difference is that my application connected to a sharepoint library in stead of a list. When I implement the choice column on the first or second form, everything works just fine. However, when I implement the field on my third form it won't submit. Only after repeatedly changing the value it will eventually show. Do you know what might be the problem here ?
This should work both with lists and libraries. I have not come across an issue with needing multiple tries to submit hence not sure what the reason for your issue may be. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
@@RezaDorranithank you for your answer. You are right it should work both on lists and libraries. I discovered the issue is submitting the third form of my application. When I implement the field in the third form, I get the issues I mentioned earlier. When I place the same choice field in the second form it works like it should. So right now I am trying to find a way to solve that. All the settings are the same because I duplicated the screen. So I have a brand new challenge. If you have any ideas you're more then welcome. I will also try the platform. Thank you!
Very helpful video, much appreciated for your great work. I found I always learnt so much from your video. Another question - if a gallery is reading data from a different sp list (not the same source where the form gets data from), is there a way to implement this gallery?my gallery shows null when I cut-paste it into a form custom card.
Thanks so much for watching and learning from the videos. I would say it is possible. Not sure why your gallery shows null. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
@Reza Dorrani thanks for all your help. I have followed this vide and have replaced a number of combo boxes with checkbox galleries. The only problem is, when I create a new record some of the Checkboxes are still checked. any suggestions please?
I have not experienced the mentioned issue and hence not sure of the cause or fix for it. I will recommend checking or posting your issue on forums in case someone has experienced something similar community.powerplatform.com/
Once again and fantastic video though I have a question. Using the checkbox, how could you change a data card's visibility when certain checkboxes are selected. In other words, when someone choose A for example, a follow up question related to A would appear. The same for B and so on if needed. Thank you for any insight you can offer.
Idea would be to set visibility of data card based on the value existing in collection which drives the checkbox. I would have to try it out to give exact code, hence sharing the idea.
@@RezaDorrani That's what I was thinking. The sticking point for me was how to change the visibility based on a certain checkbox being selected. Thank you for any help you can offer.
Hi Reza, thank you for all the informative videos. I had a quick question, in the video above is it possible to make the check boxes responsive? I tried using your method to convert a combo box into checkboxes but when I play the app in Phone view half of the checkbox contents are cut off. For reference, the screen has a vertical container -> form -> DataCard -> Gallery -> CheckBox
Reza, This is SO helpful. Wondering if you can help me understand a specific use of checkboxes. I put a gallery in my datacard to create a list from a multiline column in SP. Next to that checkbox list, I added a text box to capture the user who checks the box. I would like to have that user saved back to my SP list. When I check the box, the name is populated, and then when I save the info, it is not retained anywhere in the SP list. I thought I might need to add a column to the SP list to hold this user info, but since that user text box is technically part of the subgallery it is already associated with the original SP column. I am at a loss of how to capture this user info in my SP list. Do you have any ideas?? Thank you in advance for any insight you can provide.
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.
This is a great video but I have a question about using the data after a users selects one or more checkboxes. I want to have other data cards that are visible only if the user checks a certain checkbox. I feel like this is easy in other scenarios but here it seems a little difficult to me.
Sine data is in collection, you could simply check if item exists in collection and accordingly show or hide. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Amazing video Reza, showing me things i did not think possible! Edit: it just started working now haha, not sure what I did Only one question: I've got a form with 5 different multiselect box sections. Ive attempted to copy your method for each additional one, but each section beyond the first does not save the selections to the multiselect column. I think its got something to do with the SharePointIntegration object. Ive simply added the code in separated via semicolon i.e. Set(varCategoryData,Blank()); Set(varCategory2Data,Blank()) ; NewForm(SharepointForm1) Am i doing this wrong? What would be your method for multiple, multiple selections?
You are most welcome! I have not come across the mentioned issue and hence not sure what the fix for your issue is. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
@Reza Dorrani Thanks for the article. I am a newbie to Powerapps and It was really helpful. I do have a question though. In my case, the dropdown control was a required field, so now I am getting the "Required field" error. How do I overcome it ? Thanks
Even if you are setting a value and you are getting error, it means your value is not saving to list and something is not configured correctly at your end. I recommend posting your issue on forums at powerusers.microsoft.com
@RezaDorrani Thanks. I was able to get that working now. There was a typo. I now have a different question. I want to provide a "Select All" checkbox which selects/unselects all the checkboxes in the gallery control. How can we achieve this ?
Hello, Thank you for the video. Question: When we have 2 checkbox columns, Are we supposed to set 2 different variables and blank them both on the SharePointIntegration properties ?
Thanks for all your information and method of presentation. I have reached out to the Power Forum Community but haven't received any feedback. Do you have any videos on how to use radio buttons and specifically how to clear when users accidently select a choice?
Great Vid! I wonder if you can also create a tutorial , where if the check box (check all) from outside the gallery grid is checked only the filtered items in the grid will be selected, because at the moment from your bulk update video, it only select all items in the grid, what if you have filters and you make filters in the grid before you select all items?
That would be a bit more complex. I have no plans for a tutorial on that. Might be a good idea to give it a try and/or check or post your query on forums at powerusers.microsoft.com
Great Video as always Reza! I have run into one issue with the multi select checkbox gallery control that I may need assistance with. When I submit a form and/or reset the form, the choice column check boxes are all selected. I want this to be blank when a user is submitting a new form. I have all my resets in the correct spots I believe, but I can't seem to figure this one out! Thanks
I have not come across this issue and hence not sure what is the cause for your issue. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Hi Reza, i am new to power apps and love your videos. I used this video to create multiple checkboxes under a gallery. Since there are 25 checkboxes and most times 20 of them will always be selected. I want to set the default that they are always "checked" and then user just unselects those that are not applicable. I am able to set the default to true, but within the sharepoint list, when user sees all items checked and has no changes and saves, it is not retaining all the values in the sharepoint list...it shows blank. How do I resolve this?
I will have to see your app in action to know the reason for your issue. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
Thank you for the video Reza. I have a sharepoint list with multiselect options. In my powerapp, I have a drop down for these options. I want to filter items in a gallery in powerapp based on the selection made in drop down. Can you please guide how to do that?
I'm making a "modern" form for a sharepoint list and am stuck. Everything you described worked perfectly with the classic form, but the checkbox option for the modern form doesn't have any "default" setting to adjust (and "text" is now "label" in modern version). For behavior all I see is "checked" and "Display mode". Without default how can I get the checkbox to show the checked choices after saving the form? Will this work with a modern form?
It wont be the same but similar technique should work. I will suggest checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com/
This was an awesome video! I do have a question though - when I save, my checkboxes act like the demo, but my field isn't populated. Now, my field (list column) is a lookup to another list to make it flexible. Could that be why?
Important is to set the value based on what your field type is. Lookup columns have a specific format. I have done some videos on Patch function and shown behavior of lookup column type. Give those a try.
@@RezaDorrani Do you have a link to said videos? This is how my form is acting - if I leave the lookup field for multi select visible and use it to select, the checkbox table is updated, but not the other way around.
Hi @Reza, thank you for your help. I got it working but one issue shows up when I uncheck one of the checkbox all the checkboxes are unchecked but the data variable for that hold the checkbox's value is not empty. Do you know why?
I have not experienced the mentioned issue and hence not sure what the cause for it could be. I will recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
Hi Reza, Thank you for this tutorial. I followd your istructions in your last segmant (multi select) but now the default for my datacard has an error "Expected Record value". also, when i publish to the SP list, if i edit an existin item or if i create a new line and select any checkbox or more than 1 checkbox, if i save the choices, the choices that i selected in the checkbox are not displaying. any thoughts?
Hi Reza! Thank you so much for this, it was extremely helpful!! I did have one question- I have a reset form button that I cannot get to reset the gallery we created or the checkboxes. I understand that you did this by setting the variable to blank within the forms onSuccess. I am using a standalone Power App so I attempted to put this into my Forms OnReset but I am still having no luck :( Thank you again.. you have saved me so many headaches!
Most welcome! I have not experienced the mentioned issue, hence not sure of what options to take. I will recommend checking or posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
@@RezaDorrani Thank you! I found a few articles there but none of them followed the exact setup we have here. I did work out a solution though for anyone else wondering: 1. Set the OnVisible of the screen to: Set(varCheckboxReset, false) 2. Then on the Reset property of the checkbox add: varCheckboxReset 3. Then on the onSelect of your reset button, add: Set(varCheckboxReset, true); Set(varCheckboxReset, false); Thank you again Reza! You are my Power Apps hero!🦸♀
Another gr8 video Reza!! But I have one question, I have 6 checkboxes. 5 has normal selection but if 6th checkbox will select then one input box will be disable or enable based on the selection. Suppose we click on 6th one ( named, other reason plz specify) then one input box will be enable and user will mention the reason and it will also save in SP list. How we can do this, please suggest me!! Thanks
I do not have a video reference on this scenario and will have to try it out to provide guidance. I recommend posting your query on forums at powerusers.microsoft.com
Hi Reza, it’s very nice video thanks for it. Have question on it how can we make some selections default or based on some conditions how can we select on edit form. Thanks
Hi Reza! Love, LOVE, L-O-V-E you! I'm still a beginner but watch your videos often enough that I can rely on them to get me out of a pickle! Was wondering if you made a tutorial, using this method of checkboxes, and sending the checkboxes selected by a user to another user via email (from the app or using Power Automate). I'm using this app to communicate which compliancy documents are missing/which ones have been recieved/which ones have been rejected, and why . any insight would be super helpful! Thank you!
Thanks so much Kalai! I do not have a video reference on sending the checkboxes information selected by the user. You have the checkbox selection information in the collection, simply use the Concat function to get data from collection as a string and then send it in email.
@@RezaDorrani maybe I didn’t ask my question correctly? How do i update the vertical gallery if I want to add a new choice value. Maybe a checkbox solution isn’t what I need. Thanks
@@golfnutt8 I still did not understand the question. The choices (be it vertical or horizontal gallery) is coming from choices function. You can drive this with your own collection as well but this is not something I have tried.
@@RezaDorrani I sorry I am not clear. If there are three choices / check boxes and my customer needs a fourth choice / check box, how can he add the new choice / checkbox? I can do this with a single select combo box. More clear now? 😆
@Reza Dorrani Hi, I am using this in a canvas app connected to a sharepoint list. I followed every detail, except for adding the "Saveform" formula to the submit button on the canvas. Unfortunately, this is only erasing the existing data in the column that I want to update with the check box. The variable correctly contains the checked items, but this is not being passed to sharepoint. Any idea of what may be going on? The result column is also a lookup column with multi select enabled, not sure if that is the problem
I have not come across this issue and hence not sure what is the cause for your issue. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Hi Reza, You create great instructional videos, very detailed and easy to follow. I used this to create checkboxes on a form and it worked brilliantly, but I was running a flow which was to extract the check box choices (for an email) but the 'for each' loop for the choice field does not loop though all checkbox items. In other words if there are 3 checkboxes selected the for each only loops twice. I selected 3 checkboxes without using the form (gridview) and it, then works and loops through all 3. The only thing I have managed to work out is that the checkboxes go in a different order using the form or in gridview.
Firstly check to see when you save the form, does it show the updates in the data source. If no, then something is not done correctly in the checkbox. I would recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
@@RezaDorrani Hi Reza, Yes it does show the form checkbox updates on the sharepoint list immediately after save. Just doesn't loop all checked values with the 'for each' loop for the choice field. I will post the issue on the forum.
Hi Reza, your videos have been a life saver! I'm trying to create a form with 50+ different checkbox questions (i.e., you'd be repeating your "Category" here 50+ more times with different values for each question). Do you have a tutorial somewhere on dealing with checkboxes for large data sets like that? It would take forever to do it one by one like the way shown here and I'm having trouble finding anything online that shows how to do this. Thanks!
Hi Reza, I am currently working on a form and encountering some issues with the look-up. I have a column for Country (which is a look-up type in SharePoint- I have a separate list for Country), and I used a combo box for it in Power Apps. The reason is that for every selection of Continent, the options for Country will be filtered based on Continent. My issue is that every time I select multiple values for Country field, it only stores the last selected value. Hoping that you could help me with this. Thank you for the informative videos, as always! :)
I have not come across this and hence not sure what is the cause for your issue. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
For the most part, this works well. I'm using it in a Canvas App (tied to a SharePoint list), not in the SharePoint custom form like in the video. However, on my "New Form", after I create an item - then leave and come back to create the next item - the form is maintaining the values checked from the last item created. Any idea why this would be.
I have not come across this issue and hence not sure what is the cause for your issue. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
@@RezaDorrani Thanks Reza. I found an article on there where the issue was resolved. Here's what I did (in case anyone needs the solution handy)... In App.OnStart, set a variable... Set(varCheckReset, false) OnVisible of the screen where the form/gallery/checkboxes reside... Set(varCheckReset, true); Set(varCheckReset, false); Checkbox.Reset property... varCheckReset Tested it out, and it works perfectly.
Hi! Thank you so much for sahring this! I ran into the same issue while replacing my dropdowns with these gallery-check boxes. The only thought i have is that when you start with a blank canvas app, you don't get the same property options as you do when you create a form using SP. Either way, Im folling your instruciton but i don't see the OnVisible property on the screen where my checkboxes are placed. i see a 'Visible', but I think they're 2 different things...can you provide a bit more detail on where the OnVisible property will be? Thank you! @@rkirk2k
Is it possible to return the time/date that the progress list was updated to the specific value? For example, it defaults to "not started", however when it get updated to progress is there a way to return that date/time? then again when it is switched to 'completed'? Thanks!
Should be possible but not something I have tried so not sure. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
Hi Reza - thanks for another great video! Question - is there a way to make a gallery with multi-choice checkboxes a required (mandatory) field? I have a DataCard in my form where I used a Gallery to create the multi-checkbox experience an that works great. However, I now need to make sure that at least one of the checkbox items is checked before the form is submitted. Can you guide me on the right direction? Many thanks!
Most welcome. In thi video, the multi select checkbox values are synced with the combo box (which is hidden). If you simply set required property for data card to true, it should work.
@@RezaDorrani Thanks for the response. I just double checked and the Required property for the Data card is selected - it seems that there is a disconnect somewhere between the data card and the gallery with the checkboxes, which is inside the data card. On the gallery I have Items set to Choices, OnSelect to false and Selectable to true. On the checkbox control, I have a collection in OnCheck/OnUncheck, OnSelect I have Select(Parent). I tried to do a CountRows for the gallery and it only shows 0 whether I have boxes checked or not. Any other ideas of how I could get this right? Appreciate your time.
@@affialho1 I would have to try this out to see what the issue is related to. One simple option would be to disable submit button until a selection is made in checkbox gallery.
@@RezaDorrani The submit button has other conditions in it referring to text from other cards in the form (Used !IfBlank, Edit, Disabled) - the only condition that doesn't work is the one for the checkboxes. I did include the data card that contains the gallery into the DisplayMode for my submit button.
Good morning my friend. I'm from Brazil and follow your teachings and tips. I would like to know how to record these checkbox options in SharePoint in the card order, not in the user selection order. Can you guide me?
Hi Reza - thank you for the video. I have the checkboxes as a lookup instead of choice column for Dataverse table. I tried to fit the checkboxes in a gallery and inside a DataCard, but not able to make the check box visible if the data source is Dataverse, but if the data source is SharePoint. the checkboxes gallery inside the data card is visible. Is there a way we can put the gallery inside a DataCard if the data source is Dataverse and the field is a lookup field? which means form and gallery inside a DataCard comes from different data source. I frequently got request for adding gallery (data source comes from a different table as the main form) inside the middle of the form, like to know if this is possible. Thank you!
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.
Reza, is is possible to set a default on the Radio control (Yes/No)? I noticed that after the change i.e., defaulting the Radio control to No, when I opened an existing item it changed to No while it was previously Yes.
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.
@reza Dorrani, 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
I admit that Power Apps is not my strong suite. Your tutorial was perfect, and it worked perfectly. Question for you, I have a 3 item choice, how can I check if the second checkbox is checked in a formula on another field to control its visibility. I want to basically put in logic that says IsMatch(Gallery1.Selected.Value,"Cut Shop") and if the item called Cut Shop is selected, then it will show this field, otherwise it will hide the field. The above syntax works only if the "Cut Shop" is the last thing checked. It should be something simple, but I can't figure it out. I tried Search(varCategoryData, "Cut Shop", "Value") but got a syntax error.
If using same collection technique in video. You can check if “Cut Shop” in collection. I will have to try it out to provide exact steps. Give it a try and in case of issues try posting or checking on forums at powerusers.microsoft.com
@@RezaDorrani I created a text field, and used this syntax, and it sort of worked: LookUp(varCategoryData,Value="Cut Shop", true). It returns True if the value is found, and false if not. But the only problem is that it when I edit the item, I guess the varCategoryData field is blank from the OnEdit action. How do I pre-load the varCategoryData table, or am I doing this all wrong?
@@peterbennett7983 Its difficult to direct here on chat. I will have to reproduce your scenario to provide guidance. I will recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
Thank you for the video. It is very helpful. But, one thing I wonder, at my Sharepoint page, when I click "New" and then existing value selected item keep showing but if I refreash page(F5 button) and then it works properly. Would you advise?
@@RezaDorrani I have the exact same issue. I followed the video and even deleted and setup again. When edit and click "New" in sharepoint i see the selections made in edit. but if refresh page then the checkboxes are clear
@@tonyacosta1827 I cannot guess the fix without reproducing the issue. Il recommend posting issue with screenshots on the forums at powerusers.microsoft.com
This is exactly what I was looking for with a clear and step-by-step instructions. Superp job again Reza. However, I have two requirements with multi-select. 1) is to add a free text box for each corresponding choice for users to insert specific folder locations for example for data storage location I have local vs network drives and then what folder are data stores Drive Letter Specific Folder (Free Text) C: \Project1\data D: \Project1\data L: \Project1\data The second requirement is to add the "Others - Please Specify" option to multi-select and when this option is selected, then users are presented with a free text box to input what they desire. Last, how to capture the free text in both scenarios in the SharePoint list that corresponds to the choices? Thank you
I would have to try both your requirements to know how it can be done. I recommend checking on forums in case someone has done something similar powerusers.microsoft.com
@@RezaDorrani Thank you. I have already checked both the Forums and UA-cam and couldn't find the exact match. Maybe the wording of my search didn't produce results. The other option that I am going to try now is to ask ChatGPT. In fact, ChatGPT gave me the right clue on how to do Nested Tabbed Form where my post on Forums still has no response. Thank you again.
For a single card it works just fine, but I've tried to do the same thing for multiple cards however when I submit the form the columns that are multi select are blank on a sharepoint list. Not sure what to do here as for each one I've changed the names of the values e.g. the first the checkbox was called Checkbox2, so for the next card its Checkbox2_1 and each name is used correctly in the their respective formulas e.g. Set(varCategoryData1, ShowColumns( Filter(Gallery1_1.AllItems,Checkbox2_1.Value), "Value")) . Any help appreciated :)
I will have to look at your App in action to know the cause of your issue. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
I have not experienced the mentioned issue and hence not sure what the cause for it could be. I will recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
Hi, thans for the video. A question, I am trying to replicate the category field but this is a text field. I have inserted a combobox and a checkbox into this field to be able to do it. I only have one error when editing the record, the checkbox only returns the first element by default when this record contains more than one. Do you think you can help me solve it?
I would have to try your scenario or reproduce your issue to provide guidance. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
@@jonathanfernandezferrer3470 If I have a video reference for it, I would have pointed you to it. I am working on multiple new videos. I would recommend posting your query on forums.
Thank you Reza! It is really helpful. For the multi-select checkbox, my issue is the checkbox selections are still pre-selected on the new form, which looks like a cache. I added "Set(varScheDays,Blank());" statement on OnSuccess property, but it doesn't work. My app doesn't have "SharePointIntergration" menu on the left, so I couldn't add the statement there. Is it because of it??
This video is specific to SharePoint customized list forms. For standalone apps, check ua-cam.com/video/xUep4uud1BE/v-deo.html and plz check video description of this video.
@@RezaDorrani Yeah I followed that video first, but for some reason, it didn't work out and I had the same cache issue (i.e. the collection was cleared but the multiselect checkbox still showed the previous selection. This video works except the cache issue. any idea? I put "Set(varScheDays,Blank())" on OnVisible property too but the same.
Reza - thank you, very well done and informative! Is there any way for a work item to be an Excel file rather than just a name? I would love a way to track the progress of a file being completed and who is currently working on it. Thank you!!!
Excellent video. I have tried to implement this solution. It works fine. But the only problem is with Caching of the checkbox selections. I have tried to reset the variables as mentioned in the video. Unfortunately, none of them works. If I try to create a second item soon after creating an item, the previous selections are retained. Does any one know how to resolve this Greatly appreciate this.
I have not come across this issue & hence not sure what the resolution is. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Hi Reza! I've been trying to create a flow that would update the SLA priority automatically based on the date the Item was created but without sucess, any ideas for that?
Depends on what your backend data source is, what type of column is storing sla, etc. etc. I will have to look at your flow in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
@Reza Dorrani, Video was very informative but after updating all I am getting the error on datacastvalue1.update property when i am writing this formula.Coalesce(varRecurr,ThisItem.recurringexclusions). It is giving me error as "this formula uses scope which is not currently supported for evaluation ( datatype as table). Also when i am updating value from sharepoint list this column is not getting updated. Request you help on urgent
I have not experienced the mentioned issue and hence not sure what the cause for it could be. I will recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
Hello Reza, Do you have any videos where we can create multiselect cascading dropdown options for ex if I select Manufacturer Model should filter out based on manufacturer but we should be able to select multiple Manufacturer and Models
Hi Reza, I have one additional condition, if a user check a checkbox a dropdown should visible, user will select a value from dropdown and then submit the form, the selected value should also submitted to the data source that is sharepoint list. pls help
Hi Reza, thanks for this and all of your other recordings but I was wondering if you had a recorded solution to manage the Likert response from Microsoft Form(excel) to be updated into the Sharepoint List, using Power Automate. With my novice knowledge, I believe the method would be to use 'parse json' but I am happy to be corrected but the result is to use the Form to update a Sharepoint List that will then use to update an onboarding app and I would be grateful if you could provide me with some advice.
@@RezaDorrani Hi, I tried doing that, I set the data card as true, but when i submit the form, it doesn't highlight it as mandatory field like it does for other fields which are either text or choice column. i think is it because i created this field in the form itself and not in the SharePoint list? Do you know if i can make a checkbox field in the SharePoint list itself? Thanks for your response in advance.
@@priyankanirmal286 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
Thank you so much shareing that. But, I cannot reset checkbox. When I submit, all is perfect, but if I create a new item, all checkboxes previously check are still checked. I set my variable blank, but seems to do not have effect. When I validate my variable, table is empty... but checkboxes no :( What I did wrong ? thank-you
I will have to look at your App in action to know the cause of your issue. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Reza, I've set visibility of a field based on whether boxes in the gallery are checked. Works fine, unless I uncheck a box that was previously checked. Any idea how to fix the issue?
I followed the steps on this video and tried creating multi select checkboxes using gallery in Power Apps but I am always having an error with the data card's default and update. It says, expecting record value. Do you have any idea how to fix this? Thank you. :)
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
The gallery border doesn’t turns red when the field is required, I added same formula from the Dropbox If(isblank(parent.error), parent.bordercolor, color.red) but gallery border color doesn’t change to red, any idea?
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
You would probably need to add a button or some control for user to select which would trigger selection of all. On click of button, collect all items in collection. (I guess collection would be same as items property). And when user selects button to remove all selections, use clear function to clear the collection.
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.
If you follow steps in video, it should save multiple. I will have to look at your app in action to know why. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
Hello Reza, Usefull as always! Will you provide some comprehensive course on PowerApps soon? I'm afraid the tool changes so quickly and so fast that any course is being outdated within few months
When trying to assign the function to the checkbox I get the following :( set(variable,value) = this formula has side effects and cannot be evaluated, why is that?
I need help with a formula: I have radio buttons, "Yes" and "No" and a somewhat dependent coinciding date field. I'm needing instructions on if the "yes" radio button is chosen, the date in the date field must be "before today", if "No" radio button is chosen, the date in the date field must be "after today".
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.
I also have a date field on my power apps form that is showing the date & time. I've tried to update to only the date in the mm/dd/yyyy format, but the format doesn't change and I can't get rid of the time stamp.
@Reza Dorrani is the kind of man that I wanted to meet in person and hold! His videos help me an awful lot and if i know Power apps, i owe him. I am really thankful 😍
Virtual 🤗
me too
A few months ago, i started a career in SP and Power apps, i enjoyed your video, it completely guides me. Thank you so much.
You’re most welcome
Thanks a ton for this video! I generally prefer written tutorials, but I was unable to find this solution anywhere else. This was a huge help as I revamp our current SP forms using PowerApps!
Most welcome!
Videos are better 😉
Thank you, Reza. Your videos are a starting point when I need some Power Apps functionality
Glad to hear that!
Hi Reza,
I've implemented the combo box to multi select checkbox in normal forms and data source as Sharepoint list I've done as it is you've shown I'm able to update the values from the form buy while viewing and editing the form from gallery control in my main screen I'm not able to see default selected items from the sharepoint list it's showing blank boxes instead.
Could you please help me with that.
Thank you.
I have not come across this and hence not sure what the cause could be.
I recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
Awesome! It worked perfectly for me. Now I have more clarity on the checkbox part. Thanks, Reza 👌👌
Happy to hear that! Thanks so much for watching
Very good, I used this logic to update a single line text field with multiple items from a separate list and it works like a charm
Thanks for watching
Did you use the values from another list with the "look up" column type? I am trying to do that now
This video is what I have been looking for. Keep sharing. You are awesome!
Thank You
Fantastic video Reza! I have a question though. I created a form using a blank vertical gallery and connected it to my sharepoint list. However, when I click on Preview, it shows me a blank screen. There is also no option for "New" in Display mode. What am I doing wrong?
I have not come across this issue and hence not sure what is the cause for your issue. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Excellent explanation and demonstration, thank you!! I'm running into one issue after submitting the form to the SharePoint List - which works perfectly, however after submitting I want to ResetForm - the checkboxes don't clear. The related drop-down (which is hidden) clears, but the ResetForm doesn't appeara to clear the checkboxes. What am I doing wrong?
Thanks.
I have not come across this issue hence not sure what you may be doing wrong.
I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
Hi Reza, thank you very much for all your amazing videos. I have learned so much..
I have a question. I followed along with this video and tried to implement the choice column the same way you demonstrated in my own application. The difference is that my application connected to a sharepoint library in stead of a list. When I implement the choice column on the first or second form, everything works just fine. However, when I implement the field on my third form it won't submit. Only after repeatedly changing the value it will eventually show.
Do you know what might be the problem here ?
This should work both with lists and libraries.
I have not come across an issue with needing multiple tries to submit hence not sure what the reason for your issue may be.
I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
@@RezaDorranithank you for your answer. You are right it should work both on lists and libraries. I discovered the issue is submitting the third form of my application. When I implement the field in the third form, I get the issues I mentioned earlier. When I place the same choice field in the second form it works like it should. So right now I am trying to find a way to solve that. All the settings are the same because I duplicated the screen. So I have a brand new challenge.
If you have any ideas you're more then welcome. I will also try the platform. Thank you!
@@ericvanderknaap835 I do not have any ideas as I would have to reproduce the issue to know the reason behind it.
Very helpful video, much appreciated for your great work. I found I always learnt so much from your video. Another question - if a gallery is reading data from a different sp list (not the same source where the form gets data from), is there a way to implement this gallery?my gallery shows null when I cut-paste it into a form custom card.
Thanks so much for watching and learning from the videos.
I would say it is possible. Not sure why your gallery shows null.
I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
@Reza Dorrani thanks for all your help. I have followed this vide and have replaced a number of combo boxes with checkbox galleries. The only problem is, when I create a new record some of the Checkboxes are still checked. any suggestions please?
I have not experienced the mentioned issue and hence not sure of the cause or fix for it.
I will recommend checking or posting your issue on forums in case someone has experienced something similar
community.powerplatform.com/
Great work 👏 👍
Lovely logic around Multiple Checkbox.3
I have now added this into my "Useful UI" component 😁😁😁
Glad it was helpful!
Once again and fantastic video though I have a question. Using the checkbox, how could you change a data card's visibility when certain checkboxes are selected. In other words, when someone choose A for example, a follow up question related to A would appear. The same for B and so on if needed.
Thank you for any insight you can offer.
Idea would be to set visibility of data card based on the value existing in collection which drives the checkbox. I would have to try it out to give exact code, hence sharing the idea.
@@RezaDorrani That's what I was thinking. The sticking point for me was how to change the visibility based on a certain checkbox being selected.
Thank you for any help you can offer.
Hi Reza, thank you for all the informative videos. I had a quick question, in the video above is it possible to make the check boxes responsive? I tried using your method to convert a combo box into checkboxes but when I play the app in Phone view half of the checkbox contents are cut off. For reference, the screen has a vertical container -> form -> DataCard -> Gallery -> CheckBox
Welcome!
Possible is my guess but not something I have tried.
Ahh, thank you for the prompt response. I will dig in a little bit and see what I can find.@@RezaDorrani
Thank you Reza. Can this also work in a filter pane where there is no DataCard?
Should work
Reza, This is SO helpful.
Wondering if you can help me understand a specific use of checkboxes. I put a gallery in my datacard to create a list from a multiline column in SP. Next to that checkbox list, I added a text box to capture the user who checks the box. I would like to have that user saved back to my SP list. When I check the box, the name is populated, and then when I save the info, it is not retained anywhere in the SP list. I thought I might need to add a column to the SP list to hold this user info, but since that user text box is technically part of the subgallery it is already associated with the original SP column. I am at a loss of how to capture this user info in my SP list. Do you have any ideas?? Thank you in advance for any insight you can provide.
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.
This is a great video but I have a question about using the data after a users selects one or more checkboxes. I want to have other data cards that are visible only if the user checks a certain checkbox. I feel like this is easy in other scenarios but here it seems a little difficult to me.
Sine data is in collection, you could simply check if item exists in collection and accordingly show or hide. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
this is great!!!! so appreciate all your videos.
Thanks Jaime
Very cool video AGAIN Reza !!!
Thanks Vincente
Amazing video Reza, showing me things i did not think possible!
Edit: it just started working now haha, not sure what I did
Only one question: I've got a form with 5 different multiselect box sections. Ive attempted to copy your method for each additional one, but each section beyond the first does not save the selections to the multiselect column.
I think its got something to do with the SharePointIntegration object.
Ive simply added the code in separated via semicolon i.e.
Set(varCategoryData,Blank()); Set(varCategory2Data,Blank()) ;
NewForm(SharepointForm1)
Am i doing this wrong? What would be your method for multiple, multiple selections?
You are most welcome!
I have not come across the mentioned issue and hence not sure what the fix for your issue is. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
@Reza Dorrani Thanks for the article. I am a newbie to Powerapps and It was really helpful. I do have a question though. In my case, the dropdown control was a required field, so now I am getting the "Required field" error. How do I overcome it ? Thanks
Even if you are setting a value and you are getting error, it means your value is not saving to list and something is not configured correctly at your end.
I recommend posting your issue on forums at powerusers.microsoft.com
@RezaDorrani Thanks. I was able to get that working now. There was a typo. I now have a different question. I want to provide a "Select All" checkbox which selects/unselects all the checkboxes in the gallery control. How can we achieve this ?
@@susheil76 I would have to try it out to give the steps :)
glad I came across this video! trying it now!
👍
Another great video. Thanks Reza!!!
Glad you enjoyed it!
Hello, Thank you for the video.
Question: When we have 2 checkbox columns, Are we supposed to set 2 different variables and blank them both on the SharePointIntegration properties ?
As per technique shown in video, Yes
Thanks for all your information and method of presentation. I have reached out to the Power Forum Community but haven't received any feedback. Do you have any videos on how to use radio buttons and specifically how to clear when users accidently select a choice?
Most welcome!
I'm not sure if I have a video on that.
Perfect timing!!! Thanks you the best man.
Thanks Andy
Great Vid! I wonder if you can also create a tutorial , where if the check box (check all) from outside the gallery grid is checked only the filtered items in the grid will be selected, because at the moment from your bulk update video, it only select all items in the grid, what if you have filters and you make filters in the grid before you select all items?
That would be a bit more complex. I have no plans for a tutorial on that. Might be a good idea to give it a try and/or check or post your query on forums at powerusers.microsoft.com
Great Video as always Reza! I have run into one issue with the multi select checkbox gallery control that I may need assistance with. When I submit a form and/or reset the form, the choice column check boxes are all selected. I want this to be blank when a user is submitting a new form. I have all my resets in the correct spots I believe, but I can't seem to figure this one out! Thanks
I have not come across this issue and hence not sure what is the cause for your issue. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Hi Reza, i am new to power apps and love your videos. I used this video to create multiple checkboxes under a gallery. Since there are 25 checkboxes and most times 20 of them will always be selected. I want to set the default that they are always "checked" and then user just unselects those that are not applicable. I am able to set the default to true, but within the sharepoint list, when user sees all items checked and has no changes and saves, it is not retaining all the values in the sharepoint list...it shows blank. How do I resolve this?
I will have to see your app in action to know the reason for your issue. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
@@RezaDorrani thank you. I will do that now
Thank you for the video Reza. I have a sharepoint list with multiselect options. In my powerapp, I have a drop down for these options. I want to filter items in a gallery in powerapp based on the selection made in drop down. Can you please guide how to do that?
I have done many videos on gallery filtering. I would recommend checking those.
I'm making a "modern" form for a sharepoint list and am stuck. Everything you described worked perfectly with the classic form, but the checkbox option for the modern form doesn't have any "default" setting to adjust (and "text" is now "label" in modern version). For behavior all I see is "checked" and "Display mode". Without default how can I get the checkbox to show the checked choices after saving the form? Will this work with a modern form?
It wont be the same but similar technique should work. I will suggest checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com/
This was an awesome video! I do have a question though - when I save, my checkboxes act like the demo, but my field isn't populated. Now, my field (list column) is a lookup to another list to make it flexible. Could that be why?
Important is to set the value based on what your field type is. Lookup columns have a specific format.
I have done some videos on Patch function and shown behavior of lookup column type. Give those a try.
@@RezaDorrani Do you have a link to said videos? This is how my form is acting - if I leave the lookup field for multi select visible and use it to select, the checkbox table is updated, but not the other way around.
@@ChrissyWhitby Search for videos on Patch function in power apps
This is outstanding! Thanks for creating.
You’re most welcome
Awesome content! You have helped me so much with my own Power App tasks.
Great to hear!
Hi @Reza, thank you for your help. I got it working but one issue shows up when I uncheck one of the checkbox all the checkboxes are unchecked but the data variable for that hold the checkbox's value is not empty. Do you know why?
I have not experienced the mentioned issue and hence not sure what the cause for it could be.
I will recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
Hi Reza, Thank you for this tutorial. I followd your istructions in your last segmant (multi select) but now the default for my datacard has an error "Expected Record value". also, when i publish to the SP list, if i edit an existin item or if i create a new line and select any checkbox or more than 1 checkbox, if i save the choices, the choices that i selected in the checkbox are not displaying. any thoughts?
My guess is your column is not of type choice MULTI SELECT. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
@@RezaDorrani thank you
Hi Reza! Thank you so much for this, it was extremely helpful!!
I did have one question- I have a reset form button that I cannot get to reset the gallery we created or the checkboxes. I understand that you did this by setting the variable to blank within the forms onSuccess. I am using a standalone Power App so I attempted to put this into my Forms OnReset but I am still having no luck :(
Thank you again.. you have saved me so many headaches!
Most welcome!
I have not experienced the mentioned issue, hence not sure of what options to take.
I will recommend checking or posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
@@RezaDorrani Thank you! I found a few articles there but none of them followed the exact setup we have here. I did work out a solution though for anyone else wondering:
1. Set the OnVisible of the screen to: Set(varCheckboxReset, false)
2. Then on the Reset property of the checkbox add: varCheckboxReset
3. Then on the onSelect of your reset button, add:
Set(varCheckboxReset, true);
Set(varCheckboxReset, false);
Thank you again Reza! You are my Power Apps hero!🦸♀
@@Jas-p3i Thank You so much for sharing. It would surely help others.
Thank you for your contributions, these videos are very helpful!
You're very welcome!
Thank you so much Reza for another awesome content
Most welcome
Very elegant - cheers Reza! 👌
Thanks Craig
Another gr8 video Reza!! But I have one question, I have 6 checkboxes. 5 has normal selection but if 6th checkbox will select then one input box will be disable or enable based on the selection. Suppose we click on 6th one ( named, other reason plz specify) then one input box will be enable and user will mention the reason and it will also save in SP list. How we can do this, please suggest me!! Thanks
I do not have a video reference on this scenario and will have to try it out to provide guidance. I recommend posting your query on forums at powerusers.microsoft.com
Hi Reza, it’s very nice video thanks for it. Have question on it how can we make some selections default or based on some conditions how can we select on edit form. Thanks
Idea would be to load data in that collection that the checkbox uses. I do not have a specific video reference on this - hence providing the idea.
@@RezaDorrani Thanks for the idea, i am new to the power apps. if possible can you share any reference link it will be grateful.
@@lakshminarasimhulu8710 I do not have any reference links for this. Try checking or posting your query on forums at powerusers.microsoft.com/
Thanks @@RezaDorrani
Hi Reza! Love, LOVE, L-O-V-E you! I'm still a beginner but watch your videos often enough that I can rely on them to get me out of a pickle! Was wondering if you made a tutorial, using this method of checkboxes, and sending the checkboxes selected by a user to another user via email (from the app or using Power Automate). I'm using this app to communicate which compliancy documents are missing/which ones have been recieved/which ones have been rejected, and why . any insight would be super helpful! Thank you!
Thanks so much Kalai!
I do not have a video reference on sending the checkboxes information selected by the user.
You have the checkbox selection information in the collection, simply use the Concat function to get data from collection as a string and then send it in email.
This is Awesome Reza. Is it possible to add an item dynamically to a category so that the checkboxes change or is this more static choices?
The choices are being loaded from choices function. Choices picks choice values from
Choice column in SP. If you think of it, it is dynamic.
@@RezaDorrani maybe I didn’t ask my question correctly? How do i update the vertical gallery if I want to add a new choice value. Maybe a checkbox solution isn’t what I need. Thanks
@@golfnutt8 I still did not understand the question. The choices (be it vertical or horizontal gallery) is coming from choices function. You can drive this with your own collection as well but this is not something I have tried.
@@RezaDorrani I sorry I am not clear. If there are three choices / check boxes and my customer needs a fourth choice / check box, how can he add the new choice / checkbox? I can do this with a single select combo box.
More clear now? 😆
@@golfnutt8 Still not. I recommend posting your query on forums.
@Reza Dorrani
Hi, I am using this in a canvas app connected to a sharepoint list. I followed every detail, except for adding the "Saveform" formula to the submit button on the canvas. Unfortunately, this is only erasing the existing data in the column that I want to update with the check box. The variable correctly contains the checked items, but this is not being passed to sharepoint. Any idea of what may be going on? The result column is also a lookup column with multi select enabled, not sure if that is the problem
I have not come across this issue and hence not sure what is the cause for your issue. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Hello Reza! I was wondering if there is a video of this using modern controls?
I have done so many videos that I myself dont remember. My guess is No.
@RezaDorrani ok thank you. And that jnyou for everything you do
Hi Reza, You create great instructional videos, very detailed and easy to follow. I used this to create checkboxes on a form and it worked brilliantly, but I was running a flow which was to extract the check box choices (for an email) but the 'for each' loop for the choice field does not loop though all checkbox items. In other words if there are 3 checkboxes selected the for each only loops twice. I selected 3 checkboxes without using the form (gridview) and it, then works and loops through all 3. The only thing I have managed to work out is that the checkboxes go in a different order using the form or in gridview.
Firstly check to see when you save the form, does it show the updates in the data source. If no, then something is not done correctly in the checkbox. I would recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
@@RezaDorrani Hi Reza, Yes it does show the form checkbox updates on the sharepoint list immediately after save. Just doesn't loop all checked values with the 'for each' loop for the choice field. I will post the issue on the forum.
@@mattkidd8428 did you find a solution to your looping issue? If yes, will you please share the link to your post?
@@mattkidd8428 Hi Matt, have u tried using counter for the same?, is it resolved?
Hi Reza, your videos have been a life saver! I'm trying to create a form with 50+ different checkbox questions (i.e., you'd be repeating your "Category" here 50+ more times with different values for each question). Do you have a tutorial somewhere on dealing with checkboxes for large data sets like that? It would take forever to do it one by one like the way shown here and I'm having trouble finding anything online that shows how to do this. Thanks!
I dont have a video for a scenario with large schema (not large data sets)
Always love your video Thank you so much
Thank You 😊
Hi Reza, I am currently working on a form and encountering some issues with the look-up. I have a column for Country (which is a look-up type in SharePoint- I have a separate list for Country), and I used a combo box for it in Power Apps. The reason is that for every selection of Continent, the options for Country will be filtered based on Continent. My issue is that every time I select multiple values for Country field, it only stores the last selected value.
Hoping that you could help me with this. Thank you for the informative videos, as always! :)
I have not come across this and hence not sure what is the cause for your issue. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
For the most part, this works well. I'm using it in a Canvas App (tied to a SharePoint list), not in the SharePoint custom form like in the video.
However, on my "New Form", after I create an item - then leave and come back to create the next item - the form is maintaining the values checked from the last item created. Any idea why this would be.
I have not come across this issue and hence not sure what is the cause for your issue. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
@@RezaDorrani Thanks Reza. I found an article on there where the issue was resolved. Here's what I did (in case anyone needs the solution handy)...
In App.OnStart, set a variable...
Set(varCheckReset, false)
OnVisible of the screen where the form/gallery/checkboxes reside...
Set(varCheckReset, true); Set(varCheckReset, false);
Checkbox.Reset property...
varCheckReset
Tested it out, and it works perfectly.
@@rkirk2k OMG BLESS YOU!
Hi! Thank you so much for sahring this! I ran into the same issue while replacing my dropdowns with these gallery-check boxes. The only thought i have is that when you start with a blank canvas app, you don't get the same property options as you do when you create a form using SP. Either way, Im folling your instruciton but i don't see the OnVisible property on the screen where my checkboxes are placed. i see a 'Visible', but I think they're 2 different things...can you provide a bit more detail on where the OnVisible property will be? Thank you! @@rkirk2k
Awesome!!
Is it possible to return the time/date that the progress list was updated to the specific value? For example, it defaults to "not started", however when it get updated to progress is there a way to return that date/time? then again when it is switched to 'completed'? Thanks!
Should be possible but not something I have tried so not sure. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
Great instructions. Thank you so much 🙏
You are so welcome!
Hi Reza - thanks for another great video! Question - is there a way to make a gallery with multi-choice checkboxes a required (mandatory) field? I have a DataCard in my form where I used a Gallery to create the multi-checkbox experience an that works great. However, I now need to make sure that at least one of the checkbox items is checked before the form is submitted. Can you guide me on the right direction? Many thanks!
Most welcome.
In thi video, the multi select checkbox values are synced with the combo box (which is hidden). If you simply set required property for data card to true, it should work.
@@RezaDorrani Thanks for the response. I just double checked and the Required property for the Data card is selected - it seems that there is a disconnect somewhere between the data card and the gallery with the checkboxes, which is inside the data card. On the gallery I have Items set to Choices, OnSelect to false and Selectable to true. On the checkbox control, I have a collection in OnCheck/OnUncheck, OnSelect I have Select(Parent). I tried to do a CountRows for the gallery and it only shows 0 whether I have boxes checked or not.
Any other ideas of how I could get this right? Appreciate your time.
@@affialho1 I would have to try this out to see what the issue is related to. One simple option would be to disable submit button until a selection is made in checkbox gallery.
@@RezaDorrani The submit button has other conditions in it referring to text from other cards in the form (Used !IfBlank, Edit, Disabled) - the only condition that doesn't work is the one for the checkboxes. I did include the data card that contains the gallery into the DisplayMode for my submit button.
@@affialho1 I would recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
Awesome and informative
Thanks
Good morning my friend. I'm from Brazil and follow your teachings and tips. I would like to know how to record these checkbox options in SharePoint in the card order, not in the user selection order. Can you guide me?
I’m not sure how to do that. Not something I have tried or have a video reference for.
Hi Reza - thank you for the video. I have the checkboxes as a lookup instead of choice column for Dataverse table. I tried to fit the checkboxes in a gallery and inside a DataCard, but not able to make the check box visible if the data source is Dataverse, but if the data source is SharePoint. the checkboxes gallery inside the data card is visible. Is there a way we can put the gallery inside a DataCard if the data source is Dataverse and the field is a lookup field? which means form and gallery inside a DataCard comes from different data source. I frequently got request for adding gallery (data source comes from a different table as the main form) inside the middle of the form, like to know if this is possible. Thank you!
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.
Reza, is is possible to set a default on the Radio control (Yes/No)? I noticed that after the change i.e., defaulting the Radio control to No, when I opened an existing item it changed to No while it was previously Yes.
Should be possible! not sure why it changes back. I would recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
Awesome Video, Reza! How to add a new choice that is not in the existing choice list in Power Apps?
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.
Thank you, Reza!@@RezaDorrani
@reza Dorrani, 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
Better use a radio control
@@RezaDorrani Okay, Thank you for your suggestion 🙂
I admit that Power Apps is not my strong suite. Your tutorial was perfect, and it worked perfectly. Question for you, I have a 3 item choice, how can I check if the second checkbox is checked in a formula on another field to control its visibility.
I want to basically put in logic that says IsMatch(Gallery1.Selected.Value,"Cut Shop") and if the item called Cut Shop is selected, then it will show this field, otherwise it will hide the field.
The above syntax works only if the "Cut Shop" is the last thing checked.
It should be something simple, but I can't figure it out. I tried Search(varCategoryData, "Cut Shop", "Value") but got a syntax error.
If using same collection technique in video.
You can check if “Cut Shop” in collection.
I will have to try it out to provide exact steps.
Give it a try and in case of issues try posting or checking on forums at powerusers.microsoft.com
@@RezaDorrani I created a text field, and used this syntax, and it sort of worked: LookUp(varCategoryData,Value="Cut Shop", true). It returns True if the value is found, and false if not. But the only problem is that it when I edit the item, I guess the varCategoryData field is blank from the OnEdit action. How do I pre-load the varCategoryData table, or am I doing this all wrong?
@@peterbennett7983 Its difficult to direct here on chat. I will have to reproduce your scenario to provide guidance. I will recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
@@RezaDorrani OK, I will do that. Thank you very much for your guidance!
Thank you for the video. It is very helpful. But, one thing I wonder, at my Sharepoint page, when I click "New" and then existing value selected item keep showing but if I refreash page(F5 button) and then it works properly. Would you advise?
I have not come across this issue hence not sure.
@@RezaDorrani I have the exact same issue. I followed the video and even deleted and setup again. When edit and click "New" in sharepoint i see the selections made in edit. but if refresh page then the checkboxes are clear
@@tonyacosta1827 I cannot guess the fix without reproducing the issue.
Il recommend posting issue with screenshots on the forums at powerusers.microsoft.com
This is exactly what I was looking for with a clear and step-by-step instructions. Superp job again Reza. However, I have two requirements with multi-select. 1) is to add a free text box for each corresponding choice for users to insert specific folder locations for example for data storage location I have local vs network drives and then what folder are data stores
Drive Letter Specific Folder (Free Text)
C: \Project1\data
D: \Project1\data
L: \Project1\data
The second requirement is to add the "Others - Please Specify" option to multi-select and when this option is selected, then users are presented with a free text box to input what they desire. Last, how to capture the free text in both scenarios in the SharePoint list that corresponds to the choices?
Thank you
I would have to try both your requirements to know how it can be done. I recommend checking on forums in case someone has done something similar powerusers.microsoft.com
@@RezaDorrani Thank you. I have already checked both the Forums and UA-cam and couldn't find the exact match. Maybe the wording of my search didn't produce results. The other option that I am going to try now is to ask ChatGPT. In fact, ChatGPT gave me the right clue on how to do Nested Tabbed Form where my post on Forums still has no response. Thank you again.
@@GorgyJan Keep trying with forums and chatgpt.
So helpful! Thank you.
You are so welcome!
For a single card it works just fine, but I've tried to do the same thing for multiple cards however when I submit the form the columns that are multi select are blank on a sharepoint list. Not sure what to do here as for each one I've changed the names of the values e.g. the first the checkbox was called Checkbox2, so for the next card its Checkbox2_1 and each name is used correctly in the their respective formulas e.g. Set(varCategoryData1, ShowColumns( Filter(Gallery1_1.AllItems,Checkbox2_1.Value), "Value")) . Any help appreciated :)
I will have to look at your App in action to know the cause of your issue. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
@Reza Dorrani, I am able to setup this but when editing from sharepoint ,after saving it is not getting updated on sharepoint list. Any help here pls
I have not experienced the mentioned issue and hence not sure what the cause for it could be.
I will recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
Hi, thans for the video. A question, I am trying to replicate the category field but this is a text field. I have inserted a combobox and a checkbox into this field to be able to do it. I only have one error when editing the record, the checkbox only returns the first element by default when this record contains more than one. Do you think you can help me solve it?
I would have to try your scenario or reproduce your issue to provide guidance. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
@@RezaDorrani How could I give you access to the scenario so that you can visualize the problem?
@@jonathanfernandezferrer3470 If I have a video reference for it, I would have pointed you to it. I am working on multiple new videos. I would recommend posting your query on forums.
Great video..🙏👍
Thank you! Cheers!
Thank you Reza! It is really helpful. For the multi-select checkbox, my issue is the checkbox selections are still pre-selected on the new form, which looks like a cache. I added "Set(varScheDays,Blank());" statement on OnSuccess property, but it doesn't work. My app doesn't have "SharePointIntergration" menu on the left, so I couldn't add the statement there. Is it because of it??
This video is specific to SharePoint customized list forms.
For standalone apps, check ua-cam.com/video/xUep4uud1BE/v-deo.html and plz check video description of this video.
@@RezaDorrani Yeah I followed that video first, but for some reason, it didn't work out and I had the same cache issue (i.e. the collection was cleared but the multiselect checkbox still showed the previous selection. This video works except the cache issue. any idea? I put "Set(varScheDays,Blank())" on OnVisible property too but the same.
Excellent! I'm currently working on something like this. This helps me big time. Thank you.🙏
Glad it was helpful!
Reza - thank you, very well done and informative! Is there any way for a work item to be an Excel file rather than just a name? I would love a way to track the progress of a file being completed and who is currently working on it. Thank you!!!
Power Apps can connect to a document library as well which contain your excel files
Excellent video. I have tried to implement this solution. It works fine. But the only problem is with Caching of the checkbox selections. I have tried to reset the variables as mentioned in the video. Unfortunately, none of them works. If I try to create a second item soon after creating an item, the previous selections are retained. Does any one know how to resolve this Greatly appreciate this.
I have not come across this issue & hence not sure what the resolution is. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Hi Reza! I've been trying to create a flow that would update the SLA priority automatically based on the date the Item was created but without sucess, any ideas for that?
Depends on what your backend data source is, what type of column is storing sla, etc. etc.
I will have to look at your flow in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
@Reza Dorrani, Video was very informative but after updating all I am getting the error on datacastvalue1.update property when i am writing this formula.Coalesce(varRecurr,ThisItem.recurringexclusions).
It is giving me error as "this formula uses scope which is not currently supported for evaluation ( datatype as table). Also when i am updating value from sharepoint list this column is not getting updated.
Request you help on urgent
I have not experienced the mentioned issue and hence not sure what the cause for it could be.
I will recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
Hello Reza, Do you have any videos where we can create multiselect cascading dropdown options for ex if I select Manufacturer Model should filter out based on manufacturer but we should be able to select multiple Manufacturer and Models
I do not
@@RezaDorrani any plan of making video on this topic?
@@ashtoshsingh8310 No
Hi Reza, I have one additional condition, if a user check a checkbox a dropdown should visible, user will select a value from dropdown and then submit the form, the selected value should also submitted to the data source that is sharepoint list. pls help
I do not have any video references on this. Best to check or post query on forums in case someone has done something similar
powerusers.microsoft.com
Thanks
Do you have to keep the combo box in the card along with the check box gallery? If I delete it does it mess up functionality?
If you dont need that card, then delete the card
@@RezaDorrani then the default property of the check box is set to blank since I don't need to reference the original data card?
These check boxes are really frustrating. Just when I think it's working, the new form will populate with check boxes. I'm at a loss.
@@LisaMcVay best to post your issues with screenshots on forums at powerusers.microsoft.com
Thank you VERY much for this tutorial. It helped me a lot :)
Hi Reza, thanks for this and all of your other recordings but I was wondering if you had a recorded solution to manage the Likert response from Microsoft Form(excel) to be updated into the Sharepoint List, using Power Automate. With my novice knowledge, I believe the method would be to use 'parse json' but I am happy to be corrected but the result is to use the Form to update a Sharepoint List that will then use to update an onboarding app and I would be grateful if you could provide me with some advice.
See if this video helps ua-cam.com/video/kbqXsKPTmZk/v-deo.html
Wow fabulous! Thank you so much :) I had a whole string of stuff I was trying to do OnVisible on the form and nothing was clearing it.
You are most welcome! Glad to hear the technique demonstrated is simple and helps solve a problem.
How do I integrate an existing application with a SharePoint list to use the multiple check boxes selection option?
This technique works with new and existing apps. You simply need the form control.
Hi Reza, how can i make the checkbox a mandatory field in my form?
If you make the data card mandatory, it should work
@@RezaDorrani Hi, I tried doing that, I set the data card as true, but when i submit the form, it doesn't highlight it as mandatory field like it does for other fields which are either text or choice column. i think is it because i created this field in the form itself and not in the SharePoint list? Do you know if i can make a checkbox field in the SharePoint list itself? Thanks for your response in advance.
@@priyankanirmal286 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
reaaaallllyyyyy useful!!!!
Glad to hear that!
Thank you so much shareing that. But, I cannot reset checkbox. When I submit, all is perfect, but if I create a new item, all checkboxes previously check are still checked. I set my variable blank, but seems to do not have effect. When I validate my variable, table is empty... but checkboxes no :( What I did wrong ?
thank-you
I will have to look at your App in action to know the cause of your issue. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Trying to implement the Multiselect check box in gallery functionality. And its not saving the data when selecting options from checkboxes.
I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
Reza, I've set visibility of a field based on whether boxes in the gallery are checked. Works fine, unless I uncheck a box that was previously checked. Any idea how to fix the issue?
When u uncheck, you should be removing selected item from collection. I have not faced this issue, so I can only make a guess.
@@RezaDorrani maybe it's on my visible field. This is my visible formula: If(galQues.Selected.Value = "Grant for existing project",true, false)
Got it!, I had to use the variable instead of the selected value of the gallery.
@@LisaMcVay Does not seem right. Difficult to help here on chat. Best to post your issue with screenshots on the forums at powerusers.microsoft.com
@@LisaMcVay 👍
I followed the steps on this video and tried creating multi select checkboxes using gallery in Power Apps but I am always having an error with the data card's default and update. It says, expecting record value. Do you have any idea how to fix this? Thank you. :)
I have not experienced the mentioned issue and hence not sure of the fix.
its working fine mutli select checboxes.but its not resetting the form after submitting the form.any suggestions
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
Reza you a best! Ty
Thanks Rinat!
The gallery border doesn’t turns red when the field is required, I added same formula from the Dropbox
If(isblank(parent.error), parent.bordercolor, color.red) but gallery border color doesn’t change to red, any idea?
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
How can we add All in Combo box and Select will all other items if we deselect, deselect all items.
You would probably need to add a button or some control for user to select which would trigger selection of all. On click of button, collect all items in collection. (I guess collection would be same as items property). And when user selects button to remove all selections, use clear function to clear the collection.
Thanks Reza!
Most welcome!
@Raza Dorrani, How i can set the Default values for a ListBox to be equal to a Choice of Dynamics 365 CRM field which allow multiple selection. plesae
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.
Thanks Reza 🙏🙏🙏
Welcome
only one value is saved in the list if I select multiple. please reply
If you follow steps in video, it should save multiple.
I will have to look at your app in action to know why. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
Hello Reza,
Usefull as always! Will you provide some comprehensive course on PowerApps soon?
I'm afraid the tool changes so quickly and so fast that any course is being outdated within few months
I have plans. More on lines of live training. And considering tool keeps changing, it would more or less be a quarterly training program.
@@RezaDorrani thank you I would be intrested, waiting!
Check channel memberships. I have gone live with a training tier that you can sign up for now.
ua-cam.com/users/rezadorranijoin
When trying to assign the function to the checkbox I get the following :(
set(variable,value) = this formula has side effects and cannot be evaluated, why is that?
Not sure as I have not come across this issue. Il recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
I need help with a formula: I have radio buttons, "Yes" and "No" and a somewhat dependent coinciding date field. I'm needing instructions on if the "yes" radio button is chosen, the date in the date field must be "before today", if "No" radio button is chosen, the date in the date field must be "after today".
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.
Thank you
I also have a date field on my power apps form that is showing the date & time. I've tried to update to only the date in the mm/dd/yyyy format, but the format doesn't change and I can't get rid of the time stamp.
@@rebeccathorn-pena9108 My answer would be the same. Please post it on the forums.