I'm creating an app that has 3 galleries on the same screen. The galleries are:
- ServicesGallery
- QuestionsGallery
- Answers Gallery
I have attached a photo showing the 3 galleries.
The Services Gallery is populated by a SharePoint list called 'Services'
The Questions Gallery is populated by a SharePoint list called 'Questions.' This gallery is filtered by the ID of the Services gallery, so that when someone chooses a service, only the questions relevant to that service appear in the Questions gallery. The Items property for the Questions Gallery is: Filter(Questions,ServicesID=ServicesGallery.Selected.ID)
This all works fine. But I need the third gallery, "Answers" to filter according to the question that is selected in the Questions Gallery. The Answers Gallery is populated by an Excel Table that contains 3 columns: the Questions ID, a column called Answers and a third called Results.
The Items property for the Answers Gallery that I have now is:
Filter(ExcelAnswersTable, Question_ID=QuestionsGallery.Selected.ID)
My Answers Gallery then shows an error message that says "Incompatible types for comparison. These types can't be compared: Text, Number." This doesn't make sense to me because the columns in the 'ExcelAnswersTable' and the Question ID in the 'Questions' Sharepoint list are both numeric data types.
When I preview the app, the first question I choose in the Questions Gallery works correctly and pulls up the relevant answers in the Answers Gallery. However, when I choose one of the other questions I just get blanks in the Answers Gallery.
Any suggestions would be greatly appreciated! Thanks.
