cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Jingjing
Kudo Collector
Kudo Collector

EditForm not Displaying

Hello,

 

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

FormDisplayIssue1.JPG

 

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

 

FormDisplayIssue2.JPG

 

If anybody knows the reason, please kindly advise.

2 ACCEPTED SOLUTIONS

Accepted Solutions
murali
Power Apps
Power Apps

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

View solution in original post

afernando
Kudo Kingpin
Kudo Kingpin

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.  

View solution in original post

11 REPLIES 11
murali
Power Apps
Power Apps

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
Kudo Kingpin
Kudo Kingpin

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.  

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.

 

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!

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

BM123
Frequent Visitor

Worked like a charm!

Thannnks this works for me.

Geet1996
Advocate I
Advocate I

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
Advocate I
Advocate I

On the form properties, use the ITEM field.

KevinColeMCM_0-1631668017235.png

 

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.

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Power Apps Ideas

Changes to Ideas Coming

We are excited to announce a new way to share your ideas for Power Apps!

Top Solution Authors
Top Kudoed Authors
Users online (4,453)