Unanswered

Repeating Table with list of Office 365 Users

(0) Share

Report

Posted on by CindyZ

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 in advance for your help!

RepeatingTableO36...

Categories:

Building Power Apps

All responses (2)

Answers (0)

Sort by

v-micsh-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
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
CindyZ on at

Like
a
(0)

Report
Copy link

Link copied!

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!