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

9 REPLIES 9
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

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
Frequent Visitor

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
New Member

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
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (1,431)