You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Add Location field to either one or all of the content types (through the list view add column)
Grab provisioning template
Apply provisioning template to another site collection
Result:
Following error message: Apply-PnPProvisioningTemplate : Column Limit Exceeded. There are too many columns of the specified data type. Please delete some other columns first. Note that some column types like numbers and currency use the same data type.
initial investigation revealed that Location column adds all its sub fields (i.e. City, street, postcode etc.) to the data type and this create abundance of single line of text type fields.
This breaks deployment with the Message above.
The only solution is to delete Location fields entirely from the template and then reapply them manually to each content type (post deployment).
As the location field is really popular and useful for the customers this renders PnP templating not fully useful in the best case (single large deployment), unfeasible at all in case of dynamic deployments.
The text was updated successfully, but these errors were encountered:
Any update or workaround for this issue? I am running into this in Document library list column with Location.
PnP trace shows
[OfficeDevPnP.Core] [0] [Error] ExecuteQuery threw following exception: Microsoft.SharePoint.Client.ServerException: Column Limit Exceeded.
This error is still occurring in 2022 -almost 3 years ago - and still not resolved!
However, my quick test of deleting all of the reference/secondary fields - just leave the main "Location" field reference and it provisions correctly - the other fields seem to be created-on-demand when using the provisioned template.
So just delete ALL FIELDS that have a colon in the DisplayName property. E.g. <Field Type="Text" DisplayName="Destination: Country/Region"
Steps to reproduce:
Result:
Following error message:
Apply-PnPProvisioningTemplate : Column Limit Exceeded. There are too many columns of the specified data type. Please delete some other columns first. Note that some column types like numbers and currency use the same data type.
initial investigation revealed that Location column adds all its sub fields (i.e. City, street, postcode etc.) to the data type and this create abundance of single line of text type fields.
This breaks deployment with the Message above.
The only solution is to delete Location fields entirely from the template and then reapply them manually to each content type (post deployment).
As the location field is really popular and useful for the customers this renders PnP templating not fully useful in the best case (single large deployment), unfeasible at all in case of dynamic deployments.
The text was updated successfully, but these errors were encountered: