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 OData query operations in SharePoint REST requests
For orderby:
"
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.
"
Regards,
Alice Zhang
User | Count |
---|---|
38 | |
35 | |
15 | |
13 | |
11 |
User | Count |
---|---|
23 | |
20 | |
18 | |
13 | |
13 |