Unanswered

What does the Flow action "Get Items" do?

(0) Share

Report

Posted on by Walker

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.

All responses (2)

Answers (0)

v-xida-msft on at

Like (2)

Report

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.

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

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-using-Flow/ba-p/38201

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

The "Get items" action of SharePoint connector

Best regards,

Kris
faustocapellanj 1,662 on at

Like (0)

Report

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