I just dropped in this powerapp world and I'd like to build a management staff app.
In this app I'd like to create groups with the staff like: group 1 --> supervisor 1 --> employee 1, employee 2, employee 3, etc; group 2 --> supervisor 2 --> employee 4, 5, 6, 7; group 3 --> supervisor 3 --> employee 8, 9, 10, etc.
Besides, I'd like to add (or exclude) employees and change (new and old ones) between groups everytime that it's needed, recording the date of modifications (because it has impact on productivity measures presented at Power BI) - and add or exclude groups as well.
Those data from employees are in an excel sheet with name, date of arrive in the company, sector, e-mail, etc.
Where to start? Has anyone faced this challenge before?