Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id : 9H0DwYBDKBTPZ6YSqNHtqi
Power Platform Community / Forums / Power Apps - Power Apps Experimental Features / Checkboxes & SharePoin...
Power Apps - Power Apps Experimental Features
Suggested answer

Checkboxes & SharePoint Integration

Like (0) ShareShare
ReportReport
Posted on 12 Mar 2025 17:03:32 by Poweruser811 32
Hi,
 
I have a multiselect checkboxes field that is working fine when you submit a new form.
 
The problem is when users select 'edit' in Sharepoint to make changes. The form does not recognize that the category has already been selected and the error message appears.  This is causing the users not to be able to save the form.
 
I'm suspecting there is something with the sharepoint integration but not sure and how to fix it.
 
For SharePointIntegration, I have:
OnCancel - ResetForm(DataTrackerForm);
OnEdit - EditForm(DataTrackerForm); ClearCollect(Category, SharePointIntegration.Selected.'DataIssueCategory');
OnNew - NewForm(DataTrackerForm);
OnSave - SubmitForm(DataTrackerForm);
OnView - ViewForm(DataTrackerForm);
 
DataTrackerForm
OnSuccess - Refresh('DataTrackerForm'); ResetForm(Self); RequestHide()
Item - If(IsBlank(SharepointIntegration.Selected), First([@'Data Tracker Tickets']), SharePointIntegration.Selected)
 
 
Any ideas what is going on? 
 
Thank you in advance!
 
Category Required...
  • Suggested answer
    Michael E. Gernaey Profile Picture
    Michael E. Gernaey 35,667 Super User 2025 Season 1 on 13 Mar 2025 at 05:11:46
    Checkboxes & SharePoint Integration
     
    You having a value selected has no relevance to it being a blank collection.
     
    Its blank because the OnEdit property is not being triggered.
     
    Since you have the code there, and its not being triggered, the Collection is empty.
     
    Its like that saying the left hand doesn't know what the right is doing.
    The OnEdit is the left
    The right is the row of data that has a value lol
     
    But without OnEdit firing, it will never be populated.
     
    Just curious, why are you populating it in there? While I can understand if you are opening the Edit Form for sharepoint, I guess the question is, are you opening the Edit or the View?
     
    Because if you just click on the Item Detail button in SharePoint, it opens the OnView, not the OnEdit, so you would need that code in both places to insure it shows up.
  • Poweruser811 Profile Picture
    Poweruser811 32 on 12 Mar 2025 at 22:08:32
    Checkboxes & SharePoint Integration
    Sorry for the image, the error message is saying the value is required but there is a value selected.
     
    I checked the collection and see that it is blank even though there is a value selected. 
     
    Thanks!
     
  • Suggested answer
    Michael E. Gernaey Profile Picture
    Michael E. Gernaey 35,667 Super User 2025 Season 1 on 12 Mar 2025 at 21:22:34
    Checkboxes & SharePoint Integration
     
    I see no error anywhere, and if you mean that red blurry dark blue text :-( yeah, I'll have to let the youngsters try to read that.
     
    Otherwise please share the error.
     
    Now, the other thing, is I saw someone else who was trying to use the OnEdit to populate a field variable, but it wouldn't, so their stuff failed.
     
    My guess is the OnEdit is not populating the Category data.
    Can you run the app and then check the Collection to see if any data is in it?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Thomas Rice – Community Spotlight

We are honored to recognize Thomas Rice as our March 2025 Community…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,508 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,338 Most Valuable Professional

Leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans