Skip to main content
BOOK A DEMO

How to handle the lookup columns threshold in a Document Generator template for a single item

skybow Support
  • Article Updated

If your Document Generator template contains more than 12 lookups that exceeds the SharePoint lookup column threshold, you may face the situation that the generated document may not include all lookup values. To overcome this problem we propose the following workaround steps:

In the meantime Variables from Action Builder are supported as well in Document Generation (Solution Studio Update 16.03.2023) which could be used instead of window variables. See Document Generator introduction

1. Add an Execute Script action before the Generate Document action to set values for all lookups you need in the global variables and then use it in the template:

lokkupthreshold2.png

lokkupthreshold1.png

window.dgLookups = {
"Lookup1": [[Lookup1.Value]],
"Lookup2": [[Lookup2.Value]],
....
"LookupN": [[LookupN.Value]]
};

2. Use these variables in the template. Your lookup placeholders in the Generate document template should look like this:

[[=window.dgLookups.Lookup1]]

3. If needed, you can clean up the variables after the document is generated using the Execute Script action after the Generate Document action.

An example can be found here. Simply import these .json files in the Action Builder using the Export/Import button in the upper right corner: 

Related articles