Unanswered

Need help with taking data from power apps, getting user data from Microsoft 365, then populating data in a SharePoint list

(3) Share

Report

Posted on by khos1

I have an app I am trying to build in power apps and one function I want is to take an employee's email from a power app form as well as a couple dates(acquired and expiration dates of a new certification) and find their employee profile/info through Microsoft 365 then take the needed data from both the power apps form and 365 profile and populating a SharePoint list with that data.

Any tips or suggestions would be greatly appreciated. Thank you.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

KeithAtherton 3,707 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @khos1,

Try the following approach:

In the Power App, add a Text Input control to allow input of the employee's email address. Another option would be to add a Combo Box control and set the data source to the Users table to allow the user to select it from a list.

Get the employee's profile by adding the Office 365 Users connector to the app and call the Get user profile (V2) method: https://learn.microsoft.com/en-us/connectors/office365users/#get-user-profile-(v2)

Save the data to a SharePoint list by adding the SharePoint connector to the app and calling the Create item method: https://learn.microsoft.com/en-us/connectors/sharepointonline/#create-item

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Connect with me online.

Was this reply helpful? Yes No
NN-31071626-0 4 on at

Like (0)

Report
Copy link

Link copied!

You can start with a Canvas app, and use the Office 365 connector to get profile data.
https://learn.microsoft.com/en-us/power-apps/maker/canvas-apps/connections/connection-office365-users#use-the-connection-in-your-app

Was this reply helpful? Yes No