I am building a canvas app where I add lots of information about an event to a list.
One of my questions is who are the participants, their roles as it relates to the event and their manager.
I think I should use a separate list, comprised of people only, that will list each individual, their manager, and their role (planner, visitor, vendor, etc., ). It seems to be a repeating table would be the best approach as there are multiple people for each event. The event name would be the common field between the two tables.
I'd like to both enter the people from the edit screen of my app and show the filtered list of people and their role on the form in a view screen.
I can't seem to find information on how to accomplish this. So, following are my questions.
Can I use the Office 365 Users connection to add multiple people in a repeating table from within my app?
Can I then filter and show those people in my Canvas app? Would that be a gallery?
Does anyone have any input/guidance about how I can go about accomplishing that.
I've attached an image that I hope will help explain.
Thanks so much, Michael! I really appreciate your quick reply.
I was able to replicate what you showed me as far as creating the field/combo box that will return my name from the Office365Users source.
After I pull the name(as you showed me), I need to be able to then fill in a field that will show their role from a drop down I will create and have it automatically fill in their manager in another field. Then write the three pieces of information (name, role and manager) back into my people list.
I dont' know exactly how to answer your first question as I'm quite new to Power Apps (big surprise -- right?) but, hopefully, I've answered it in my explanation.