Multi Select Checkbox in Sharepoint Integrated Form

[sf1173nyc]

Hello all!  I am hoping you can help me solve my problem with my sharepoint integrated form.  I watched @RezaDorrani YouTube video for Multi Select Checkbox in Power Apps and while this video as all Reza videos are awesome this is for a canvas app and trying to get this to work in a sharepoint integrated form.  I have been successful in getting the form to work in new and edit mode but not view mode.  I am using the formula below on my OnVisible which I updated to point to the SharePointIntegration as opposed to the main gallery like Reza showed in his video.

Any ideas where else I would need to update?

This is what I see for the list item: 

What I click to view the list item I see this below.  How can I get the check boxes selected to show in view mode?

Then once I go into edit mode I can see the items that were selected and can change and update these with no issue.

[WarrenBelz]

Hi @sf1173nyc ,

Your fundamental issue I believe is that the collection that is needed to populate the existing items is not running. SharePoint Integration has a weakness that items at App OnStart and Screen OnVisible will not run at times if you simply switch records as the app and screen are "already open" in the view of Power Apps - you have simply changed the record displayed. To test this theory on yours, refresh SharePoint (with the browser refresh button) and see if it works first time in View Mode.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

[WarrenBelz]

Hi @sf1173nyc ,

Just checking if you got the result you were looking for on this thread. Happy to help further if not.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

[sf1173nyc · Accepted solution]

Sorry for not responding I put this down over the long weekend and I just started this up again today but the good news is I was finally able to get this to work in view mode by changing some of the logic.  I made the OnVisible to blank and then updated the Default for the Checkbox to the below:

Then I updated the OnEdit, On New and OnView for the SharePointIntegration to the following:

All the above seems to have done the trick.  Thanks for responding and trying to help.

[Anonymous]

Hi @sf1173nyc ,

I followed all the steps you mentioned above but what i am noticing is that if i edit few items and save it at that it works fine but then if i refresh the page and edit again. Previous values saved goes blank and new value is saved. Not sure what am i doing wrong here. Seems to be something with collection. Any help is appreciated. This is what i have on my form:
OnView
Refresh('Training Request Form');
ClearCollect(
colSOData,
SharePointIntegration.Selected.'Strategic Objectives'
);
ViewForm(SETRForm)
OnEdit
Refresh('Training Request Form');
ClearCollect(
colSOData,
SharePointIntegration.Selected.'Strategic Objectives'
);
EditForm(SETRForm)

OnNew
Refresh('Training Request Form');
ResetForm(SETRForm);
Clear(colSOData);
NewForm(SETRForm)

Default

If(SETRForm.Mode <> FormMode.New,ThisItem.Value in SharePointIntegration.Selected.'Strategic Objectives'.Value)

[sf1173nyc]

I followed Reza's video exactly then made the changes I noted in my post so look at your other settings.  With the Datacard Selected make sure your Default and Update is set to your collection colSOData.  Below is what my tree view looks like and noted the areas where I have made changes. 

[AMcAdams]

Hi @sf1173nyc ,

I was so happy to find this post! I have been trying to figure out this checkbox issue for months! I followed Reza's video, and one by Krishna Rachakonda, and other various videos and posts. The problem with all of them was they were using the canvas app and not the integrated app.  And also - MS seems to change things so often, pieces of code and screenshots all seem to be irrelevant 6 months later. 😞 

Unfortunately, following your guide I have still not been able to make this work!  

I did all the stuff in Reza's video. Then I made OnVisible blank (nothing in it) and updated the Checkbox Default and the OnEdit, On New and OnView for the SharePointIntegration.  And the datacard's Default is set to the collection. 

Those three in the SharePointIntegration aren't working for me. They all have the squiggly red underline under Refresh(Checkbox1).  

There are two errors for each of these:

- Expected a record or table value

- The function 'Refresh' has some invalid arguments.

I tried changing it from Checkbox to the gallery, the datacard, the form, everything! Obviously I'm grasping at straws here. I don't understand why it doesn't like "checkbox1" when it works fine for you. 

[Anonymous]

I am sure it works in Canvas App but it does not work in Integrated App. As shown above I also tried modifications to it and still was giving weird results. When i would click on Edit first time it would show all checks as blank and on second refresh it will load properly and will work fine onwards. I just did not go back try to figure that out but hopefully someone can share if they got it to work.

[sf1173nyc]

I have built to sharepoint integrated forms that use this checkbox functionality and have not issue so not sure why it doesn't work for you.  

[sf1173nyc]

I just checked my sharepoint integrated forms to make sure they are still working with no issue and they are still running as they should.  I am putting a screen shot of the write up I did as I was tasked to solve this for someone else in my company.  In the list I created multi select choice column called Fruit Type.