Form: No Item to Display / Data Source May Be Invalid

[jtillinghast]

I've created a form and linked it to a data source (Excel table in OneDrive). When I'm editing in a browser window, I see the individual data cards. When I run the app, though, the form just displays "No Item to Display." In addition, in the editing view (so again, with data cards and values that I can enter), if I click the submit button, I see an error message: "There was a problem saving. Your data source may be invalid."

I saw reference elsewhere in the forum to setting the form Item property. I set "Item = First(Period_3)", where Period_3 is the name of the data source table. No change.

Any suggestions? Thanks!

[v-micsh-msft]

Hi @jtillinghast,

It is recommended to start from the article below:

Understand data forms in Microsoft PowerApps

For a form control to show data, we need to configure the Data Source and the Item property.

Besides, we also need to un-hide the corresponding DataCard for the form to show the proper fields.

Some additional document for your reference:

EditForm and Display form controls in PowerApps

If you have any further questions, please post back.

Regards,

Michael

[jtillinghast]

Thanks, Michael-- I've been trying to reference both of those pages, but I'm obviously missing something. I've configured DataSource for the form to match the source form in Excel ("Period_3"). As I referenced above, Item is set to =First(Period_3). I've made sure that there are visible records:

For what it's worth, I edited the display name of the first record to remove the bad formatting, and now it's greyed out-- its visible status is set to "true," and I see it in edit mode, just not in run mode.

Thanks for your help!

Jeff

[Anonymous]

Hi jtillinghast,

I am having the exact same problem!

v-micsh-msft - The articles you provided are definately useful in understanding more about the different data forms, but it does not actually address this particular issue where the data does not display (although there is a valid connection to a data source, the data card is set to visible, etc).

It is difficult to continue working on an app, if I cannot preview it of course... I see there have been over 40 views on this conversation so far, so perhaps others have had a similar issue (and if you figured it out, could someone please share how?).

Thanks so much in advance!! 😉

           

[Anonymous · Accepted solution]

jtillinghast - I found a solution to this, and figured to post it here in case others have the same problem.

This video shows a very easy solution to this: https://www.youtube.com/watch?v=q6Bd0QFGvAc

Essentially you need to select the form on the sheet, and you will see that when selecting 'Item' the functions bar is blank,  therefore it displays nothing in preview!

• Simply change to: Item = Defaults('list name')
• 'list name' should refer to whatever SharePoint list you are pulling your data from

Below a screnshot from the video. Making this change resolved this for me! 🙂

[TechIY]

@Anonymous wrote:

jtillinghast - I found a solution to this, and figured to post it here in case others have the same problem.

This video shows a very easy solution to this: https://www.youtube.com/watch?v=q6Bd0QFGvAc

Essentially you need to select the form on the sheet, and you will see that when selecting 'Item' the functions bar is blank,  therefore it displays nothing in preview!

• Simply change to: Item = Defaults('list name')
• 'list name' should refer to whatever SharePoint list you are pulling your data from

Below a screnshot from the video. Making this change resolved this for me! 🙂

---

 Thanks DanielaH for sharing your solution, it really sorted me out!

[viquar]

I had the same issue but it resolved after referencing to the given youtube link.  Thanks...

[Anonymous]

Try going to DisplayMode and make sure it is listed as New.

[jamiedgarden1]

^I came here to write this, try it first as it is the simplest 😄

[Anonymous]

You are a legend.  Worked for me, thanks!

Adding Defaults('DataSource') to the form's Item property made all the difference on my new app.  Oddly, though, I have another PowerApp where the Item property of the form is blank yet it still submits without any trouble.  The mind boggles.