Preface: I'm very new to Power Apps.
I've successfully built an app that can create a collection of items and add them to a SharePoint list. Now though I'd like to have a distinct collection that is populated by a SharePoint list "on load", and I have no idea how to do that. My SP list has two columns: Person, and Supervisor. Let's say there are 20 people (aka employees), and 5 supervisors. So on average, one supervisor is associated with five people.
In my app, I want a screen that automatically loads a list of "my" employees (assuming "I" - the person opening the app) am a supervisor). The app is already connected to our MS "global" list of people, and it knows how I am when I open the app. The load function needs to scan the SP list, find those employees that are assigned to me, and then add them to a collection so they can be displayed in a gallery. My intent at that point is to add a text (specifically a number) input field for each person. The purpose of the app is to enter a number for each employee, and then with a Collect function send those names and the number to a separate SP List (or Excel) sheet. I know how to populate a gallery with the data from the SP list of people (employees)... but I have no idea how to populate a collection, and one that is specifically filtered based on the "supervisor" column. Any hints or tips would be greatly appreciated.
