Hi Andrew, Thank you so much for the tutorial. Have been looking for this kind for many days. I have been using data verse choice column with recommended type, which will refer choices from a choice table. Any thoughts or help on implementing these on those type of choice columns please? Thank you
Hi Vikki, yeah with Dataverse Choice types are a little bit different! There's a couple tricks here or there that. I don't have a video on it specifically but I know Shane Young does at around 13 : 29 in his video ua-cam.com/video/UJ2jwOC_TkY/v-deo.htmlsi=Bt8nUDh0zGJNVaeJ&t=809 .... I will have to make a video on it myself!
Nice. One of the clearest tutorials out there on this subject. Unfortunately, your method isn't very dynamic. What if you have a list of 30+ checkboxes. Becomes very tedious to hard code that.
Hi Lance, for 30+ checkboxes I would probably make each of those a single line text field and convert them to checkboxes in Power Apps, I would separate them, instead of a large choice field. Thanks for watching Lance!
Yes collections are only stored in the memory of the app. But deleting what was written in SharePoint is another issue. Not sure how that could happen.
@@chinmaykadambalu6331 You will need to get the data from sharepoint and save (ClearCollect) it in the collection. Add this command on Main Screen (OnVisible).
I have noticed when selecting a checkbox that selection is showing on all SharePoint records, not staying unique to the one editing. Can you assist with fixing that?
Does this method work without forms? (I know your presentation is based around SharePoint but I'm envisioning Dataverse where I'm working with a multi-select combo-box in a gallery and wanting to display the results of the combo-box as checkboxes - as opposed to the combo-box just saying 5 items etc.) Thanks for this video - much appreciated!
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
Hi Gyani! On the OnCheck property of each of the boxes, have it either Reset the other checkboxes or set their values to false. Those are 2 options you could do.
@@andrewhess123 SharePoint choice column converted to check box in power apps using vertically gallery and check box, but all choice option display as same check box properties and not getting on check property for each choice options
Hi Mayan, there's many things that could make this happen. Is your backend SharePoint? What does your OnCheck property say? On one of the check boxes, is it similar to Collect(colLifecycle, "Plan"), or is your column type a lookup instead of a multi choice field? Does it say Expected Record, and found what? Try this also, Collect(colLifecycle, {Value:"Plan"})..notice the curly brackets. There's lots of things that could be happening from that error message.
Hi Jonathan, I'm not sure about a Model Driven app using Dataverse. Model driven apps are limited in their functionality. I do think you could create a canvas app that has a Dataverse backend or use a Dataverse for Teams app and do this.
@@andrewhess123 Yes, it is very limited, specially this new field multiselect choices. If one tries to add check boxes, it asks you to connect it with some boolean field before dropping jn the form, so your multiselect field here is not visible. I had to achieve this using a long workaround, I thought you might have some shorter workaround like the one on the video. Thank you.
Hi, I've been looking for a while on how to do this, thanks for the video. I do have one issue, my collection doesn't seem to update with the selections Thanks It looks like using the 'Alt' key to test didn't work. When I went into full play mode, it kicked it into life!
Hi Andrew,@@andrewhess123 I've used this on 3 apps now, it's been great. That said on the current app (which I started last year and I'm now revisiting), when I create a new form, all checkboxes are empty, however if I check a box and submit the form, when I view the form, it has pulled the results from the previous saved form as well. New form submitted with checkbox 1 only, new form submitted with checkbox 2 only, when viewing form 2, checkboxes 1 and 2 are checked. When I looked at my SP list, 1 of my submitted forms had multiples for the selections! If I add the list box back in to see what's in the collection, it is already populated when I create a new form, even though my checkboxes are correctly unchecked. It seems like the ClearCollect on the FormScreen isn't working. Any help would be welcome. Thanks Craig
Hello, I tried the same approach for Data Verse as data source, it is giving "Expected OptionSetValue value" error on the update property when i entered collection name. any idea?
Every thing worked for me EXCEPT the Update. I put in the collection name (I double checked the spelling) but I get the red squiggly lines. I know the collection works because the list box test worked. When I submit the form, all of the fields get written to my Excel sheet, except for the collection. Is it because my "update" is in error? Thank you. - Paul
Very nice! ...and I love that mic!
Thanks Darren! 1 step at a time, now I need a green screen 😃
Very good content Andrew! thanks for always bringing something to teach us :)
Thanks so much Javier! thanks for always supporting me! I appreciate it a ton!!!
What is your code in submit button? Do you use patch? Do you have the code to patch the checkbox values to a multi-choice column in Dataverse table?
Hi Susan, Most likely the datasource is SharePoint and the submit button is just submit(form1). And I am writing the selection as a single line text
Very helpful! Thanks
Thank you neil!
Hi Andrew, thanks for this tip.
Hi Christer, thanks for watching! 😀
Hi Andrew, Thank you so much for the tutorial. Have been looking for this kind for many days.
I have been using data verse choice column with recommended type, which will refer choices from a choice table. Any thoughts or help on implementing these on those type of choice columns please? Thank you
Hi Vikki, yeah with Dataverse Choice types are a little bit different! There's a couple tricks here or there that. I don't have a video on it specifically but I know Shane Young does at around 13 : 29 in his video ua-cam.com/video/UJ2jwOC_TkY/v-deo.htmlsi=Bt8nUDh0zGJNVaeJ&t=809 .... I will have to make a video on it myself!
Nice. One of the clearest tutorials out there on this subject. Unfortunately, your method isn't very dynamic. What if you have a list of 30+ checkboxes. Becomes very tedious to hard code that.
Hi Lance, for 30+ checkboxes I would probably make each of those a single line text field and convert them to checkboxes in Power Apps, I would separate them, instead of a large choice field. Thanks for watching Lance!
I want not able to use collection in data card update properties. It is throwing error. Expected record value
My assumption is the issue is with the collection, when you add the collection to the Listbox does it appear correctly?
I'm encountering an issue when reloading the powerapp. The collection is cleared upon reload and it deletes the data saved in sharepoint.
Yes collections are only stored in the memory of the app. But deleting what was written in SharePoint is another issue. Not sure how that could happen.
Hi I am facing the same issue can you help me how to resolve this issue? Thanks in advance.
@@andrewhess123 Hi I am facing the same issue can you help me how to resolve this issue? Thanks in advance.
When reloading the app, the collections should be blank this is not an issue, but the functionality. @@chinmaykadambalu6331
@@chinmaykadambalu6331 You will need to get the data from sharepoint and save (ClearCollect) it in the collection. Add this command on Main Screen (OnVisible).
I have noticed when selecting a checkbox that selection is showing on all SharePoint records, not staying unique to the one editing. Can you assist with fixing that?
Very good, thanks!
Obrigado amigo! Made an assumption you knew Portuguese, hope I was right 😅I also love learning other languages
Does this method work without forms? (I know your presentation is based around SharePoint but I'm envisioning Dataverse where I'm working with a multi-select combo-box in a gallery and wanting to display the results of the combo-box as checkboxes - as opposed to the combo-box just saying 5 items etc.) Thanks for this video - much appreciated!
Yes I believe you could make this work with Dataverse. SharePoint is only the backend, could work with any datasource I would think.
What does the galProjects stands for?
galProjects is the name of my gallery on my Home Screen, the one with the red/yellow/greens
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
Hi Gyani! On the OnCheck property of each of the boxes, have it either Reset the other checkboxes or set their values to false. Those are 2 options you could do.
@@andrewhess123 SharePoint choice column converted to check box in power apps using vertically gallery and check box, but all choice option display as same check box properties and not getting on check property for each choice options
How would you do this without a gallery?
Hi whenever I enter colLifecyle in the update . I get an error stating expected Record Value can u please help
Hi Mayan, there's many things that could make this happen. Is your backend SharePoint? What does your OnCheck property say? On one of the check boxes, is it similar to Collect(colLifecycle, "Plan"), or is your column type a lookup instead of a multi choice field? Does it say Expected Record, and found what? Try this also, Collect(colLifecycle, {Value:"Plan"})..notice the curly brackets. There's lots of things that could be happening from that error message.
How do I do reset the checkbox using customize forms, could you please help me that
Hi Palika, it depends on how you have it set up, but you can set the default property to blank depending if its a new item, or edit item.
@@andrewhess123 thanks for your response
@@palikaanusha3043 Sorry for the late response, Holidays have taken a lot of my time 😀
Hi Andrew, thank your your video. Can you achieve this on a Form (For CRM) using Dataverse, how?
Hi Jonathan, I'm not sure about a Model Driven app using Dataverse. Model driven apps are limited in their functionality. I do think you could create a canvas app that has a Dataverse backend or use a Dataverse for Teams app and do this.
@@andrewhess123 Yes, it is very limited, specially this new field multiselect choices. If one tries to add check boxes, it asks you to connect it with some boolean field before dropping jn the form, so your multiselect field here is not visible. I had to achieve this using a long workaround, I thought you might have some shorter workaround like the one on the video. Thank you.
@@Jonathan_Vlog Yeah...not sure about how to get around it... yet
Hi,
I've been looking for a while on how to do this, thanks for the video.
I do have one issue, my collection doesn't seem to update with the selections
Thanks
It looks like using the 'Alt' key to test didn't work. When I went into full play mode, it kicked it into life!
Awesome Craig! Sorry I'm just getting back to you, glad you got it to work!
Hi Andrew,@@andrewhess123 I've used this on 3 apps now, it's been great. That said on the current app (which I started last year and I'm now revisiting), when I create a new form, all checkboxes are empty, however if I check a box and submit the form, when I view the form, it has pulled the results from the previous saved form as well.
New form submitted with checkbox 1 only, new form submitted with checkbox 2 only, when viewing form 2, checkboxes 1 and 2 are checked. When I looked at my SP list, 1 of my submitted forms had multiples for the selections!
If I add the list box back in to see what's in the collection, it is already populated when I create a new form, even though my checkboxes are correctly unchecked. It seems like the ClearCollect on the FormScreen isn't working.
Any help would be welcome.
Thanks
Craig
Hello, I tried the same approach for Data Verse as data source, it is giving "Expected OptionSetValue value" error on the update property when i entered collection name. any idea?
Hi sam k, not sure about that one
Every thing worked for me EXCEPT the Update. I put in the collection name (I double checked the spelling) but I get the red squiggly lines. I know the collection works because the list box test worked. When I submit the form, all of the fields get written to my Excel sheet, except for the collection. Is it because my "update" is in error? Thank you. - Paul
You are using Excel as a backend? I believe the steps would be different, you would want to convert the Update Property to a text instead of a choice.
A collection will not write to an Excel cell. You can write the Concat statement as a text field and then write that to Excel.
@@andrewhess123 Thanks. I will try that and let you know!
It populated, now I just need to figure out the if() statement to write only checked values.
@@northcastleintegration6066 Awesome, glad you got it! Feel free to reach out, willing to help any time.
Concat(ThisItem.LifeCycle,Value,",") what does LifeCycle in this formula represent? The column name?
Yes