Problem Sorting(Order By) D365 FnO List Item Present in the Record

Like (0) Share

Report

Posted on 24 Mar 2020 19:14:24 by Sumeet

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

All responses (4)

Answers (1)

Sumeet 16 on 25 Mar 2020 at 11:15:46

Like (0)

Report

Re: Problem Sorting(Order By) D365 FnO List Item Present in the Record

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
Verified answer

v-alzhan-msft on 25 Mar 2020 at 02:35:46

Like (2)

Report
Re: Problem Sorting(Order By) D365 FnO List Item Present in the Record

Hi @Sumeet ,

Could you please take a try to get the record with workflow definition language as my screenshot below:

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.
Sumeet 16 on 24 Mar 2020 at 20:20:15

Like (0)

Report

Re: Problem Sorting(Order By) D365 FnO List Item Present in the Record

Yes, I am. Only difference is i am using D365 fin & Ops Connector here to list the item present in table.
efialttes 14,756 on 24 Mar 2020 at 19:31:34

Like (0)

Report

Re: Problem Sorting(Order By) D365 FnO List Item Present in the Record

Hi!
Did you follow recommendations from this post?
https://technologyblog.rsmus.com/microsoft-dynamics/dynamics-365-customer-engagement/filtering-dynamics-365-ce-fields-in-flowcmpidblogtmc-ms-dynamics-1219d01/

Hope this helps

Community site session details

Problem Sorting(Order By) D365 FnO List Item Present in the Record

Helpful resources

News and Announcements

Quick Links

Announcing the Engage with the Community forum!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Warren Belz – Community Spotlight

Leaderboard > Power Automate - Building Flows

Featured topics

Product updates

Community site session details

Problem Sorting(Order By) D365 FnO List Item Present in the Record

Helpful resources

News and Announcements

Quick Links

Announcing the Engage with the Community forum!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Warren Belz – Community Spotlight

Subscribe to this forum!

Select categories

Leaderboard > Power Automate - Building Flows

Featured topics

Product updates