Answered

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

(5) Share

Report

Posted on by 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!

Categories:

Building Power Apps

I have the same question (0)

All responses (20)

Answers (1)

v-micsh-msft on at

Like (2)

Report

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

Was this reply helpful? Yes No
jtillinghast 32 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Community Power Pla... on at

Like (2)

Report

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!! 😉

Was this reply helpful? Yes No
Verified answer

Community Power Pla... on at

Like (106)

Report
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! 🙂

Was this reply helpful? Yes No
TechIY 42 on at

Like (2)

Report
@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!

Was this reply helpful? Yes No
viquar 9 on at

Like (1)

Report

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

Was this reply helpful? Yes No
Community Power Pla... on at

Like (11)

Report

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

Was this reply helpful? Yes No
jamiedgarden1 7 on at

Like (2)

Report

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

Was this reply helpful? Yes No
Community Power Pla... on at

Like (2)

Report

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.

Was this reply helpful? Yes No
JLbeaches 7 on at

Like (0)

Report

Thanks

This worked for me - although I'm not sure why it works. I've never had to dothis before - but it works!

Was this reply helpful? Yes No