cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dhalpin
Helper III
Helper III

Help using Office365Users

Hello all,

 

After typing a long-winded question, I was able to distill it down.  Please see below the asterisks for further details if you like.

 

I have a collection which contains Office365User information for a sub-set of employees in a column called "OutlookInfo", pulled from a Sharepoint List (type: People).  How can I select people using a dropdown, preferably using DisplayName?  collection.'OutlookInfo'._______________ does not return any auto-complete suggestions.

 

********************************************

I am making a Project Management app for my team.  I would like to allow the user of the app to choose Project Leads from a dropdown menu.  The list of individuals on this list would be very small - maybe 10 people.  Then each Project Lead will have their own dashboard showing projects which have been assigned to them. 

 

Because I was/am confounded by the Office365Users concept, my initial solution was to create a Sharepoint List which is manually populated with the columns "Name" (type: text), and "Outlook Info" (type: Person).  The Outlook Info is not used anywhere else, but I added it to the SP list in the hopes I could leverage that information in the future.  The future is now 😉

 

So, in PowerApps, I have the following for OnVisible:

 

ClearCollect(projectLeads, (Sort('Project Leads',SortingOrder,Ascending)))

 

Then the dropdown pulls from the collection: projectLeads.Name.  That works great for the purpose of the dropdowns, but now I am making the separate dashboards for each Project Lead and I realize I cannot filter by Office365Users.MyProfile().DisplayName because the dropdowns use a manually-entered text field which might be misspelled or otherwise different from the official employee record.  This is my current (non-functional) filter for showing a person's projects on their dashboard's dropdown:

 

Distinct(Filter('Active Project List', 'Project Lead'= Office365Users.MyProfile().DisplayName), 'Collection Name')

 

So, I think my issue could be solved if I could populate the dropdowns with Office365Users.DisplayName (which is contained in the collection, but I don't know how to access nested tables' values). 

21 REPLIES 21

We are getting there!  So when you say, "The plan is (in App #1), that you have a Dropdown with the formula of the Items set to: 'Project Leads'.  You display the column of Name"  That formula would just be = 'Project Leads'.Name  right? 

Using that formula, it seems to display properly in the dropdown, but then patching the project list's Lead column (person type) throws an error.  PA will not allow me to choose 'OutlookInfo' if the formula is Lead:dropdown.Selected.___  I am only given the option to use Name, as displayed in the dropdown.

 

"the type of this argument 'OutlookInfo' does not match the expected type 'Record'.  Found type 'Error'

 

dh

RandyHayes
Super User
Super User

@dhalpin 

As mentioned in my last reply, your formula for the dropdown items should be : 'Project Leads' if you append that with .Name, then you will be stripping out all of the additional information you need (i.e. OutlookInfo) That is why you only see Name as an option.

 

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up below. Solved your problem? - Click on Accept as Solution below. Others seeking the same answers will be happy you did.
NOTE: My normal response times will be Mon to Fri from 1 PM to 10 PM UTC (and lots of other times too!)
Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes

Really want to show your appreciation? Buy Me A Cup Of Coffee!

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (1,930)