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
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Carousel_PP_768x460_Wave2 (1).png

2022 Release Wave 2 Plan

Power Platform release plan for the 2022 release wave 2 describes all new features releasing from October 2022 through March 2023.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Top Solution Authors
Users online (5,782)