cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
CindyZ
Level: Powered On

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
Community Support Team
Community Support Team

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.
CindyZ
Level: Powered On

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
thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

SecondImage

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (5,426)