web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Batch upload employee ...
Power Automate
Unanswered

Batch upload employee email address

(1) ShareShare
ReportReport
Posted on by 576
I'm using the method here https://www.bing.com/ck/a?!&&p=a7ffd0d9fc91f70fJmltdHM9MTcyMjU1NjgwMCZpZ3VpZD0wMTUyOGEyNy0wMTEzLTY3NDEtMzg2My05OTY4MDAzYTY2ZjYmaW5zaWQ9NTUzMw&ptn=3&ver=2&hsh=3&fclid=01528a27-0113-6741-3863-9968003a66f6&psq=batch+upload+rows+to+sharepoint+power+automate&u=a1aHR0cHM6Ly93d3cucHJvY2Vzcy5zdC9ob3ctdG8vdXBsb2FkLWEtZmlsZS10by1zaGFyZXBvaW50LXVzaW5nLXBvd2VyLWF1dG9tYXRlLyM6fjp0ZXh0PUhvdyUyMHRvJTIwU2V0JTIwVXAlMjBQb3dlciUyMEF1dG9tYXRlJTIwdG8lMjBVcGxvYWQsU3RlcCUyMDUlM0ElMjBUZXN0JTIwYW5kJTIwU2F2ZSUyMHRoZSUyMEZsb3clMjA&ntb=1  to batch upload records into SharePoint.  My problem is that the SharePoint list has a column for email address but the source excel file doesn't have email. I want to use either 'send an http request' or 'search for users' to locate the employee address based on a text field that has the name as it appears in AD. Then I want to include the email address in the batch update. Can anyone advise on how to do that?
Categories:
I have the same question (0)
  • Suggested answer
    Michael E. Gernaey Profile Picture
    52,972 Super User 2025 Season 2 on at
    Batch upload employee email address
    Hi,
     
    1) You would have to take the bulk records
    2) use an apply to each
    3) in there, use the Get User Profile V2, by filtering on the Name (which you can do in the Action)
    4) it will return that persons Profile Information, where you can grab the email
     
    I am not going to read that link, but you will need to have an Array (or Object) that you would update with the Email Address from #3, for each user.
     
    Not hard at all. Long as the data you have is in a format that you can loop through and then have another Array that has the data you submit to the API.
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 462 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 456 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard