My goal:
I'm building an app to edit inventory lists.
Upon launching the app, the user is supposed to select a category.
Based on that selection, the right list should be made in a gallery on a new screen.
That gallery is created by pulling data from an Excel table in a collection. This collection is then edited, when the user clicks on a certain button, all the changes get patched to the Excel table again.
My problem occurs when I try to create the collection based on the selected category in a dropdown list.
I just don't see a way to be able to create a collection from a variable data source.
Do any of you know a way to achieve this?