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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Patch Sharepoint list ...
Power Apps
Answered

Patch Sharepoint list when a gallery item is marked does not work

(0) ShareShare
ReportReport
Posted on by 20

I have a gallery with checkboxes. The gallery uses data from sharepoint.

If a checkbox is marked and I click on a button the marked items in sharepoint shall be patched (column "Send" shall be set to "true").

I tried the following code, but the sharepoint list is not patched.

 

ForAll(Filter(Gallery.AllItems; CheckboxAuswählen.Value = true); Collect(MarkedItems; {string:Titel});;
Patch(SharepointList; LookUp(SharepointList; Titel= First(MarkedItems).string); {Send: true});;
Remove(MarkedItems;First(test)));;

 

Thanks a lot!

Categories:
  • RezaDorrani Profile Picture
    12,145 on at

    Hi @JensVolswinkler 

     

    Check https://youtu.be/VzrarcM9W5k

     

    --------------------------------------------------------------------------------
    If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

    Thanks,
    Reza Dorrani, MVP
    YouTube
    Twitter

  • JensVolswinkler Profile Picture
    20 on at

    Hi @RezaDorrani I watched some parts of your videos, but I am not sure if they can help me in this concrete case...will probably have to watch them in full.

     

    I replaced "Titel= First(MarkedItems).string" with "Titel = ExistingTitle" and the sharepoint entry with the existing title got patched....

    therefore I assume that "Titel= First(MarkedItems).string" is not working as expected.

    Why is that the case? 

     

    Why is that the case?

  • JensVolswinkler Profile Picture
    20 on at

    I can stil not figure it out...the video has a lots of interesting informations @RezaDorrani but I do not see how it helps me solve my problem.

    Could you please tell me in which part of the video you think is the solution - 

    or directly explain to me how I can solve this.

     

    Thanks a lot in advance!

  • Verified answer
    KvB1 Profile Picture
    1,596 on at

    If the items property of your gallery directly has your sharepoint list as a source, you can just use "ThisRecord" Instead of the lookUp

     

    Something like: 

     

    ForAll(
     Filter(
     Gallery.AllItems;
     CheckboxAuswählen.Value=true
     );
     Patch(
     SharePointList;
     ThisRecord;
     {
     Send: true
     }
     )
    )

     

     

    Please check syntax i freehanded

  • TheresaHenry Profile Picture
    3 on at

    This was exactly the solution I've been searching for hours to find! 

     

    I hope others find this solution when you cannot match an ID in a collection with an ID in a SharePoint list. Above is what helped me with my patch to update a SharePoint list with a collection's data.

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 232 Super User 2026 Season 2

#2
WarrenBelz Profile Picture

WarrenBelz 202 Most Valuable Professional

#3
Mohsin Ali Profile Picture

Mohsin Ali 122

Last 30 days Overall leaderboard