Category Archives: Technical Stuff

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 do I see current Theme tokens applied to the SharePoint site?

Posted on October 21, 2020 by Pankaj

Problem Sometimes you may want to know what types of Theme tokens applied to the current site. Let’s say you have the following site with the Step By Step Solution It is a simple step, just F12 or Go to … Continue reading →

Posted in SharePoint | Leave a comment

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

How to update People field using ‘Send an HTTP request to SharePoint’ in Power Automate?

Posted on October 12, 2020 by Pankaj

Problem It is not a problem. The question is how to update a people field (single or multiple) in Power Automate using “Send an HTTP request to SharePoint” REST api? To simplify the solution here are three fields in the … Continue reading →

Posted in Power Automate, Uncategorized | 1 Comment

How to update Hyperlink field using ‘Send an HTTP request to SharePoint’ in Power Automate?

Posted on October 12, 2020 by Pankaj

Problem It is not a problem. The question is how to update a hyperlink field in Power Automate using “Send an HTTP request to SharePoint” REST api? To simplify the solution here are two fields in the SharePoint list. Let’s … Continue reading →

Posted in Power Automate, Uncategorized | 2 Comments

How do I insert picture to outlook body message in Power Automate?

Posted on October 8, 2020 by Pankaj

Problem A customer complained that they used the following action to send an email with the image, but the email recipient cannot see an email in the outlook client. Step by Step Solution In summary you cannot send an SRC … Continue reading →

Posted in Power Automate, Uncategorized | Leave a comment

How to auto trigger item modified event on a large list using Power Automate?

Posted on September 17, 2020 by Pankaj

Problem I have a large list (named ‘URL2SiteOwnersEmailList’) and want to run an item modified event to all items using Power Automate. This item modified event can trigger a workflow to do some actions on each item. Step by step … Continue reading →

Posted in Power Automate, Uncategorized | Leave a comment

How to copy multi choice field in Power Automate?

Posted on August 31, 2020 by Pankaj

Problem: I have two lists with the same columns. When I use the Create Item action to copy an item from the Source list to the Target list I am not able to get a multiple choice column to populate … Continue reading →

Posted in Power Automate | 1 Comment