Hello PowerApps Community,
I am trying to put a skills matrix in to PowerApps that we can embed into SharePoint so supervisor can allocate resources quickly and more efficiently. The data source is a one drive excel spread sheet. Attached is a small example of the spreadsheet we are using.
I wold like to be able to have the workers name shown in a gallery where we can select them. Then navigate to a new page and display their skills by product within a scrollable gallery. I can do this with a data table but there are to many products to display them nicely (over 200 product and 50 worker). Additionally this needs to be in a phone format,
The problem I am having is either reformat my data and make a button for every worker or I have a button for every product. I am have been using PowerApps for a few months now and my skills are basic. I can use filiter/sort/seach, edit/view forms, and do navigation. I don't know what to do and I cannot see the solution out side of making a massive app that has a ungodly amount of pages. Any help or suggestions that can point me in another direction would be great.
Thanks in advance. This is how i have gained most of PowerApps knowledge by asking questions and trial and error. This community is a invaluable resource to anyone looking for help to improve their skills. I can provide more info if needed. I did not include any pics of our initial trial app due to it containing sensitive information.
