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
PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Top Solution Authors
Top Kudoed Authors
Users online (2,728)