Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Suggested answer

Use Power Automate to Add Outlook Email Addresses to an Excel Spreadsheet

Like (1) ShareShare
ReportReport
Posted on 3 Oct 2024 13:08:34 by 8
REVISED
Here is my issue.
I have an Excel spreadsheet that has the following:
Column A - Project ID
Column B - Project Name
Column C - Requesters Name (as it appears in Outlook)
Column D – Need to have Power Automate add the requester’s Outlook email address to this column. 
 
I can have up to 20 rows of data, so I would need to have Power Automate add up to 20 Outlook email addresses. 


Has anyone developed a Power Automate script to perform this process?

Thanks
Mike
 
  • Suggested answer
    Michael E. Gernaey Profile Picture
    42,048 Super User 2025 Season 1 on 03 Oct 2024 at 20:37:52
    Use Power Automate to Add Outlook Email Addresses to an Excel Spreadsheet
    Hi
     
    I am not quite sure what you need help with, you said you have a flow already that you are using Search People?
     
    Flow Trigger Options
     
    1. Manual Flow (because you don't talk about any other way)
    or
    2/3. When a file is created or Modified in SharePoint or one drive (triggers
    or
    4. scheduled flow that runs every 1 day or 1 hour or whatever you want
     
    Those are you 4 options for the Flow Trigger
    Then these steps after the trigger
     
    1. Use a List Rows in Table (your excel must have an Excel Table around the data)
    2. use a condition to verify that the body/value length is greater than 0
    3. In the yes side of the Condition
    --Add an Apply to each with the input being the body/value output from step 2
    --Inside use the Office365Users connector to do a Profile Search using the Name value from the Apply to each loop (current item)
    --add an Update a Row in a Table action to update your Excel row. 
     
    If, you get an error, because the file is actively locked(because yo are looping through) let me know, we can get around that too.
     
    But this is what I would do.
     

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

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Automate - Building Flows

#1
stampcoin Profile Picture

stampcoin 103

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 82 Super User 2025 Season 1

#3
David_MA Profile Picture

David_MA 60 Super User 2025 Season 1

Overall leaderboard
Loading started