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 / Load SharePoint List I...
Power Apps
Answered

Load SharePoint List Item into PowerApps form without Gallery

(0) ShareShare
ReportReport
Posted on by 4

Hi Everyone, 

 

I've scoured the forums for an answer, unfortunately I have found what I'm looking for.

 

I have two Power Apps canvas apps (used specifically for forms), one strictly for submitting new content and one for editing the existing content.  

 

I have three SharePoint lists I'm submitting content to and editing existing content in using the tabbed list in Power Apps. I have successfully submitted the information to SharePoint using the "new" form, which is great - the "new" form is doing exactly what it should be doing.

 

My challenge is editing a SharePoint list item in Power Apps, I am attempting to click "Edit" on a SharePoint list item, but I cannot get the records to update in the "Edit" form.  I need to be able to have the SharePoint list item populate the Power Apps form, without the use of a Gallery.

 

I've modified the SharePoint list with the "Launch URL" for the Power Apps, so when I click on edit, the edit form appears. 

 

doudot_0-1712337949719.png

 

I can successfully load information from the SharePoint list into the Power Apps form using the "First" command, but unfortunately that only pulls the first record. I know data can be pulled into the form, but I need the List Item I want to edit to be pulled in.

 

Am I missing a variable in the edit Launch URL or is there a command, similar to First that pulls the list item when I click on Edit in SharePoint?

 

Any help would be appreciated.  Thank you very much!

Categories:
  • WarrenBelz Profile Picture
    156,956 Most Valuable Professional on at

    Hi @doudot ,

    SharePoint Integrated Forms were never designed to have multi-form functionality using the built-in controls and you will also have a conundrum which I do not think is solvable if you are trying to create a record and then edit it without exiting and re-selecting in SharePoint. Is there any reason you are not doing this with a Canvas App ?

  • doudot Profile Picture
    4 on at

    Both forms are Canvas Apps, but I've separated them.  I'm not using the SharePoint Integrated Forms for this. 

     

    I was hoping to use the "New Entry" form (which is working great) for submitting information to SharePoint.  After the information has been entered into the SharePoint list, I was hoping to "Edit" the SharePoint list item in the Canvas App I've created to edit / update the list data.  I have some relationships within the edit form that performs some many-to-many activities between the three SharePoint forms.

     

    So, from the SharePoint list, if I were to click "edit" as per my screenshot, there's no way to load that specific List Item into the form?  Would I have to load the entire SharePoint list in and manage it in the Canvas App?

  • Verified answer
    WarrenBelz Profile Picture
    156,956 Most Valuable Professional on at

    Hi @doudot ,

    Your screenshot was of an SP List, so I assumed Integrated. A Canvas App would use a Gallery to display, filter and choose the relevant record, however to your question - if you do the following OnSelect of the record from your Gallery

    Set(
     gblRecord,
     ThisItem
    )

    and OnSuccess of both your Edit and New Forms

    Set(
     gblRecord,
     Self.LastSubmit
    )

    then the Item of your Edit Form

    LookUp(
     SPList,
     ID = gblRecord.ID
    )

    you will display the record just created in your Edit form if you switch to it.

     

    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.

    MVP (Business Applications)   Visit my blog Practical Power Apps

  • doudot Profile Picture
    4 on at

    This works perfect - thanks very much for your assistance!

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 243 Super User 2026 Season 2

#2
WarrenBelz Profile Picture

WarrenBelz 190 Most Valuable Professional

#3
Mohsin Ali Profile Picture

Mohsin Ali 135

Last 30 days Overall leaderboard