web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Excel Failed to Displa...
Power Automate
Unanswered

Excel Failed to Display Sorted Rows as Parsed

(0) ShareShare
ReportReport
Posted on by 16

I fetched a list of sorted records with "Sort By' via FecthXML query.

SysAdmSG_2-1716192715379.png

SysAdmSG_0-1716192993861.png

 

During the Excel step of "Add a row into a table", the data rows were added sequentially to the expected sorted sequence.
(earliest 'Departure Date added first)
SysAdmSG_3-1716196990644.png
SysAdmSG_5-1716197122238.png
SysAdmSG_7-1716197184186.png

However, it is when the user received the Excel in an email, the records were of different sequence.
(Departure Date not in sequence) - should be 21, 23, and 25
SysAdmSG_4-1716197050781.png


May I know how can I sort the rows in the Excel via "traveldate" field/"Departure Date" column?

Categories:
  • Srini007 Profile Picture
    3,490 Super User 2026 Season 1 on at

    Hi @SysAdmSG 

     

    Can you try as per the link

     

    https://community.dynamics.com/forums/thread/details/?threadid=e22ad1ae-815f-4cc5-8f45-b48f9f96a84b

     

    If you find this reply helpful, please consider giving it a LIKE AND

    If this reply answers your question or solves your issue, please ACCEPT AS SOLUTION

     

    Cheers,

    Srini

  • SysAdmSG Profile Picture
    16 on at

    Hi @Srini007,

    Thank you for your suggestion.

    The issue I am facing is specifically to how Excel displayed the created records.

    In my Power Automate flow, during the Excel step of "Add a row into a table", the data rows were added sequentially to the expected sorted sequence.
    (earliest 'Departure Date added first)

    SysAdmSG_3-1716196990644.png

    SysAdmSG_5-1716197122238.png

    SysAdmSG_7-1716197184186.png

     

     

    However, it is when the user received the Excel in an email, the records were of different sequence compared to when they were added in the above step.
    (Departure Date not in sequence) - should display 21, 23, followed by 25

    SysAdmSG_4-1716197050781.png

  • SysAdmSG Profile Picture
    16 on at

    Bumps.
    Is there any solution or workaround to this issue with Power Automate?

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Automate

#1
11manish Profile Picture

11manish 315 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 267

#3
Henil Profile Picture

Henil 115

Last 30 days Overall leaderboard