Announcements
I have created an app from Excel with a home screen gallery view. When I create a view form or edit form I cannot get any record to display. I know I have to set the Item property but I cannot seem to get the right syntax. Any help???
Hi! As you mentioned, it appears in the third screen shot you provided, Item property is not set. The schema for Item should be the same as the DataSource property (except the DataSource property is a table of that schema). For example, you should be able to set Item to "First(Employees_DataSheet)" and have things render. If you are using that same data source to connect to a gallery to view each record in the data source, you can view the selected record in the gallery in the form control by setting the form's Item property to "Gallery.Selected". I hope that helps. If you have any follow up question, do ask! Thanks,Spencer
Hi Spencer,
I set the item to First(Employee_Datasheet) in the form view but it shows the first record only and not the selected record from the gallery. Is there a way to set the selected record to show in the form view?
The gallery control has an output property `Selected`. `<GalleryControl>.Selected` should work, assuming the gallery is bound to the same data source as the form control.
Hi SpencerLynn,
I tried Gallery.Selected and received an error of "Invalid name". Any ideas??
Screen shot
Hi rms359,
I could not view your screen shot. I think it is a link to your sharepoint site, which I do not have access.
When you type the name of the gallery control into the Item property of the form and type ".", does it prompt you with any suggestions? Double check you have the name of the control correct.
Thanks,
Spencer
Hello rms359, try changing a property of the form: defualtMode = FormMode.Edit I changed it to FormMode.New in this way and the application behaves as expected.
This solved my problem. Thank you!
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 335 Most Valuable Professional
11manish 166
sannavajjala87 71 Super User 2026 Season 1
