SOLVED

Edit List Item using PowerApps form

Copper Contributor

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.List view.PNGitem formula.PNG

 

Any help will be greatly appreciated!

 

Ren

3 Replies
best response confirmed by RenPNW (Copper Contributor)
Solution

@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. 

ganeshsanap_0-1713157612440.png


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.

@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

@RenPNW 

 

Check this Microsoft official documentation where you can find information about all Power Apps functions: Formula reference - Power Apps 


Please consider giving a Like if my post helped you in any way.

1 best response

Accepted Solutions
best response confirmed by RenPNW (Copper Contributor)
Solution

@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. 

ganeshsanap_0-1713157612440.png


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.

View solution in original post