Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Answered

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

Like (0) ShareShare
ReportReport
Posted on 24 Mar 2020 19:14:24 by 16

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?PowerAutomateProblem.JPG

 

 

 

Regards,

Sumeet

  • Sumeet Profile Picture
    16 on 25 Mar 2020 at 11:15:46
    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 Profile Picture
    on 25 Mar 2020 at 02:35:46
    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:

    1.png

    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 Profile Picture
    16 on 24 Mar 2020 at 20:20:15
    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 Profile Picture
    14,756 on 24 Mar 2020 at 19:31:34
    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Leaderboard > Power Automate - Building Flows

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 186 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 171 Super User 2025 Season 1

#3
stampcoin Profile Picture

stampcoin 161

Overall leaderboard
Loading started