Answered

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

(0) Share

Report

Posted on by 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. 🙂

Categories:

Building Power Apps

I have the same question (0)

All responses (12)

Answers (1)

Sort by

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
nealhicks1 94 on at

Like
a
(0)

Report
Copy link

Link copied!

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!

Was this reply helpful? Yes No
Jeff_Thorpe 6,085 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
nealhicks1 94 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Jeff_Thorpe 6,085 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
nealhicks1 94 on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Jeff_Thorpe 6,085 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
nealhicks1 94 on at

Like
a
(0)

Report
Copy link

Link copied!

Here's what it's set as:

Was this reply helpful? Yes No
Verified answer

Jeff_Thorpe 6,085 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
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.

Was this reply helpful? Yes No
nealhicks1 94 on at

Like
a
(0)

Report
Copy link

Link copied!

That did it. How did you figure out that this was needed? Is it just that you have a lot of experience with this?

As always, I really appreciate your help. 🙂

Was this reply helpful? Yes No