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().
Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!
Many congratulations to the Season 1 2021 Flownaut Crew!
Check out our new profile badges recognizing authored solutions!
Check out the community blog page where you can find valuable learning material from community and product team members!