cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sasscocerty
Frequent Visitor

Start inserting new record from the top

I'm inserting new new emails into excel but now my excel have grown to over 500 rows. I would like to dynamically restart from the first row by deleting the old records. Any expression how I can that ?

 

Thanks

 

Sasco

2 REPLIES 2
StalinPonnusamy
Community Champion
Community Champion

Hi @sasscocerty 

 

  1. Remove the item (Old one) and insert new

 

//Remove the item
Remove(ExcelTableName, First(Sort(ExcelTableName,ColumnName,Ascending)));

//Insert the new One
SubmitForm(EditForm)

 

2. We can increase the default limit from 500 to 2000 (Max) if needed

  • Go to File > Settings
  • Click "General"
  • Update "Data row limit" for your desired


Thanks,
Stalin - Learn To Illuminate

StalinPonnusamy
Community Champion
Community Champion

Hi @sasscocerty 


Please let us know if anything needs on your post. We can help with this.

Please mark the post as Solved If I have answered your question.
Please give it a Thumbs Up if you find the suggestion helpful

Thanks,
Stalin - Learn To Illuminate

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (2,580)