Answered

Multi Select Checkbox in Sharepoint Integrated Form

(0) Share

Report

Posted on by 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.

Categories:

Building Power Apps

I have the same question (0)

All responses (19)

Answers (1)

Sort by

WarrenBelz 155,224 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
WarrenBelz 155,224 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Verified answer

sf1173nyc on at

Like (0)

Report
Copy link

Link copied!

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.

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

Like (0)

Report
Copy link

Link copied!

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)

Was this reply helpful? Yes No
sf1173nyc on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
AMcAdams 18 on at

Like (0)

Report
Copy link

Link copied!

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.

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

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
sf1173nyc on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
sf1173nyc on at

Like (1)

Report
Copy link

Link copied!

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.

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

Like (0)

Report
Copy link

Link copied!

Hi sf1173nyc ,
I am not sure but like i said it seems to work but edit part has issues. Depends on how you edit it. If you double click on the row and open the form and then Edit All then it seems to refresh ok but if you click on Edit from list toolbar it does not refresh ok and gives you blank values. I Tested refresh and Edit multiple times and saw these inconsistencies. It could be also some code I am missing other then what you posted above. Thanks for helping though..

Was this reply helpful? Yes No