web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / multi values not patch...
Power Apps
Answered

multi values not patching to SharePoint list

(0) ShareShare
ReportReport
Posted on by 96

Forum,

I have checkbox in gallery properly coded to update Sharepoint list.  The issue I'm having it getting the Sharepoint list to accept multiple selection.  See attached.

 

Thanks for your help.

TestPrintLink.JPGTestPrintLink2.JPG

 

TestPrintLink2.JPG
TestPrintLink.JPG
Categories:
I have the same question (0)
  • AntwainPatrick Profile Picture
    96 on at

    Additional information:  The gallery1 code may be my issue.  Gallery1.Selected.val  

    TestPrintLink3.JPG

  • Jeff_Thorpe Profile Picture
    6,085 Super User 2024 Season 1 on at

    Are the Printing and Startup columns in SharePoint also a choice column with multi selection?

  • AntwainPatrick Profile Picture
    96 on at

    Yes.  The current formulas in the Powerapp will populate the Sharepoint list, but only with on value.

  • Jeff_Thorpe Profile Picture
    6,085 Super User 2024 Season 1 on at

    How are the columns in SharePoint configured?

  • AntwainPatrick Profile Picture
    96 on at

    Single line text

  • AntwainPatrick Profile Picture
    96 on at

    Randy from forum gave me a sample App a few days back and I pulled from it what I needed.  This attach pic, Update Property select is how I'd like Sharepoint single line of text to read.  And have the option to add 3 or 4 values if needed.

    TestPrintLink4.JPG

  • Jeff_Thorpe Profile Picture
    6,085 Super User 2024 Season 1 on at

    Each item in the gallery has a single checkbox and you want to collect all the items that have the checkbox checked and write the Text values separated by a comma to a text field in SharePoint?

  • AntwainPatrick Profile Picture
    96 on at

    Yes.  I'd like to select 11x17 and PDF checkboxes and have it write back to Sharepoint list in column like: 11x17,PDF.

  • Jeff_Thorpe Profile Picture
    6,085 Super User 2024 Season 1 on at

    It looks like you have the correct formula in the previous screenshot but it just needs to be used in the patch().

     

    Example:

    Patch(TestPrintLink, Defaults(TestPrintLink), {Printing: Mid(........)})

     

    The mid(...) is what you have in the previous screenshot.

  • AntwainPatrick Profile Picture
    96 on at

    Unfortunately I did post two seperate formula line with the mid() formula. One was on a button and the other on the actual datacard.  I tried attaching the formula to the datacard and it gave me the following error:

    TestPrintLink5.JPG

    I know placing Gallery1.Selected.val  on the datacard will return a single checkbox selection to the Sharepoint list. 

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

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
Kalathiya Profile Picture

Kalathiya 368 Super User 2026 Season 1

#1
Kalathiya Profile Picture

Kalathiya 368 Super User 2026 Season 1

#3
WarrenBelz Profile Picture

WarrenBelz 318 Most Valuable Professional

Last 30 days Overall leaderboard