News and Announcements icon

Power Platform CommunityForums Power Automate - Building Flows Skipping top 300 from ...

Power Automate - Building Flows

Answered

Skipping top 300 from get items

(0) Share

Report

Report

Posted on by zbegumdost

287

hi,

I need to skip first 300 list items with sharepoint get items. is it possible?

Categories:

Business Process Flows

All responses Img

All responses (2)

Answers Img

Answers (1)

Verified answer

zbegumdost 287 on at

Like (1)

Report

Skipping top 300 from get items

@David_MA

hi,

skip(outputs('Get_items')?['body/value'], 300) function is working. thank you for your support. :)
Suggested answer

David_MA 7,550 on at

Like (0)

Report
Skipping top 300 from get items

That should be possible. One question, do you delete items from the list? If not, then just add a filter query where ID gt 300.

If items can be deleted, you'll use a similar filter query, but you will need to calculate the number for the gt condition. To do that:

Add an integer variable and name it FilterValue
Add a Get items action to your list and sort it by ID asc and limit it to returning 300 items
Add a condition and use a length expression to check that 300 items were returned.
If less than 300 items are returned, then no exclusion is required.

This isn't needed if you know your list already has more than 300 items.
Add a Set variable action and set the FilterValue to the value of the 300th item.
This expression should work: int(body('Get_items')?['value'][299]?['ID'])
You can then add another Get items action and filter it to where ID gt FilterValue

I have not tested this, but it should work.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Announcing Mentions and Quick Responses!

Give Back to the Community this Month

Join us in the Community for an AMA: December 12th Register Today

Quick Links

Leaderboard

#1

WarrenBelz 143,532

#2

RandyHayes 76,308

#3

Pstork1 64,050

Leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans