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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Add a row into a table...
Power Automate
Unanswered

Add a row into a table action puts new item at bottom of table

(0) ShareShare
ReportReport
Posted on by 18

Excel table is sorted new to old items so new items show at top. The Flow adds them on the last line so file has to be resorted. Is there a way to force it to add new items at the top (seems doubtful) or another action that will resort?

Categories:
I have the same question (0)
  • Rhiassuring Profile Picture
    8,690 Moderator on at

    Hi there, 

     

    You can add your row and then use an Office Script (via Power Automate, there's an action for it) to re-sort the table. 

    Here's a post that tells you how to do it alphabetically...

    https://exceloffthegrid.com/office-scripts-sort-sheets-alphabetically/

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
trice602 Profile Picture

trice602 398 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 323 Super User 2025 Season 2

#3
Expiscornovus Profile Picture

Expiscornovus 183 Most Valuable Professional

Last 30 days Overall leaderboard