Unanswered

Order by for SharePoint Get Items

(0) Share

Report

Posted on by jsekuto

Hi All,

I have a flow that moves records from one list to another on a 1 to 1 basis, one is created in List 1 and I want the lowest valued one moved to List 2. The record moved is then deleted from List 1.

I used the Order By functionality as described in the community forum: Syntax for Odata Order By and I return the singular earliest record.

My issue is that the order by is starting at record 100. I still have 99ish records before that that should be moved first.

Order By: Request_x0020_ID asc

Top Count: 1

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

DeepakS 2,301 Most Valuable Professional on at

Like (0)

Report

Re: Order by for SharePoint Get Items

Hi @jsekuto

"Get Items" action by default get only 100 items , so you need to go to the action setting and set threshold to higher number.

Regards,

Was this reply helpful? Yes No
jsekuto 12 on at

Like (0)

Report

Re: Order by for SharePoint Get Items

Your advisement was needed and I implemented to avoid issue later on.

The root issue of my problem was a rookie mistake. My SharePoint field was a string.
Changing it to number allowed the Order By to sort it as a number... oops.

Thanks!

Was this reply helpful? Yes No