cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Walker
Level: Powered On

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.

2 REPLIES 2
Super User
Super User

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:
https://docs.microsoft.com/en-us/flow/guided-learning/

 

Regards,

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 Team
Community Support Team

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, https://contoso.sharepoint.com/sites/sitename) 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:

https://powerusers.microsoft.com/t5/Microsoft-Flow-Community-Blog/Update-a-secondary-SharePoint-list...

 

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

The "Get items" action of SharePoint connector

 

Best regards,

Kris

 

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

Announcements
firstImage

New & Improved Power Automate Community Cookbook

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

thirdimage

Power Automate Community User Group Member Badge

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

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors (Last 30 Days)
Users online (6,255)