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)
Check out the News & Announcements to learn more.
Did you know that you can visit the Power Query Forum in Power BI and now Power Apps
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.
DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.