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!
Solved! Go to Solution.
Just want to throw a note out here on this issue. Usually it works great to store the gallery item selection to a variable, such as varSelectedItem. This would be on the On Select property of an icon that you drop into the gallery.
...and then set the Item property of the Form on the next screen to varSelectedItem.
One time, however, this would not work for me and the form could not find any item to display even though the variable had been set properly. Remembering that a form in New mode likes to have the Item property set to Defaults('List Name'), I experimented with this and found a way to make it accept the variable again.
By telling the form explicitly what to do in Edit vs New mode fixed this. So the Item property of my form is now:
If(FormMode=FormMode.New, Defaults('List Name'), varSelectedItem)
Learn how to create your own user groups today!
Check out the new Power Platform Community Connections gallery!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.