Skip to main content

Notifications

Power Automate - General Discussion
Unanswered

Workforce employee resignation check azureAD upn

(0) ShareShare
ReportReport
Posted on by 7

I have a csv file with workforce email addresses of users.  How can I use that mail address to compare it to AzureAD upn that same user has in Azure?  

  • David_MA Profile Picture
    David_MA 9,039 on at
    Re: Workforce employee resignation check azureAD upn

    I would convert the csv file into an Excel file. You can then use the Excel actions to get the rows from the Excel spreadsheet and process each row through an Apply to each. Here is a demo of how to convert csv to Excel: Convert CSV Files to Excel (xlsx format) in Power Automate (youtube.com)

  • tlarson1 Profile Picture
    tlarson1 7 on at
    Re: Workforce employee resignation check azureAD upn

    I am trying to take the workforce csv upn column, then match it with AzureAD upn, but having a hard time with array and spliting columns, any thoughts?

  • David_MA Profile Picture
    David_MA 9,039 on at
    Re: Workforce employee resignation check azureAD upn

    You can use the Get user profile action and populate it with the e-mail address to get details about the user including their department, location, phone number, e-mail address, their name, whether the account is active, and more. 

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,666

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,996

Leaderboard