How to sort the lines in PDF attached to email order

[ElenaS]

Hello everyone, 

I am building an app for my firm to take orders. I used a template since I have no experience with coding at all. However, I would like to ask for help. 
I need to order the products in the pdf that is attached to the email order confirmation in alphabetic order. The Lage is a storage place where our products are located and I want them to be from first to last. Let´s say from example attached: B-045 ; CA- 0506;CB-1001.  We have rooms in letters B-room, C -room, and numbers as rows.


Thank everyone! 
Looking forward to the solution. 

[Suvrutt_Gurjar]

In place of <,<Start: [Related Order Details]>> please try the below expression

<<Start: ORDERBY([Related Order details], [Product ID].[Lage], FALSE)>>

ORDERBY() - AppSheet Help

[ElenaS]

Thank you! It worked with the large column, but I lost the Product ID (Article ) information...

[Suvrutt_Gurjar · Accepted solution]

I requested to only remove <,<Start: [Related Order Details]>> part.

You still need to retain <<[Product ID].[Product Name]>>

So your entire expression under heading Artikel  will be as follows

<<Start: ORDERBY([Related Order details], [Product ID].[Lage], FALSE)>>

<<[Product ID].[Product Name]>>

[ElenaS]

 Wow !!!!! Thank you so much!! 🙂
Can I ask another question regarding the virtual column or do I need to open another topic?

[Suvrutt_Gurjar]

Good to know it works.

It will be always a good approach to open a new post thread for a new query because it will have attention of many more community members and you will get best solution.