cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper II
Helper II

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

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:

image.png

 

 

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

 

image.png

 

Here is what happens when I edit the item:

image.png

 

 

 

 

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

 

Thanks again! You guys are awesome. 🙂 

 

1 ACCEPTED SOLUTION

Accepted Solutions

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.



--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

View solution in original post

12 REPLIES 12
Anonymous
Not applicable

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.

 

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!

 

 

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?



--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

@Jeff_Thorpe,

 

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

 

image.png

 

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?

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. 



--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

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. 

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



--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

Here's what it's set as:

 

image.png

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.



--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

View solution in original post

Helpful resources

Announcements
News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

Power Apps Community Call

Power Apps Community Call- January

Check out the Power Apps Community Call for January 2021

PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

secondImage

Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

Top Solution Authors
Top Kudoed Authors
Users online (6,486)