Forum Discussion

RenPNW's avatar
RenPNW
Copper Contributor
Apr 15, 2024

Edit List Item using PowerApps form

Hi, 

I have a Form that I created that will allow me to create a new record in my Sharepoint List but when I try to Edit that record, selecting it from the default List view, I just receive a message on the Form that reads "Getting you data..."

I did some research and there was a post that stated that the Form -Item needed to reference a record.

When I add First('Form Name') or Last('Form Name')  I can get it to pull those records but users like to view records in List View and select an item to edit.  I can't figure out the formula to enter in ITEM to pull up the record that they select from the List View or Gallery view.

 

Any help will be greatly appreciated!

 

Ren

  • RenPNW Try setting Item property of form control like this: 

     

    If(IsBlank(SharePointIntegration.Selected),First([@Tasks]),SharePointIntegration.Selected)

     

    Where Tasks is the SharePoint list name. 


    Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

  • RenPNW Try setting Item property of form control like this: 

     

    If(IsBlank(SharePointIntegration.Selected),First([@Tasks]),SharePointIntegration.Selected)

     

    Where Tasks is the SharePoint list name. 


    Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

    • RenPNW's avatar
      RenPNW
      Copper Contributor

      ganeshsanap - Thank you!  That worked and saved the day for me!  Can I ask another question, is there a book that you recommend that I could read up on functions and creation of formulas for Powerapps forms?

       

      Thanks again, I truly respect your knowledge and your willingness to help is very much appreciated!

       

      Ren

Resources