cancel
Showing results for 
Search instead for 
Did you mean: 
Abisheck_Canary

Adding Contacts in Outlook Using Power Automate

Adding Contacts in Outlook Using Power Automate

Microsoft Power Automate is quickly growing in demand and is currently the highest-adopted automation system in medium-to-large companies. It’s quicker and easier than ever to automate with the new intuitive Power Automate Desktop flow designer using the prebuilt drag-and-drop actions or recording your own desktop flows to run later.  

Introduction

This blog describes how we add contacts to outlook using automation. This BOT helps users to add multiple contact details simultaneously without spending too much time on this. We are uploading contact details from an Excel sheet and saving it in Outlook.

Prerequisites

Before you get started, you need:

1)Power automate Desktop

2) Outlook

3) Excel sheet

 

Flow of the Bot

Abisheck_Canary_0-1649252615136.png

 

Steps Involved in Creating Bot

 

We want to add contact details to Outlook, here I am using an Excel sheet as a tool for giving input. Create an Excel file with columns as required fields to be filled in Outlook. Let us take random names, their company details, their roles and their mail id, you can add as many details needed

Abisheck_Canary_1-1649252640111.png

 

Open Power Automate Desktop => Create a new flow. We can name it “Outlook Contact” and click on create.

Abisheck_Canary_2-1649252658276.png

 

 

  • Our first step is to Launch excel and give the excel document location.

Abisheck_Canary_3-1649252686768.png

 

  • In the next step, we want to read details from the Excel sheet and store it in Exceldata

Abisheck_Canary_4-1649252730585.png

 

 

Below Image shows the details stored in Exceldata

 

 

Abisheck_Canary_5-1649252753563.png

 

 

 

  • After these steps, launch Outlook.
  • We use a condition to loop through each row present in the Exceldata.

 

 

Abisheck_Canary_7-1649252832621.png

 

  • Then in Outlook Select New Items and select Contact

 

Abisheck_Canary_8-1649252878191.png

 

  • In the next step Click on the UI element edit Full Name field

Abisheck_Canary_10-1649252954035.png

 

  • We will populate the text field with our required information.

 

Abisheck_Canary_11-1649252987450.png

 

  • Like the above process, we populate for remaining information to be added, Here I added Company details, job roles, mail-id you can add as many fields needed as we did for these things.

Abisheck_Canary_12-1649253042788.png

 

Press button ‘Save & Close’.

Then close Outlook.

 

 

Run the Flow

 

As we run the bot, it launches excel and reads the data, then it launches outlook, and it adds contacts automatically.

Abisheck_Canary_13-1649253088312.png

 

Output

Open Outlook and in the people option, you can find your added contact details. The below image shows us our added contacts.

 

Abisheck_Canary_14-1649253106328.png

 

Conclusion

 

Thus, we successfully completed our BOT, This BOT helps us to add contacts without any error and it will be a less time-consuming process, also it eliminates our manual intervention.

I hope you found this blog helpful. Please provide your valuable feedback in the comment section.

 

 

 

 

 

 

 

 

 

 

 

 

 

Meet Our Blog Authors
  • Experienced Consultant with a demonstrated history of working in the information technology and services industry. Skilled in Office 365, Azure, SharePoint Online, PowerShell, Nintex, K2, SharePoint Designer workflow automation, PowerApps, Microsoft Flow, PowerShell, Active Directory, Operating Systems, Networking, and JavaScript. Strong consulting professional with a Bachelor of Engineering (B.E.) focused in Information Technology from Mumbai University.
  • I am a Microsoft Business Applications MVP and a Senior Manager at EY. I am a technology enthusiast and problem solver. I work/speak/blog/Vlog on Microsoft technology, including Office 365, Power Apps, Power Automate, SharePoint, and Teams Etc. I am helping global clients on Power Platform adoption and empowering them with Power Platform possibilities, capabilities, and easiness. I am a leader of the Houston Power Platform User Group and Power Automate community superuser. I love traveling , exploring new places, and meeting people from different cultures.
  • Blog site: https://ganeshsanapblogs.wordpress.com/ MCT | SharePoint, Microsoft 365 and Power Platform Consultant | Contributor on SharePoint StackExchange, Techcommunity
  • Encodian Owner / Founder - Ex Microsoft Consulting Services - Architect / Developer - 20 years in SharePoint - PowerPlatform Fan
  • Founder of SKILLFUL SARDINE, a company focused on productivity and the Power Platform. Working on some cool stuff that you're going to enjoy. I also write at https://www.manueltgomes.com, so if you want some Power Automate, SharePoint or Power Apps content I'm your guy 🙂
  • I am the Owner/Principal Architect at Don't Pa..Panic Consulting. I've been working in the information technology industry for over 30 years, and have played key roles in several enterprise SharePoint architectural design review, Intranet deployment, application development, and migration projects. I've been a Microsoft Most Valuable Professional (MVP) 12 consecutive years and am also a Microsoft Certified SharePoint Masters (MCSM) since 2013.
  • Big fan of Power Platform technologies and implemented many solutions.
  • Passionate #Programmer #SharePoint #SPFx #M365 #Power Platform| Microsoft MVP | SharePoint StackOverflow, Github, PnP contributor
  • Web site – https://kamdaryash.wordpress.com Youtube channel - https://www.youtube.com/channel/UCM149rFkLNgerSvgDVeYTZQ/