cancel
Showing results for 
Search instead for 
Did you mean: 

Join the discussion

Most Recent
Rahman1005
Advocate II
Advocate II

In this post, we’ll work with a SharePoint List using The SharePoint Send HTTP Request action in Power Automate

we will see the most used methods, such as GET, POST, PATCH, and DELETE.

To access SharePoint resources using REST, construct a RESTful HTTP request by using the OData standard.

Method – Get

URL – https://{site_url}/_api/lists/getbytitle('{list_name}')/items

Accept – "application/json;odata=verbose"

 

  • Log in to the flow portal with your Office 365 credentials.
  • For this article, I have created a SharePoint List. Please find its schema below.

Rahman1005_1-1707380582694.png

 

  • Go to https://make.powerapps.com/, then click on "New Flow," choose "Automated cloud flow," provide a flow name, and select "when an item is created." Please consult the screenshot below for reference.

Rahman1005_2-1707380582696.png

 

 

Rahman1005_3-1707380582701.png

 

 

  • Following Next, we must choose the site address and then select the list.

Rahman1005_4-1707380582702.png

 

  • Click on New Step and choose an operation pane, search for "Send an HTTP Request" under actions and select it.

In this window, please select the options as shown below.

  • Site Address: Choose your SharePoint Site.
  • Method: GET
  • Uri: _api/web/lists/getbytitle('List Name')/items.
  • Headers: As per business requirements.
  • Body: JSON body as per business requirements.

 

Rahman1005_5-1707380582703.png

 

  • Execute a GET request and check for any issues.

Rahman1005_6-1707380582705.png

 

 

Once GET request is executed, we need to do parse the response.

Take the result from preview step and generated JSON schema in Parse JSON.

Rahman1005_7-1707380582706.png

 

 

The response body, which is in JSON format, we need to use apply to each action get a result from the previous step, and then we use Compose Action to get a specific result.

 

Rahman1005_8-1707380582707.png

 

 

When we trigger the flow and see the result. Flow will get each item and display the Full Name, Email, and Employee Id as shown below.

 

Rahman1005_9-1707380582709.png

 

 

Rahman1005_10-1707380582710.png

 

 

Thank you..!

DaveBurrell
Resolver I
Resolver I

I had the pleasure of presenting at the UK’s and possibly Europe’s largest free business applications community event – Scottish Summit 2020! The event had over 1000 attended descend on Glasgow for a fantastic day of networking and learning.

 

I chose to present Power Automate and how to adopt it within your organization quickly.

 

Enjoy and Happy Automating!

Read more...

nagaraja2026
Advocate IV
Advocate IV

Power Automate/Flow enables you to share them with your colleagues either by adding them as co-owners or run-only users (for manual flows only).

 

Not only individual users, we can add office 365 groups also as co-owners to a power automate.

 

image.png

 

 

 

Read more...

nagaraja2026
Advocate IV
Advocate IV

Have you ever thought of terminating power automate/flow if condition is not met?

Recently I have come across this scenario and I used ‘Terminate’ control to achieve this.

image.png

 

Read more...

nagaraja2026
Advocate IV
Advocate IV

As part of 2019 release wave 2,Microsoft has recently announced that Change Set feature has been added to the Power Automate designer so that users can replace classic Common Data Service workflows that previously needed atomic transactions.

 

image.png

Read more...

MattWeston365
Memorable Member
Memorable Member

Trigger Conditions in Power Automate were a great addition released in mid-2019. They are designed to stop your Flow (Automation) from running if the conditions are not met. But what is the easiest way to ensure that my condition is going work? Read to find out...

Read more...

ZePowerDiver
Most Valuable Professional
Most Valuable Professional

In this article, you will learn the details of how I've managed to work around some of the current restrictions that don't allow some integrations of Power Automate flows in a Power Apps canvas app.

I've recently added a Solution package in the Power Apps Gallery for a sample License Plate Reader.

Since the Power Automate flow uses AI Builder's text recognition Predict action, it requires to be in a solution (since it's part of the CDS - Current environment connector). From that point on, the Canvas app that I use to capture the image to be analyzed cannot run that flow, because it's a known limitation that Canvas app triggered flows are not available in solutions.

That is why I've used a CDS entity and related trigger as a workaround to process the image via a flow and then display the result back in the app.

Get the know-how by reading on!

Read more...

nagaraja2026
Advocate IV
Advocate IV

What is Degree of Parallelism ?

The number of loop iterations that can run at the same time, or in parallel.

Degree of Parallelism in Power Automate?

Lets take a scenario of updating child records on update of parent record. One of the most used controls is ‘Apply Each’ which is used to process a list of items.

image.png

 

Read more...

sharonsumner
Advocate II
Advocate II

A little while ago I wrote an article about To-Do, it’s had a massive response so I thought I'd follow up and delve a little deeper into the current Power Automate (formerly Flow) relationship that is there today and where I see this going.

Read more...

siddharth_v
Advocate III
Advocate III

In this article series we will learn what the available SharePoint based Triggers for Microsoft Flow are. This is part 2 of the article.

Read more...

siddharth_v
Advocate III
Advocate III

In this article series, we will learn what the available SharePoint based triggers for Microsoft Flow are. This is part 1 of the series.

Read more...

yashag2255
Super User
Super User

In this blog, I will show how to create a flow that can be used as a service. We will create a customer request management service using Flow, SharePoint and a Web app. A user can create a new request through the page by entering the details and upload an attachment. A unique code is generated once the request is processed and the customer can track their request by entering this code and their email address.

Read more...

MattWeston365
Memorable Member
Memorable Member

On the 1st October 2019, the licensing model around Microsoft Flow changed. I'll help you understand the changes in this article! 

Read more...

yashag2255
Super User
Super User

In this article, I will show you how to setup the flow configuration to delete files older than ‘X’ days from OneDrive. This looks like an easy task by simply listing the entire folder and set a condition to check the modified date and delete the older files. The catch here is, the List Folder action on OneDrive gets you 20 items only. There is no way (pagination settings are not working either) to get more than 20 items.

Read more...

yashag2255
Super User
Super User

In this article, I will highlight 10 interesting flow hacks/ workarounds that might help you in building your flows. This article is inspired by a couple of questions that I have been repetitively seeing on the community forums. Being documented at one place, it could be a good cheat sheet for all levels of users (beginners/ mid/ pros) while building flows.

Read more...

siddharth_v
Advocate III
Advocate III

In this article, we will see to learn about output of action based on different configuration options selected/entered. For this scenario, I just created a sample MS Flow to trigger it manually.

Read more...

pladavm
Helper V
Helper V

The Common Data Model has a lot of benefits for Small Business Owners. However Small Business Owners do not have the time to "reinvent the wheel" when it comes to establishing apps, data relationships and automations which Microsoft Common Data Service would require.  As a result Small Business Owners are forced to choose from marketplace of already established Apps. Luckily Microsoft Flow can provide the benefits of both worlds but enabling a Common Data Model approach to existing Apps in the marketplace.

Read more...

yashag2255
Super User
Super User

In this post, I will show you how to detect duplicate records/ items in Dynamics 365 CRM/ CDS/ SharePoint, delete the record/ item and send a list of deleted records/ items as an email attachment. We will look at finding duplicate entries based on specific fields/ columns (specific values on these fields/ columns), deleting those and sending an email with the list of deleted records/ items.

Read more...

MattWeston365
Memorable Member
Memorable Member

How much time do you spend recreating actions and triggers within Flow? Prepare to see that time slashed!

Read more...

melihubb
Advocate IV
Advocate IV

Are you just getting into using Microsoft Flow and need a thorough overview of the product and what it offers?
Are you feeling behind with all of the many updates Microsoft Flow has undergone?
Are you struggling to come up with use cases to get your organization excited about business process automation?
If so, you need to check out this webinar recording featuring Flow experts Jon Levesque, Melissa Hubbard, and Hunter Willis.

Read more...

melihubb
Advocate IV
Advocate IV

Check out the recording and Q&A from the webinar "The Four M's of Microsoft Flow" with speakers Audrie Gordon and Melissa Hubbard! Watch demos and learn best practices that will ensure successful, efficient, and performant Flows in your organization.

Read more...

frederikbisback
Kudo Commander
Kudo Commander

Because of my background as System Engineer and now Azure administrator. I have created an example thats combining Microsoft Flow with Azure Log Analytics and Powerapps. Creating an alert dashboard in Power App, has never been easier.

Read more...

frederikbisback
Kudo Commander
Kudo Commander

Losing time with checking the timesheet of your employees one by one. With this Flow, you have more time doing something else!

Read more...

frederikbisback
Kudo Commander
Kudo Commander

Get notified about #callforspreakers Twitter messages and don't miss any request for speakers. Get notifications about Twitter messages including some hashtags, then searching on Twitter for them.

Read more...

Karan_MSFT
Power Automate
Power Automate

Learn how to build flows for approvals that take over 30 days to complete

Read more...

GabrielStJohn
Community Champion
Community Champion

In this article, you'll see how I have used Microsoft Flow to stay on top of some important Twitter info by utilizing the Twitter connector and then sending myself a digest email on Twitter content!

Read more...

melihubb
Advocate IV
Advocate IV

Did you ever create an awesome flow only to realize you could not get it to stop triggering? If so, don't worry it wasn't just you. This is called the infinite loop and it is a pretty common mistake flow makers deal with when building flows. Read more about the infinite loop and how to avoid it here! 

Read more...

ThatAPIGuy
Memorable Member
Memorable Member

We are all surrounded by different smart home devices and voice assistants around us. Wouldn't it be great if we could use them to -

Read the blog post to learn more.

Read more...

Jay-Encodian
Community Champion
Community Champion

We've been helping lots of folk recently to build Flow's which extract SharePoint list item attachments and perform some form of processing, typically to convert to a single PDF document and share with a third party, or add to a records repository.

The following tutorial is built around a very simple scenario but should serve as a good guide for:

  • How to extract ‘X’ number of SharePoint list item attachments and process
  • How to use Flow variables to iteratively build a JSON array
  • How to merge 'X' number of documents (any format) into a single PDF document
  • How to dynamically create a HTML fragment and insert into a PDF document
Read more...

GabrielStJohn
Community Champion
Community Champion

One Size Fits All? Not when it comes to IT.One Size Fits All? Not when it comes to IT.We’ve worked with a select group of Microsoft MVPs to put together a new blog series covering the biggest industry talking points and tribulations. The below article comes straight from MVP and Triad Senior Consultant, Pieter Veenstra. Before you get started, we’d like to extend our gratitude to you, our tech community members, for your ongoing insights. Keep feeding back to our MVPs and keep checking back on our Tech Implementer homepage to stay up to date with the latest news and developments. Over to Pieter.

Read more...

Helpful resources

About the Author
  • Experienced Consultant with a demonstrated history of working in the information technology and services industry. Skilled in Office 365, Azure, SharePoint Online, PowerShell, Nintex, K2, SharePoint Designer workflow automation, PowerApps, Microsoft Flow, PowerShell, Active Directory, Operating Systems, Networking, and JavaScript. Strong consulting professional with a Bachelor of Engineering (B.E.) focused in Information Technology from Mumbai University.
  • I am a Microsoft Business Applications MVP and a Senior Manager at EY. I am a technology enthusiast and problem solver. I work/speak/blog/Vlog on Microsoft technology, including Office 365, Power Apps, Power Automate, SharePoint, and Teams Etc. I am helping global clients on Power Platform adoption and empowering them with Power Platform possibilities, capabilities, and easiness. I am a leader of the Houston Power Platform User Group and Power Automate community superuser. I love traveling , exploring new places, and meeting people from different cultures.
  • Read more about me and my achievements at: https://ganeshsanapblogs.wordpress.com/about MCT | SharePoint, Microsoft 365 and Power Platform Consultant | Contributor on SharePoint StackExchange, MSFT Techcommunity
  • Encodian Owner / Founder - Ex Microsoft Consulting Services - Architect / Developer - 20 years in SharePoint - PowerPlatform Fan
  • Founder of SKILLFUL SARDINE, a company focused on productivity and the Power Platform. You can find me on LinkedIn: https://linkedin.com/in/manueltgomes and twitter http://twitter.com/manueltgomes. I also write at https://www.manueltgomes.com, so if you want some Power Automate, SharePoint or Power Apps content I'm your guy 🙂
  • I am the Owner/Principal Architect at Don't Pa..Panic Consulting. I've been working in the information technology industry for over 30 years, and have played key roles in several enterprise SharePoint architectural design review, Intranet deployment, application development, and migration projects. I've been a Microsoft Most Valuable Professional (MVP) 15 consecutive years and am also a Microsoft Certified SharePoint Masters (MCSM) since 2013.
  • Big fan of Power Platform technologies and implemented many solutions.
  • Passionate #Programmer #SharePoint #SPFx #M365 #Power Platform| Microsoft MVP | SharePoint StackOverflow, Github, PnP contributor
  • Web site – https://kamdaryash.wordpress.com Youtube channel - https://www.youtube.com/channel/UCM149rFkLNgerSvgDVeYTZQ/
Join Blog
Interested in blogging for the community? Let us know.