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

list of office 365 users in dropdown

Hi.

I create an app with a first page login. I want user to select his mail using a dropdown list, displaying all office 365 users.

But Office365Users.UserProfile(InfoAbout.Text).Mail is text and not table.

What's is the correct syntaxt for this ?

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Microsoft dinusc
Microsoft

Re: list of office 365 users in dropdown

Even if the password hash was available which would make it possible to have another sheet, I think the user could still have taken the Excel data source and bind it to a Gallery (for example) to see all the content without any restrictions.

I think the best way would be to enforce the security at the server with SharePoint or with a database (SQL Server, MySQL or else).

 

View solution in original post

6 REPLIES 6
Microsoft dinusc
Microsoft

Re: list of office 365 users in dropdown

You can list all the users with the following formula:
Office365Users.SearchUser({searchTerm:"John"}).Mail

or

Office365Users.SearchUser({searchTerm:""}).Mail

JimNoredlac
Level: Powered On

Re: list of office 365 users in dropdown

Thank you: it works! But I realize that office365 password is not in the possibles items. There is not syntaxt for password, even crypted ? Do I need to make my own table of login passwords ?

Microsoft dinusc
Microsoft

Re: list of office 365 users in dropdown

The passwords are not included possibly for security reasons (checked the Office365Users.UserProfileV2()). I'm not sure I understand the need for that field. Are you building an app that would allow the users to change their passwords? I don't think that is supported either.

JimNoredlac
Level: Powered On

Re: list of office 365 users in dropdown

I connected the app to an excel file. One sheet for timesheet of my employees, and one sheet with employees details. Each employees needs to complete each day their timesheet. I would like each employee to complete his own timesheet, and most importantly can't modify others timesheet employees. I imagined employees could log with  office 365 password, and filter data depending of mail or name. But It seems difficult to build an other sheet with username, userId and most of all encrypted passord. In that case, I should protect the excel file...

Highlighted
Microsoft dinusc
Microsoft

Re: list of office 365 users in dropdown

Even if the password hash was available which would make it possible to have another sheet, I think the user could still have taken the Excel data source and bind it to a Gallery (for example) to see all the content without any restrictions.

I think the best way would be to enforce the security at the server with SharePoint or with a database (SQL Server, MySQL or else).

 

View solution in original post

JimNoredlac
Level: Powered On

Re: list of office 365 users in dropdown

I think you're right: I've search everywhere and didn't find any other proposition. I finaly simply add a sheet with login, ID_User, and Password. I've hidden the column and protect sheet with my own password. Thank you very much.

Helpful resources

Announcements
thirdimage

Power Apps Super User Class of 2020

Check it out!

thirdimage

New Badges

Check it out!

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
Users online (4,876)