Answered

Add users form Azure Active Directory to SharePoint List using Power Automate flow

(0) Share

Report

Posted on by Pavel48n0sh

Hi!
Is it possible to add users from Azure Active Directory to SharePoint List using PA Flow?

All this users to list. And write at column Hire Date, date of creating in AAD.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

v-xiaochen-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Pavel48n0sh ,

I made a sample for you.

In my sample, I used the take function to capture the first two users of all users.

https://graph.microsoft.com/v1.0/users?$select=userPrincipalName,createdDateTime

take(outputs('Send_an_HTTP_request')?['body/value'],2)

formatDateTime(items('Apply_to_each')?['createdDateTime'],'yyyy-MM-dd')

concat('i:0#.f|membership|',toLower(items('Apply_to_each')?['userPrincipalName']))

Best Regards,

Wearsky

Was this reply helpful? Yes No
tech-44 39 on at

Like (0)

Report
Copy link

Link copied!

Yes, it is possible to add users from Azure Active Directory to SharePoint List using Power Automate (formerly known as Microsoft Flow). You can use the "Office 365 Users" connector to retrieve user information from Azure Active Directory and then the "SharePoint" connector to add helpful information to a SharePoint List.

Was this reply helpful? Yes No
Samuraiii 5 on at

Like (0)

Report
Copy link

Link copied!

Could you also pull some other information about the users when you get their name and mail from MS Form?
Like their cost center or phone number? Thanks for explanation

Was this reply helpful? Yes No