In this tutorial, we will explore the Contact Action from Outlook 365 connector with PowerAutomate
Excel
- We have an excel file with the following columns:
- Name
- JobTitle
- PhoneNumber
- Department
- Street
- City
- State
- Postal code
- Email addresses
We’ve selected the table set, then clicked on Insert > Table
PowerAutomate
1. Insert Manually trigger a flow in Trigger action
2. Insert List rows present in a table from Outlook Online (Business)
3. Select OneDrive for Business for Location
4. Select OneDrive for Document Library
5. Select your Excel File in File Field
6. Select your Excel Table in Table Field
7. Add a new Action and select Create contact (V2) from Office 365 Outlook connector
8. Set mandatory fields GivenName and Home Phones with the Excel Datas
9. You should obtain the following flow, ready for execution :
10. After excution, go to Outlook > Contact to view newly added contacts :
