Answered

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

(0) Share

Report

Posted on 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

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

Sort by

efialttes 14,756 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Sumeet 16 on at

Like
a
(0)

Report
Copy link

Link copied!

Yes, I am. Only difference is i am using D365 fin & Ops Connector here to list the item present in table.

Was this reply helpful? Yes No
Verified answer

v-alzhan-msft Microsoft Employee on at

Like
a
(2)

Report
Copy link

Link copied!
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.

Was this reply helpful? Yes No
Sumeet 16 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No