I have a list collection that displays each sheet available in a spreadsheet. I want to create an event handler that will navigate to another screen containing a collection of the data from the selected sheet. A nested collection that is dynamically queried. The number of sheets will not be constant.
I used the additional scope feature to pass the name of the sheet selected into a query and placed it in the sheet name field but it seems to add a / at the end that ruins the format.
Is there a way to fix this or is there another way to achieve this?
Thanks