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
Solved! Go to Solution.
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.
Check out the new Process Advisor community forum board!
Check out new user group experience and if you are a leader please create your group
On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks