Good evening,
I have been struggling most of the day with this problem and I getting nowhere!
My flow is using a GET ITEMS action to get all rows for a particular project ID; I have the flow working as I want, except for one thing. I want to sort the rows returned by the GET ITEMS by a field within the row.
The field is a SharePoint LOOKUP type; I cannot work out the correct field name to use.
The error message is:
Error Message
If I remove the OrderBy the JSON output from the GET ITEMS contains the field I want to sort by, see below:
JSON output within an OData OrderBy
How do I reference this field? I tried the field name and appending '/Value' to the field name, but with no luck.
Any help would be much appreciated.
Thank you in advance.
