Unanswered

Help with Checkbox Reset In SharePoint Form

(0) Share

Report

Posted on by Community Power Pla...

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):

Checkbox:
1. Text: ThisItem.Value
2. OnCheck: Collect(colCategoryData, ThisItem)
3. OnUncheck: Remove(colCategoryData, ThisItem)
4. Default: ThisItem.Value in colCategoryData.Value
Data Card:
1. Default and Update: colCategoryData
Gallery
1. Items: Same as original multi-select drop-down

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.

Categories:

Building Power Apps

I have the same question (0)

All responses (11)

Answers (0)

Drrickryp Super User 2024 Season 1 on at

Like (0)

Report

@Anonymous

Did you put the gallery inside a card on the form?

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi, Drrickryp.

Yes.

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.

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (0)

Report

@Anonymous

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

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report
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.

Copy formula in Items property of the combo box
Delete combo box from Datacard
Insert gallery into Datacard (insert, then cut/paste)
Insert a single Checkbox into the Gallery
Paste the formula from step 1 into the Gallery Items property
Storing/removing SharePoint list values
Checkbox
Text property: ThisItem.Value
OnCheck property: Collect(colCategoryData, ThisItem)
OnUncheck property: Remove(colCategoryData, ThisItem)
Default property: ThisItem.Value in colCategoryData.Value
Data Card:
Change Default and Update property to colCategoryData
FormScreen1:
OnVisible:
Clear(colCategoryData);
If(SharePointForm1.Mode <> FormMode.New,
(
Collect(colCategoryData,
LookUp(SPLISTNAME,ID=SharePointIntegration.SelectedListItemID,SPCOLUMNNAME)
)

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (0)

Report

@Anonymous

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.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

@Drrickryp

Are you saying this should be working as written, or that it needs changes?

Phil

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (0)

Report

@Anonymous

When you open a Form in New mode, Clear(colCategoryData). If the gallery depends on that collection, it will not retain old information.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

@Drrickryp

Sorry if I'm being dense, but how would I make this happen?

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (0)

Report

@Anonymous

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.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

@Drrickryp

Thanks for all of your help. Your advice has gotten me closer, but it's still not working as expected.

I just wish it was easier to create something as basic as check boxes in PowerApps. I'm going to have to find a different solution, I guess.

Thanks, again.

Was this reply helpful? Yes No