web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / SharePoint Get Items r...
Power Automate
Unanswered

SharePoint Get Items returns invalid data set when specifying a field in Order by

(0) ShareShare
ReportReport
Posted on by 108
  1. I have a SharePoint List with 174 records in it.
  2. When I use SharePoint Get Items Action and I don't specify a column to Order by it outputs all 174 records

MsPowerRanger2_0-1640294423927.png

 

  1. However, If I specify to sort by the office column, I end up with 179 records.  Through further analysis, It ends up inserting 6 duplicates and misses inserting 1 record all together.

MsPowerRanger2_1-1640294766776.png

 

**This behavior was simply noted by looking at the OUTPUTS in the Get Items SharePoint action after running the flow.

**I've only noticed the behavior when retrieving all the rows from the SharePoint list. 

**If I use Order By and have a filter on another column (via using Filter Query), the expected records are returned.

Does anyone know if there is a known bug that this is associated with or if there is a workaround?

 

 

Categories:
I have the same question (0)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 304

#2
David_MA Profile Picture

David_MA 245 Super User 2026 Season 1

#3
Expiscornovus Profile Picture

Expiscornovus 243 Most Valuable Professional

Last 30 days Overall leaderboard