Showing results for 
Search instead for 
Did you mean: 
Advocate I
Advocate I

What does the Flow action "Get Items" do?

I'm trying to schedule a weekly export of a sharepoint list, in any format really.


In Flow there is a Sharepoint action called "Get Items" but I'm struggling to find documentation on how this action functions, and where its output goes.


If it does "Get items" what can I do with it next?


Many thanks for any assistance.

Solution Sage
Solution Sage

Re: What does the Flow action "Get Items" do?

Hi @Walker


The "Get items" action retrieves all the items' in a SharePoint list. It gives you all the column, their values and some other information. One approach I normally take to learn what the triggers and actions return, I set up some test Flows, run them and see the outputs. You can then use this information for other things. What those other things are, they're up to you.


I know there aren't too many detailed tutorials, but here's one place to start:



Fausto Capellan, Jr

Fausto Capellan, Jr

Did I answer your question? Mark my post as a solution! Did my response help? Please give it a thumbs up!

Proud to be a Flownaut!

Community Support
Community Support

Re: What does the Flow action "Get Items" do?

Hi @Walker,


The "Get items" action of SharePoint connector would retrieve all items of a specific SharePoint list. Within the "Get items" action, you should specify a Site Address (such as, and a List Name.


In addition, the result that the "Get items" action returns is an array, so you could use a "Apply to each" action to iterate each item of the array.9.JPG

Within the "Apply to each" action, you could obtain all columns(Including System columns and custom columns) and their corresponding values of each item:10.JPG


Please check and see if the following article would help understand the usage of the "Get items" action:


More details about the usage of "Get items" action, please check the following article:

The "Get items" action of SharePoint connector


Best regards,



Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources


Super User Program Update

Three Super User rank tiers have been launched!


Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021


New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!


Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Users online (7,255)