Category Archives: Power Automate

How to create Site Columns using field schema xml in Power Automate?

Posted on June 16, 2021 by Pankaj

Summary This is a very simple blog to create site column using Schema XML. The Schema XML can be extracted with PnP.PowerShell. First manually create the Site Column on your site. After you are happy with the created fields you … Continue reading →

Posted in Power Automate, Uncategorized | Leave a 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 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 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

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

How to eliminate defining large set of variables in Power Automate?

Posted on October 20, 2020 by Pankaj

Problem Here is the scenario, let’s say that in the workflow you may need large set of variables to hold the data as a variable, and set variable with new values etc. Your first approach is to create a multiple … Continue reading →

Posted in Power Automate | 1 Comment

How to get list of users emails from the SP Group in Power Automate?

Posted on October 15, 2020 by Pankaj

Problem I worked on this on my workflow I want to share, I had few list of SP Groups by the department. e.g. ITApprovers, LegalApprovers, HRApprovers etc. Each SP Group had users in it. For the “Send Approval” action the … Continue reading →

Posted in Power Automate | 1 Comment

How to create Power Automate flow which can be manually triggered?

Posted on October 13, 2020 by Pankaj

Problem It is simple to create a flow for ‘when item created or modified’ triggers. But the customer raise following questions. How to create a Power Automate flow which can be manually triggered? How can end user pass inputs to … Continue reading →

Posted in Power Automate, Uncategorized | Leave a comment