Skip to main content

Posts

Showing posts from May, 2018

Copy Outlook data to SharePoint online List using Powershell

I want to copy an outlook email data into a SharePoint online list. To achieve this, we can use CSOM /Power shell. Here I am showing to copy outlook data to SharePoint List using Power shell. Step 1 : Create a SharePoint List and columns(Question-Multi line text , CretaedBy - People Picker). Step 2 : Download and install the below tools. 1.SharePoint Online Management shell - https://www.microsoft.com/en-in/download/details.aspx?id=42038 2. Exchange Web service- EWS API is found at: http://www.microsoft.com/en-us/download/details.aspx?id=28952 Step 3 : Open your Windows Powershell ISE and run the follwing script. #---Outlook mail box name, Username, password and domain ---# $MailboxName = "AllHandsQuestions@ftech.com" $LoginId="venkat.m"; $Password='P@ssw0rd'; $Domain='FTech'; #---Log file location ---# $downloadDirectory = "C:\OutlookLogs_Test\" $currentDate = Get-Date -UFormat "%Y%m%d" $Logfile =...

Get User Profile data in SharePoint Designer 2013 Workflow

SharePoint Designer 2010 supported out of box activity to access user profile fields. However, User Profile service option is not present in SharePoint 2013 Designer workflows. In SharePoint 2013 workflow type ,we do not have any Lookup Manager for User activity. For this, SharePoint 2013 workflow you will need to use the Call HTTP Web Service activity, with the following end point URL. http://siteurl/_api/SP.UserProfiles.PeopleManager/GetUserProfilePropertyFor(accountName=@v,propertyName='Manager')?@v='i:0%23.f|membership|venkat@technologies.com ' Follow the below steps to get manager: Step 1 : Activate site level feature - Workflows can use app permissions. 1.  Go to Site Settings and click Manage site features under Site Actions. 2. Activate feature Workflows can use app permissions. Step 2 : App Permission – To ensure that workflow can access user profiles. 1.  Go to Site Settings and click Site app per...