EditForm not Displaying

[Jingjing]

Hello,

I have created an app from blank. I added an excel file as a data source of an Edit Form. See below:

Everything seems fine but when I start to play the app, it gives me blank except for the button:

If anybody knows the reason, please kindly advise.

[murali · Accepted solution]

Form binds to an "item" in a datasource. If you want to add a new item to the datasource, place the form in "New" mode via NewForm(Form1) function. If you instead want to edit an item in the datasource, then set Item property on Form to a record in the datasource. This is typically done by having a gallery that displays the contents of the datasource and Gallery.Selected provides the item that you want to edit i.e. Form1.Item = Gallery.Selected. Let us know if this helps.

Here is a quick tutorial of how to create an app from scratch.

https://powerapps.microsoft.com/en-us/tutorials/get-started-create-from-blank/

Murali

[afernando · Accepted solution]

This looks like a bug in last update (.460) I have forms bound to SharePoint lists and they also get dissapraed when enter into the preview mode or open in view mode. But I can see the form when I enter in to edit mode.  

[Jingjing]

Hi Murali,

Thanks for your advise!

I do not have any new item to the datasource. Also in this case I do not need a galary page for user navigate. What I would like the user to see is simply an Editform when they open the app, fill it out and click submit.

What I did are the following steps:

1. Add a data source (the excel form)

2. Add an EditForm. Set DataSource= TableName

Please correct me if there is anything incorrect.

[Jingjing]

Hello, I just tried to run the app, it works fine. So I think it is a bug in preview status.

Thank you for your help!

[Jingjing]

Hello, I just tried to run the app instead of the preview modle. It works totally fine! Thank you! 🙂

[BM123]

Worked like a charm!

[Anonymous]

Thannnks this works for me.

[Anonymous]

This normally happens because your datasource is empty if the form is in edit mode, Change the form to new mode it should show the form. 

[KevinColeMCM]

On the form properties, use the ITEM field.

This is what you need in the Item field to get the Display and edit form working for sharepoint integrated forms.

If(IsBlank(SharePointIntegration.Selected) || IsEmpty(SharePointIntegration.Selected),Defaults(YOURFORMNAMEHERE),SharePointIntegration.Selected)

Super helpful that they don't default that value or tell you it's missing. Wasted 2 hours.