Issues with editing SPO list item that has been populated using PowerApps created form

[nealhicks1]

Hi everyone,

I created a form using PowerApps that links with a SPO list. The form works correctly, in that data entered in all fields properly propagates to the item in the SPO list. Meaning, an item is created in the SPO list, with all data fields properly recorded.

However, when I edit the list item, the form comes up, but all fields are blank. The data is present in the list item, but isn't displaying upon editing / in the form. 

Does this make sense? I can provide screenshots, if that would help. 

Here is the form:

Here is the item in SPO, properly populated with data:

Here is what happens when I edit the item:

Does anyone have any thoughts on what might be going wrong?

Thanks again! You guys are awesome. 🙂 

[Anonymous]

Hey @nealhicks1,

First you have to check 2 things.

 1 - in properties in the default mode check if its set to "edit"

 2 - In the advanced options of the form make sure that the item is properly selected to "gallery.Selected" (Or any of your recommended ways)

Cheers.

[nealhicks1]

Hello @Anonymous,

Thank you for your response!

I have checked the form's properties, and confirmed that the "Default mode" is set to Edit. Under Advanced > Item property, I see "Defaults('New User Request Form') as the value. 

What do you mean by make sure that item property is set to "gallery.Selected"? Also, what do you mean by any recommended ways?

I have a feeling that maybe this field is set incorrectly. I really appreciate your help in troubleshooting this!

[Jeff_Thorpe]

It looks like you are using the PowerApps custom form for SharePoint. If so, then you don't have a gallery unless you added one. From your screenshots it looks like it is in newform mode instead of edit. Two things to check:

What are the actions property pane on SharePointIntergration for OnNew, OnEdit and OnView?

What is the Item property formula for SharePointForm1?

[nealhicks1]

@Jeff_Thorpe,

I think you're on to something. Here's the property settings are:

There is definitely something wrong there. Do I need to change NewForm/EditForm/ViewForm(SharePointForm1) to something else? 

Edit: Is it as simple as setting it to New User Request Form?

[Jeff_Thorpe]

Did you change the form name to EditForm3 or did you add additional forms? The actions are based on the original form name SharePointForm1. You can try updating the actions to use EditForm3 instead of SharePointForm1 or if you no longer have a SharePointForm1 then you could just rename EditForm3 to SharePointForm1.

The PowerApps custom form for SharePoint is designed to use only one form for New, Edit and View, so you need to be careful with changes that could effect that design. 

[nealhicks1]

I just added an additional form, which was EditForm3. I renamed EditForm3 to SharePointForm1, and confirmed that the errors were cleared from the SharePointIntegration Action properties, but I'm still experiencing the same behavior in that when I open an already created item, all the fields are blank.

I wonder why this is happening. I am digging around, trying to find other errors, but haven't come across anything suspicious yet. 

[Jeff_Thorpe]

What is the formula that is in the Item property for SharePointForm1?

[nealhicks1]

Here's what it's set as:

[Jeff_Thorpe · Accepted solution]

The Item property should look like this but you will need to change [DataSourceName] to the actual name of your datasource.

If(IsBlank(SharePointIntegration.Selected) || 
 IsEmpty(SharePointIntegration.Selected),
 First([DataSourceName]),
SharePointIntegration.Selected)

You should also look at the DataSource property of the SharePointForm1 and make sure your data source name is also there.