Great video, I followed your instructions and works almost perfectly, for some reason when I enter on edit view, the first checkbox is not maintaining the selection made. There could be something that could be done to fix this?
This worked perfectly for my use case! I had one addition, though - as many others have stated, if you don't select or unselect a checkbox during an item edit, then all checkbox values are dropped when you save the form. This seems to be due to the fact that the collection is blank when the form is loaded. A workaround I found for this is to add the ClearCollect code sample ahead of any SubmitForm functions on the form. So for example: ClearCollect( colExample, If(Checkbox1.Value,Checkbox1.Text), If(Checkbox2.Value,Checkbox2.Text), ... If(Checkbox10.Value,Checkbox10.Text) ); ClearCollect( colExample,Filter( Products, !IsBlank(Value) ) ); SubmitForm(); This can be added to save buttons via the OnSelect property, and can be added to the overall SharePoint integration OnSave property. Hope this helps anyone else having this issue!
Hi Dhruvin, Great tutorial! When I have created my form using your system, if I try to edit a record, the correct check-boxes are selected in the form, but they don't save back to the record. Do you have recommendations about how the collection can be created in the Edit forms automatically so current selections are retained?
Hi Dhruvin copied the question from below, I have the same issue... When I have created my form using your system, if I try to edit a record, the correct check-boxes are selected in the form, but they don't save back to the record. Do you have recommendations about how the collection can be created in the Edit forms automatically so current selections are retained?
Hello Dhurvin, Great video on multi select checkbox column. When I submit the form and I need to submit the data to the list and reset my form. All other objects get reset except for the check boxes. I followed the video to covert a dropdown to check boxes. But it is not working. Please advice Thank you
Hi thanks for the information..I want to hide the another text input control based the selected value in this checkbox (inside gallery).. what should I writ in the visible property of that text input
Hello dear thank you for your video but it is not working i have a problem with the products name of the collection . Did you name it on another properties . Because I got an errors telling me that name isn't valid
Hi Dhrivin ,Great video it was helpful and How could i make one of the checkbox to default so that if the user will check nothing but it should be saved to SharePoint list
Hi dhruvin, i implemented according this and its working, but when i edit and save (without changing checkbox) item in the list all multiple coma seprated values having null values, kindly suggest 🙏
Any sources of info on how to do this when the source of the values/options for "Product Category" is another Sharepoint list "Product Categories" ??? (values not embedded in the Sharepoint list column??
Hi Dhruvin , awesome tutorial....I have faced one issue after doing all the steps in edit form and click on submit button , so it return to display form where my checkboxes are randomly selected by their own , I have checked my collections , in collection values are correct but in display mode checkboxes checked randomly, I really request you to please help me
Hi Dhruvin do we need to add any logic on display screen, so that whatever checkboxes I have selected in edit screen, after submit it will reflect same on display screen, kindly help
What if you have a checkbox option that allow user input? For instance. If you have 5 checkboxes and the 5th one is called "Other" and allows the user to input custom data.
Interesting! I will make a separate video for the same in future! Till then try this one! powerusers.microsoft.com/t5/Building-Power-Apps/Enter-item-manually-to-PowerApps-Dropdown-column-as-a-choice/m-p/353310#M101297
The auto populate is not working. They still show up false when looking at each form entry. Data card default is, ThisItem.'Survey Type' and the default for my checkboxes is, Self.Text in Concat(ThisItem.'Survey Type',Value&",")
it is an error is i use the collection as Update property of the data card, the error msg i got " Expected record value. The property on this control expects Record values. The rule produces Table value which are incompatible. "
I had an issue using this method for a field that requires at least one of the options checked. Instead of using a collection in DataCard.Update, I used a formula to build the table: Filter( Table( {Value: If(Checkbox1.Value,"Checkbox1")}, {Value: If(Checkbox2.Value,"Checkbox2")}, {Value: If(Checkbox3.Value,"Checkbox3")}, {Value: If(Checkbox4.Value,"Checkbox4")} ), !isBlank(ThisRecord.Value) ) With this you don't need any code in the OnCheck and OnUncheck properties. (I also deleted the original dropdown control after changing the properties in the Error Message label that referred to it.)
Great video, I followed your instructions and works almost perfectly, for some reason when I enter on edit view, the first checkbox is not maintaining the selection made. There could be something that could be done to fix this?
This worked perfectly for my use case! I had one addition, though - as many others have stated, if you don't select or unselect a checkbox during an item edit, then all checkbox values are dropped when you save the form. This seems to be due to the fact that the collection is blank when the form is loaded. A workaround I found for this is to add the ClearCollect code sample ahead of any SubmitForm functions on the form. So for example:
ClearCollect(
colExample,
If(Checkbox1.Value,Checkbox1.Text),
If(Checkbox2.Value,Checkbox2.Text),
...
If(Checkbox10.Value,Checkbox10.Text)
);
ClearCollect(
colExample,Filter(
Products,
!IsBlank(Value)
)
);
SubmitForm();
This can be added to save buttons via the OnSelect property, and can be added to the overall SharePoint integration OnSave property.
Hope this helps anyone else having this issue!
this works fine in edit form thanks!!
Thanks this is working fine now
Hi Dhruvin, Great tutorial! When I have created my form using your system, if I try to edit a record, the correct check-boxes are selected in the form, but they don't save back to the record. Do you have recommendations about how the collection can be created in the Edit forms automatically so current selections are retained?
Hi Joy, did you manage to find a solution for this? I am on the same boat.
Hi Dhruvin copied the question from below, I have the same issue... When I have created my form using your system, if I try to edit a record, the correct check-boxes are selected in the form, but they don't save back to the record. Do you have recommendations about how the collection can be created in the Edit forms automatically so current selections are retained?
Hello Dhurvin,
Great video on multi select checkbox column. When I submit the form and I need to submit the data to the list and reset my form. All other objects get reset except for the check boxes. I followed the video to covert a dropdown to check boxes. But it is not working. Please advice
Thank you
This is great video. Thanks you solved my issue
Hi thanks for the information..I want to hide the another text input control based the selected value in this checkbox (inside gallery).. what should I writ in the visible property of that text input
Hello dear thank you for your video but it is not working i have a problem with the products name of the collection . Did you name it on another properties . Because I got an errors telling me that name isn't valid
Thank you very much for the help
Great Vid!! Kudos!
Hi Dhrivin ,Great video it was helpful and How could i make one of the checkbox to default so that if the user will check nothing but it should be saved to SharePoint list
Hi Dhruvin, can you also show an example on how to store multiple value dropdown list using Dataverse/CDS?
Sure, I will consider our feedback! Soon, prepare one video on that!
Hi dhruvin, i implemented according this and its working, but when i edit and save (without changing checkbox) item in the list all multiple coma seprated values having null values, kindly suggest 🙏
Any sources of info on how to do this when the source of the values/options for "Product Category" is another Sharepoint list "Product Categories" ??? (values not embedded in the Sharepoint list column??
When I select all checkboxes it's showing error and in collection items also not storing, can you please tell why is it happens
How did you get your app to run on the right side of the sharepoint list?
I used Customized SharePoint List form and it's a default behavior of that form. If you used Canvas App then it will not show up on Right side!
excelente gracias
Hi Dhruvin , awesome tutorial....I have faced one issue after doing all the steps in edit form and click on submit button , so it return to display form where my checkboxes are randomly selected by their own , I have checked my collections , in collection values are correct but in display mode checkboxes checked randomly, I really request you to please help me
Hi Dhruvin do we need to add any logic on display screen, so that whatever checkboxes I have selected in edit screen, after submit it will reflect same on display screen, kindly help
Hi, Now to add check box field in powerapps
sir, how to patch checkbox collection to sharepoint?
What if you have a checkbox option that allow user input? For instance. If you have 5 checkboxes and the 5th one is called "Other" and allows the user to input custom data.
Interesting! I will make a separate video for the same in future!
Till then try this one!
powerusers.microsoft.com/t5/Building-Power-Apps/Enter-item-manually-to-PowerApps-Dropdown-column-as-a-choice/m-p/353310#M101297
The auto populate is not working. They still show up false when looking at each form entry. Data card default is, ThisItem.'Survey Type' and the default for my checkboxes is, Self.Text in Concat(ThisItem.'Survey Type',Value&",")
it is an error is i use the collection as Update property of the data card, the error msg i got " Expected record value. The property on this control expects Record values. The rule produces Table value which are incompatible. "
Hi,
I am facing the same problem. Did you find a solution? Thanks!
facing the same issue. Most probably, Dhruvin missed to show few steps
I had an issue using this method for a field that requires at least one of the options checked. Instead of using a collection in DataCard.Update, I used a formula to build the table:
Filter(
Table(
{Value: If(Checkbox1.Value,"Checkbox1")},
{Value: If(Checkbox2.Value,"Checkbox2")},
{Value: If(Checkbox3.Value,"Checkbox3")},
{Value: If(Checkbox4.Value,"Checkbox4")}
),
!isBlank(ThisRecord.Value)
)
With this you don't need any code in the OnCheck and OnUncheck properties. (I also deleted the original dropdown control after changing the properties in the Error Message label that referred to it.)