Hi, All. I've tried several posts and videos and I just can't get this to work:
I've created a default SharePoint list form in Power Apps, and changed the multi-select drop-downs to checkboxes within galleries. It all works well, except when I click the New form button in SharePoint, the form doesn't clear the previous checkbox entries.
If possible, I'd like the entire form to reset when the New SharePoint form button is pressed. Right now it does, except for the checkboxes.
Here are my details (collection is colCategoryData):
Anything beyond this that I've found (variables, OnVisible, Reset) doesn't work.
Please and thank you. I'm pulling out what little hair I have left.
I followed Reza's vid, including info in the comments for SharePoint forms, and check boxes are still not clearing when a new form is opened.
Everything else seems to work fine.
Check this post to see if the solution works for you. https://powerusers.microsoft.com/t5/Building-Power-Apps/multiselect-check-boxes-in-custom-SharePoint-form-with-PowerApps/m-p/1427869
Hi, @Drrickryp .
Thanks for the link, but it didn't help. Opening a new form in SharePoint still retains the checkbox info of the last saved form. I also notice that if you open a new form then cancel it, the checkboxes in previously saved forms are blanked out.
Here's my process and code, taken from the video by @Reza as well as other sources such as the link you sent.
Storing/removing SharePoint list values
If(SharePointForm1.Mode <> FormMode.New,
It appears to me that the checkboxes are dependent on colCategoryData. If the collection is cleared, then the checkboxes should be returned to their default state.
Since I don't use Integrated SharePoint forms, I am not familiar with the specific commands but there must a button that you push to open the form in New mode, It would have NewForm(Form...) as a command. If you find it add
NewForm(Form1);Clear(colCategoryData) Then when you navigate to the form, the Gallery should be reset.