Author Archives: Pankaj

Unknown's avatar

About Pankaj

I am a Developer and my linked profile is https://www.linkedin.com/in/pankajsurti/

How to make SharePoint REST API calls in PowerShell using Add-ins App?

Posted on April 8, 2021 by Pankaj

Summary The following links will guide you to create SharePoint Add-ins App with the required permissions. For security reasons, always have least permission access strategy to provide permissions to your app. Only provide permission access what your app intends to … Continue reading →

Posted in SharePoint | 2 Comments

How to split large string with emails in an array?

Posted on February 5, 2021 by Pankaj

Summary The following was the user requirement. The question was the user had the weird string stored in the Multi People Picker Field. If you look closely at the sample string the “i:0#|membership|” is prefixed before all the emails. The … Continue reading →

Posted in Power Automate | Leave a comment

How to create HTML table for Get Items in Power Automate?

Posted on December 9, 2020 by Pankaj

Summary A question from user is that how to send multiple pending items from a list in an HTML table format. The desired results in email is the following with ID, Title and Clickable link item. Step by Step Solution … Continue reading →

Posted in Uncategorized | 3 Comments

How to develop SPFX using Docker Container?

Posted on December 8, 2020 by Pankaj

Summary Wouldn’t it be nice if you don’t have to install required SPFX tools to do the development? Yes, answer is to use Docker. The Docker provides a container with required software pre installed. To use the container you should … Continue reading →

Posted in Docker | 1 Comment

How to export Data Loss Prevention (DLP) rule package for tenant?

Posted on December 7, 2020 by Pankaj

Summary I looked at the custom DLP config file in XML. This will allow to create Custom DLP rule. But I wanted to see if I can export all existing out of the box rules file in an XML. This … Continue reading →

Posted in DLP | 1 Comment

How to send approval requests to Distributed List (DL) Group in Power Automate

Posted on December 1, 2020 by Pankaj

Problem The Microsoft Flow Approvals connector does not support sending approval requests to groups today or distributed groups. To demonstrate the issue I have a sample distributed list (DL) group ‘SomeO365DLGroup’. The DL group has the following members. Created a … Continue reading →

Posted in Power Automate | 6 Comments

SharePoint HTTP connector: Send a no-reply email in Power Automate Flow

Posted on November 21, 2020 by Pankaj

Problem There are many blog posts for sending no-reply email from Power Automate. The question from the customer is how to create the JSON object body ‘dynamically’ to put in the “SharePoint HTTP connector”? The following is the sample list … Continue reading →

Posted in Power Automate | Leave a comment

How to delete Recoverable Items folder of the mailbox?

Posted on November 18, 2020 by Pankaj

Problem This was a customer requirement, to delete a “Purge” folder using MS Graph API. There was no mention of purge folder when I checked mailFolder resource type documentation. The closest I found was ‘recoverableitemsdeletions’, I did not even know … Continue reading →

Posted in Exchange Online | Leave a comment

Part Two – Using Power Automate show the most recent comment from SharePoint text fields instead of “View Items”

Posted on November 10, 2020 by Pankaj

Problem As my previous blog post on the same topic, what if there is an existing list which has the multi text ‘Comments’ field. How to take the last comment and copy in the ‘MostRecentComments’ field for all items in … Continue reading →

Posted in Power Automate | Leave a comment

Using Power Automate show the most recent comment from SharePoint text fields instead of “View Items”

Posted on November 10, 2020 by Pankaj

Problem The customer asked how to do the steps described in the following article in Power Automate? The article uses SharePoint Designer and SharePoint Workflow. SHOW THE MOST RECENT COMMENT FROM SHAREPOINT TEXT FIELDS INSTEAD OF “VIEW ITEMS” The scenario … Continue reading →

Posted in Power Automate | 4 Comments