Hello There,
I'm trying to create a power app for a club, I've got the start up working fine, I can create and view users, I can also create and view events for the users, but now I want to give the users responsibilities.
The problem here is that each user can have multiple responsibilities and the responsibilities can have multiple users, so I created an intermediate table in which I wrote the ID (mail) of the user and the ID (name of the responsibility).
The problem now is that I want to display all the responsibilities of the user I have selected in a gallery.
So that we all understand what the others mean, I would have named and created the tables as follows for examples:
- User
with columns: Name, First name, Mail(id)
- UserToResponsibilities
with columns: Person_fs(mail from user), Responsibilities_fs(name of responsibility).
- Responsibilities
with columns: Responsibilities_id
I also have a Main_Gallery in which I select the user and display his stuff.
What I have already tried:
Search(UserToResponsibilities;Main_Gallery.Selected.Mail; "Person_fs").Responsibilities_fs
This works, but if someone is new and has no responsibilities yet, everything is displayed for them.
Filter(Responsibilities;Responsibilities_id=LookUp(UserToResponsibilities;Person_fs=Main_Gallery.Selected.Mail;Responsibilities_fs))
This doesn't work because I only ever get the first responsibility back here, as the LookUp only returns the first one.
Thank you in advance for your help.
Translated with www.DeepL.com/Translator (free version), so there could be some missunderstandings.
