[FEATURE] Configurate Lookup Coloumn with Set-PnPField and set setting "add a coloumn to show each of the addditional fields"

[joshua-probst]

Related to Q&A from @johndpalm: #2042
I am currently creating a PowerShell script that automatically creates 2 lists in SharePoint. The goal is that these 2 lists can be added to every existing SharePoint page. In addition, other things should be customized with the script.

Problem: I want to create a lookup column and use the function "Add a coloumn to show each of the addditional fields".

So far, I have not found a way to set this setting.

What I have found out so far

This value is set at the lookup column that is already configured correctly - done it manual:
DependentLookupInternalNames : {Permission_Level2_x003A_Permission_ID}

So I tried to set the value on a non-configured column with the following command:

Set-PnPField -Identity "Permission_Level1" -Values  @{DependentLookupInternalNames="Permission_Level1_x003A_Permission_ID"}

WARNING: Setting property 'DependentLookupInternalNames' to 'Permission_Level1_x003A_Permission_ID' failed with exception 'Property set method not found.'. Value will be ignored.

Describe the solution you'd like
Is it possible to set the setting with PnP.PowerShell without invoke a template?

[gautamdsheth]

hi @joshua-probst - this is unfortunately not possible due to API limitation.

The DependentLookupInternalNames is a getter only. So, we can't set its values.

Official Link: https://learn.microsoft.com/en-us/previous-versions/office/sharepoint-server/mt827692(v=office.15)