Hello! I am fairly new to Power Apps & have an app where users select their Project from a SharePoint list in a first gallery & are taken to a second gallery that filters a different SharePoint list based on the selected project. This works perfectly on all projects. The users then have the option to go to a third screen that filters out all completed items from the second gallery. This works perfectly on all projects but one & I cannot find anything different about this record (from the first Project list) that could cause it.
Has anyone ever encountered an instance where a filtered gallery view fails on only one record?
Items property for second gallery: Search(Sort(Filter('Site Visit Photos', Project=BrowseGallery1.Selected.Project), Title, SortOrder.Ascending), TextInput1_1.Text, "Title")
Items property for third view with incomplete items only: Search(Sort(Filter('Site Visit Photos', Project=BrowseGallery1.Selected.Project, And ('Complete On Site?'<>true)), Title, SortOrder.Ascending), TextInput1_2.Text, "Title")
Any ideas are appreciated!

Report
All responses (
Answers (