Category Archives: Technical Stuff

How to remove users from multiple Azure AD Groups?

Posted on June 9, 2021 by Pankaj

Summary For my customer there were many Modern Team Sites in the tenant. These sites had 4 to 5 users present in the Owners group. These users were added when the sites were originally created by a automated script. But … Continue reading →

Posted in PnP.PowerShell | 1 Comment

How to create a SharePoint List using Power Automate?

Posted on June 2, 2021 by Pankaj

Summary Many times the application I have built requires the list to be created on a Site. I found in GitHub sample app (by April Dunnam) to create this list(s) using REST call in Power Automate. I will document this … Continue reading →

Posted in Power Automate | Leave a comment

How to get new team creation in MS Teams using MS Graph Notification API?

Posted on April 9, 2021 by Pankaj

Summary A colleague asked me how to get a notification when anyone creates a Team on MS Teams? The answer is pretty simple you would use the MS Graph Notification API. There is an MS Learn session here. What I … Continue reading →

Posted in MS Graph | Leave a comment

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 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

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