- I have a SharePoint List with 174 records in it.
- When I use SharePoint Get Items Action and I don't specify a column to Order by it outputs all 174 records
- 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.
**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?

Report
All responses (
Answers (