Microsoft Dynamics 365 | Integration, Dataverse...

How to Sort in Word Template the Quote Lines of a Quote Alphabetically?

(0) Share

Report

Posted on by CU23100303-0

157

Dear, please, I need to know if there is a way to Sort in the Word Template the Quote Lines of a Quote By Alphabetical Order?

Scenario: I have a Word Template that displays a Quote summary, so in this template I have a table that displays the Products/Quote Lines, but the template always sorts Quote Lines by the Creation Date on which the Quote Lines were included in Quotation, which unfortunately is a native behavior of Dynamics365, however I need to know how do I order Quotation Lines Alphabetically instead of Creation Date?

I noticed that in the Quotation Lines there are the Sequence Number and Line Item Number fields by Dynamics, but even filling them, it does not reflect in the Ordering of the Quotation Lines when the Word Template is generated, it always continues to display the Lines of Quotation by the Creation Order in which they were included in the Quotation.

Does anybody know how to solve this?

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Community Member on at

Like (0)

Report

Hi Dani,

Unfortunately, you can't achieve it.

Note from Microsoft:

Lists in created documents are not in the same order as records

Lists of records created from a custom template may not appear in the same order in Word documents as the order in customer engagement apps. Records are listed in the order of the time and date they were created.

https://docs.microsoft.com/en-us/power-platform/admin/using-word-templates-dynamics-365#lists-in-created-documents-are-not-in-the-same-order-as-records

Scott Durow proposed the idea in the past, but is not picked up by Microsoft.

Microsoft Idea (dynamics.com)

Was this reply helpful? Yes No
CU23100303-0 157 on at

Like (0)

Report

Thank you very much for help. But, do you know one other solution that solve this case with other procedure?

Was this reply helpful? Yes No