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?
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)
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?
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.