Announcements
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?
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.
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?
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)
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.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Vish WR 873
Valantis 813
Haque 526
