Power Platform Community Forum Thread Details

Hi, leveraging as much help as possible from ChatGPT i'm trying to create a powerapp for Stock taking and stock ordering. there is a main page with date picker, number input for a 6 digit site code, Text labels for each and 2 buttons 1 for stock take and 1 for stock order. There is a categories screen where i want to display a vertical gallery with 9 categories to select from and on select it should open an items page and list the items for that category in a vertical Gallery

AND THIS IS WHERE MY TORMENT BEGINS I have a set of 9 tables in an excel file each table has the category name as the column header. I've tried all kinds of ways to bring it into powerapps, creating a MS list as an xlsx doc hosted in a doc library in sharepoint etc. the closest i've had to success is adding each individual Table as a separate data source. What would be the most sensible / easiest way to host and import this data into powerapps??