I am not aware of this so i got a little help from ChatGPT.
Here's what i came up with:
To retrieve data such as photos and user principal names of all employees in Office 365 Users in Power Apps, you can use the Office365Users connector. Here's an example of how you can achieve this:
Add the Office365Users connector to your app. To do this, go to the "View" menu in the Power Apps editor, click on "Data sources," and then select "Office365Users" from the list.
To retrieve the user principal names, you can use the following formula:
Office365Users.UserProfileV2().Mail
This formula will return a table containing the user principal names of all employees.
- To retrieve the photos, you can use the following formula:
GUBGMHVpwcTsPFvNNVdG5DKtpv6UwksAfzw5aULcGzgG
This formula will return a table containing the metadata of the user photos.
- If you want to perform a lookup based on a name in the Office365Users connector with your own collection, you can use the LookUp function. For example, if you have a collection called MyCollection and you want to find a user based on their name, you can use the following formula:
LookUp(MyCollection, Name = "John Doe").Email
This formula will return the email address of the user with the name "John Doe" from your collection.
Make sure to replace "MyCollection" with the name of your actual collection and adjust the property names as per your collection structure.
Remember to use the appropriate controls in your Power App, such as galleries or data tables, to display the retrieved data.
If you encounter any specific error messages or issues, please provide more details, and I'll be happy to assist you further.
Mark as solution if this solves your issue. Give thumbs up. Thanks
