Unanswered

Splitting a sharepoint - Get items in two

(0) Share

Report

Posted on by JoshuaAsh

Because of limitations of other functions later in my flow, specifically sql - insert row (V2), I am looking to get the first half of a sharepoint list, and then the second half later if a condition is met

does anyone know how I would best do this?

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (0)

Expiscornovus 33,189 Most Valuable Professional on at

Like (1)

Report

Hi @JoshuaAsh,

A Get Items action has a Top Count property which you can set. That might be useful to get only the first half of the flow:

https://docs.microsoft.com/en-us/connectors/sharepointonline/#get-items

Can you share a link of your setup? I might be able to adapt an example to that.

Was this reply helpful? Yes No
JoshuaAsh 14 on at

Like (1)

Report

Hey thanks for replying
i found a solution where I use a variable to keep track of how many items i retrieve using "length(outputs('get_items_-_loop')?['body/value'])"
and then in the 'get items' function I use a filter query of "ID gt @{variables('total')}" so im only getting entries with an ID value greater than the total received. It will only work with lists with continuous ID values but with some tweaking should work with any list

Was this reply helpful? Yes No