Skip to main content
Community site session details

Community site session details

Session Id : l+qmHU+bPSevSq0GkUBRJJ
Power Apps - Building Power Apps
Answered

How to Update a SharePoint list without using a gallery

Like (0) ShareShare
ReportReport
Posted on 7 Apr 2023 14:15:37 by 134

Hi All,

 

My colleague has a PowerApps app that she created using SharePoint Integration. The app created the original Form1 with the default SharePoint integration functions (OnEdit, OnSave, OnView, etc.), however the SharePoint list that the app is associated with requires another form (Form2) that will submit all the data entered on Form1 along with an attachment and comments entered on Form2. Because of this, Form2 has a separate button (from the SharePoint Integration "Save" button) that is supposed to update the list item that is selected. There is NOT a gallery in this app, we are only utilizing the SharePoint list as the "gallery". Here is the issue:

 

We are using a Patch function in the OnSelect property of the button on Form2 and it is creating a new item on the SharePoint list instead of updating the selected item. We are using the Defaults in the Patch function, which I have identified is the issue, however, without a gallery, we cannot figure out a function that will work to only update the selected item. We have tried to use "ThisItem" and LookUp, but both require that you have a gallery in your app to look the item up from. How can we get this to work?

  • LS579 Profile Picture
    134 on 07 Apr 2023 at 18:23:49
    Re: How to Update a SharePoint list without using a gallery

    That's what we were looking for! Thank you!

  • Verified answer
    NandiniBhagya20 Profile Picture
    4,667 Super User 2024 Season 1 on 07 Apr 2023 at 14:21:49
    Re: How to Update a SharePoint list without using a gallery

    Hi @LS579 ,
    If you are using forms, then you can use SharePointIntegration.SelectedListItemID in your patch function :
    Patch(ListName, LookUp(ListName, ID = SharePointIntegration.SelectedListItemID), {<columns you like to update>})

     

     

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

Announcing our 2025 Season 2 Super Users!

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

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 637 Most Valuable Professional

#2
stampcoin Profile Picture

stampcoin 570 Super User 2025 Season 2

#3
Power Apps 1919 Profile Picture

Power Apps 1919 473