Unanswered

Edit/View custom form not populating with existing data from SharePoint

(0) Share

Report

Posted on by matayom

I have a SPO List that I've created a PowerApps form for. I created this form and it has been working great, but recently I discovered it is not populating existing data when trying to view or edit a list item. Let me reiterate: nothing in this app has changed since it last worked, I am the only one with access to the app, so this malfunction is driving me insaine.

I've already searched the forum and can't find a solution that works, and scrubbing through my form I can't find ANYTHING that would cause this issue

Some info to get started:

SharePointIntegration > Advanced > OnNew: NewForm(SharePointForm1)

SharePointIntegration > Advanced > OnEdit: EditForm(SharePointForm1)

SharePointIntegration > Advanced > OnView: ViewForm(SharePointForm1)

SharePointForm1 > Properties > Default Mode: Edit

SharepointForm1 > Advanced > DefaultMode: FormMode.Edit

SharepointForm1 > Advanced > Item: If(IsBlank(SharePointIntegration.Selected) || false,First([@'3D Scanner Reservations']),SharePointIntegration.Selected)

Replacing 'Item' with the following returns an error "Invalid argument type (Record). Expecting a Table value instead"

If(IsBlank(SharePointIntegration.Selected) || IsEmpty(SharePointIntegration.Selected),First('YourListName'),SharePointIntegration.Selected)

Am I missing something? Is there some other hidden setting I need to check? Please help me lol

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

Sort by

WarrenBelz 156,417 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @matayom ,

Firstly, I am assuming 'YourListName' is the actual list (it was there before) and it should work, but try this

If( SharePointIntegration.SelectedListItemID > 1, LookUp( 'YourListName', ID = SharePointIntegration.SelectedListItemID, First('YourListName') ) )

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

Was this reply helpful? Yes No
matayom 6 on at

Like
a
(0)

Report
Copy link

Link copied!
Sorry, I should've changed that string to be consistent. My list name is '3D Scanner Reservations'
That string was found in several other posts as a solution, but it just throws an error for me. I've tried these variants:
If(IsBlank(SharePointIntegration.Selected) || IsEmpty(SharePointIntegration.Selected),First('3D Scanner Reservations'),SharePointIntegration.Selected)
If(IsBlank(SharePointIntegration.Selected) || IsEmpty(SharePointIntegration.Selected),First(['3D Scanner Reservations']),SharePointIntegration.Selected)
If(IsBlank(SharePointIntegration.Selected) || IsEmpty(SharePointIntegration.Selected),First([@'3D Scanner Reservations']),SharePointIntegration.Selected)

I also tried your suggestion, and it still will not populate:
If( SharePointIntegration.SelectedListItemID > 1, LookUp( '3D Scanner Reservations', ID = SharePointIntegration.SelectedListItemID, First('3D Scanner Reservations') ) )

Something I've noticed is, in the past, when I viewed or edited an item, there was usually some scrolling dots at the top of the form for a second or two, and once they disappeared then the form would populate. I am not seeing the scrolling dots anymore.

Was this reply helpful? Yes No
WarrenBelz 156,417 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
@matayom ,

There is something wrong with your app - I use the code I posted on all of my integrated apps. Short of deleting and re-creating it, I cannot suggest much more other than to shorten it to this

LookUp( '3D Scanner Reservations', ID = SharePointIntegration.SelectedListItemID, First('3D Scanner Reservations') )

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

Was this reply helpful? Yes No
matayom 6 on at

Like
a
(0)

Report
Copy link

Link copied!

Okay I tried that, you were missing a comma after SelectedListItemID but it still wont populate the form. Whats interesting is in the formula bar, it does appear to evaluate the formula & pull data, its just not updating the form with it...

Was this reply helpful? Yes No
matayom 6 on at

Like
a
(0)

Report
Copy link

Link copied!

Well I need the app to work so I just recreated the form and it works fine now. There must have been some backend error, thanks for the help

Was this reply helpful? Yes No
WarrenBelz 156,417 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@matayom ,

Comma fixed (dangers of free-typing code) - I guessed initially that you had a corrupt form.

Was this reply helpful? Yes No