Solved! Go to Solution.
Hi @ paulccook,
If you would like to get sharepoint items in order and the items is sorted by vendor first, and product second.
The workable Sytnax for the order by in the "Get items" action should be:
vendor asc, product asc
I have made a test on my side, the screenshot of my flow as below:
The flow would run successfully as below:
The Sytnax usage is described here:
Use the $orderby query option to specify how to sort the items in your query return set. To sort by multiple fields, specify a comma-separated list of fields. You can also specify whether to sort the items in ascending or descending order by appending the asc or desc keyword to your query.
I had the same issue. Because it seems SharePoint Get Items only gets the top 1000, so I wanted to use Order By to to delete by the oldest, but it never worked. What I had to do was in the Filter Query, I added (PublishedDate lt 'Calculated time'), calculated time just being Substract from time, 60 days before utcNow().
Three Super User rank tiers have been launched!
Features releasing from October 2020 through March 2021
We've updated and improved the layout and uploading format of the Power Automate Cookbook!
Fill out a quick form to claim your user group badge now!