cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper V
Helper V

Repeating Table with list of Office 365 Users

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. 

 

  1. Can I use the Office 365 Users connection to add multiple people in a repeating table from within my app? 
  2. 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 in advance for your help! 

 

 

 

2 REPLIES 2
Highlighted
Community Support
Community Support

Re: Repeating Table with list of Office 365 Users

Could you please explain a bit for which control that you would like to have the Office 365 user selected?

 

To display the filtered results, a gallery or a data table is needed.

 

For Office365 User selection, please take a try with the steps below and see if that would help:

Under View->Data Sources->Choose Office 365 Users, add it into current App,

Insert a Combo Box control, under the items property, enter the following:

Office365Users.SearchUser({searchTerm:ComboBox1.SearchText})

Then for the other property:

DisplayFields: ["DisplayName"]
SearchFields:["Mail"]
SelectMultiple: false

After that, configure the Gallery control items property to:

Filter (EventTable, UserEmail=ComboBox.Selected.Mail)

which then would be able to show all the Events for the current selected user.

 

Regards,

Michael

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Helper V
Helper V

Re: Repeating Table with list of Office 365 Users

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. 

 

Thanks again...already a learning!  

 

 

Helpful resources

Announcements
secondImage

Demo-Extravaganza 2020

Check out these cool Power Apps & vote on your favorite!

secondImage

Robotic Process Automation

Let's talk about the solution provided by Microsoft for Robotic Process Automation (RPA)

secondImage

Community Highlights

Check out whats happening in Power Apps

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

Top Solution Authors
Top Kudoed Authors
Users online (10,973)