You’re offline. This is a read only version of the page.
Hi,
I am trying to use Order By Clause using List Items Present in the table(D365 Fin & Ops Connecter). All i want is to sort the records in Desc Order.
I tried with FieldName Desc in the Order By Query.However, It is giving me an error. If any one can help or suggest what should i do to fetch the Latest record?
Regards,
Sumeet
Thank you Alice. By making use of Last() and First() solved my query. 🙂
PS: FieldName Asc or Desc still not working. Although fields are present in the Entity. I dont know the why.
Anyways, Thank you again 🙂
Regards,
Sumeet
Hi @Sumeet ,
Could you please take a try to get the record with workflow definition language as my screenshot below:
Share
Report
All responses (
Answers (first(body('Lists_items_present_in_table')?['value'])Or
last(body('Lists_items_present_in_table')?['value'])
Or if you want to filter the record in the list record action, please make sure that the column name is correct and use the asc or desc keyword:
https://powerusers.microsoft.com/t5/Building-Flows/Sytnax-for-Odata-Order-By/td-p/55185
Best regards,
Alice
Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
#1
WarrenBelz
146,731
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
66,079
Most Valuable Professional
