I am trying to build an event sign up tool. Well, I had a request from leadership that they wanted to have leaders apply to lead project groups, which was fine. I added that with no problem. But now they want to have the same leader for multiple project groups and I don't know how to make this work.
If the second column number is the same then that means the same leader will lead all the events with that number. I don't know if there is a way to hide the toggle buttons if there are duplicates or if I can filter out the duplicate values and only show 1.
Any ideas would be greatly appreciated. My current formula for the gallery is as follows
Filter(ProjectsEventsList_SPList, EventType = "Project",
EventLeaderNeeded = true,
For some reason my picture did not insert into my original post. I have attached a screenshot.
I am not sure how to handle this. Upper management requested to let employees apply to be a leader for an event or project, but some of them want 1 leader for multiple events. I did not build the app originally to handle the process this way. It was supposed to be 1 leader for one event or project.
My workaround was to add column LeaderID with PE-000+ the ID number. Then I duplicated this on any event that was going to have the same leader. That way when my powerautomate ran after the user was approved it would update all those records with the chosen event leader.
Now I don't know the best way to show this in powerapps. Can i filter out all the duplicate ID numbers or can I only have 1 toggle for the first Leader ID column? I am stuck and not sure what to do. Any advice would be welcome