Showing results for 
Search instead for 
Did you mean: 
Helper II
Helper II

Using ForAll from tabell to write row in excel-tabel and sort


I am writing rows in an excel-tabel using ForAll from an internal tabel. I have sorted the internal tabel but when I using ForAll and Patch to write rows in excel it do not come sorted the way I want it.  It seems like the ForAll change the order.  Is it a way to write row in my excel-tabel from my internal tabel and keep the sortorder?

Kind regards




Super User
Super User

The ForAll() is multi threaded, so it can process multiple records at the same time which means the items that are being loop through can be processed in any order. Why does the excel table need the new records in a certain order? The data from the excel table can be viewed in a gallery or datatable where you can control the sort order.

If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

Hi Jeff,

and thank you for answering.  Why are we using excel?  The reason is that we have built our hole CRM and invoice system with SharePoint List and Poweraps. And in somecase, for example when we want to print a list av all invoices we use excel.   So the app take the objects from SharePoint list with the invoices and write them to excel.  The user can then print the list on paper. In that case it would be nice to have them in invoice number order.   Of cource you can sort and filter the excel-list and works when there are singel object that writen to the tabel in excel, but in some cases it much more complex which make it difficult.  That is the case when we write invoice information to excel transform it to pdf and send it to our customer.         

Kind Regards


Helpful resources

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

Power Apps Community Call

Power Apps Community Call- January

Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST

PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.


Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

Top Solution Authors
Top Kudoed Authors
Users online (3,476)