Home

Dynamic Arrays and validation lists - How to make dynamic arrays follow a structured table?

%3CLINGO-SUB%20id%3D%22lingo-sub-485516%22%20slang%3D%22en-US%22%3EDynamic%20Arrays%20and%20validation%20lists%20-%20How%20to%20make%20dynamic%20arrays%20follow%20a%20structured%20table%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-485516%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20trying%20to%20create%20a%20table%20where%20a%20given%20field%2Fcolumn%20has%20content%20pulled%20from%20a%20validation%20list%3B%20this%20validation%20list%20is%20based%20off%20a%20dynamic%20array%2C%20which%20is%20returning%20the%20correct%20values.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20essence%3A%3C%2FP%3E%3CP%3E%26nbsp%3B-%20Table%201%3A%20%3CSTRONG%3EClients%3C%2FSTRONG%3E%20(field%20%22ID%23%22%20for%20cross-referencing)%3C%2FP%3E%3CP%3E%26nbsp%3B-%20Table%202%3A%20%3CSTRONG%3EProjects%3C%2FSTRONG%3E%20(with%20manual%20insertion%20of%20Client%20%22ID%23%22%20for%20future%20cross-referencing)%3C%2FP%3E%3CP%3E%26nbsp%3B-%20Table%203%3A%20%3CSTRONG%3EDocuments%3C%2FSTRONG%3E%20(also%20with%26nbsp%3Bmanual%20insertion%20of%20Client%20%22ID%23%22%20for%20future%20cross-referencing)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EEach%20line%20on%20table%203%20(below)%20will%20have%20a%20different%20set%20of%20values%20in%20the%20validation%20list.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20intended%20behavior%2C%20that%20you%20can%20see%20in%20the%20table%20attached%20is%20that%20in%20Table%203%2C%20%22Related%20Project%22%2C%20is%20that%20the%20validation%20list%20made%20available%20will%20offer%20a%20selection%20of%20%3CSTRONG%3EProjects%3C%2FSTRONG%3E%20related%20to%20that%20%3CSTRONG%3EClient%3C%2FSTRONG%3E.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20issue%20I'm%20looking%20for%20help%20with%20is%20on%20how%20to%20make%20the%20dynamic%20arrays%20expand%2Freduce%20dynamically%20with%20the%20%22Documents%22%20table%2C%20so%20that%20the%20end%20user%20doesn't%20have%20to%20manually%20expand%20the%20cells%20where%20the%20dynamic%20arrays%20are%20being%20created.%20I'm%20using%20structured%20tables%20throughout%20and%20it%20would%20be%20nice%20if%20they%20could%20accommodate%20transpose%20spill%20functions%2C%20but%20that's%20not%20the%20case.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-485516%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Adriano Neves
New Contributor

Hi,

 

I'm trying to create a table where a given field/column has content pulled from a validation list; this validation list is based off a dynamic array, which is returning the correct values. 

 

In essence:

 - Table 1: Clients (field "ID#" for cross-referencing)

 - Table 2: Projects (with manual insertion of Client "ID#" for future cross-referencing)

 - Table 3: Documents (also with manual insertion of Client "ID#" for future cross-referencing)

 

Each line on table 3 (below) will have a different set of values in the validation list. 

 

The intended behavior, that you can see in the table attached is that in Table 3, "Related Project", is that the validation list made available will offer a selection of Projects related to that Client

 

The issue I'm looking for help with is on how to make the dynamic arrays expand/reduce dynamically with the "Documents" table, so that the end user doesn't have to manually expand the cells where the dynamic arrays are being created. I'm using structured tables throughout and it would be nice if they could accommodate transpose spill functions, but that's not the case. 

 

Thanks

Related Conversations
InfoPath multiline textbox is not wrapping
sterbella in SharePoint on
0 Replies
Collecting multiple data from different lists
SAROB515 in SharePoint on
0 Replies
Ideas requested
KDavidP1987 in SharePoint on
0 Replies
SharePoint list calculated columns no longer working
P_Mac365 in SharePoint on
0 Replies
sharepoint list suddenly stops syncing
288088 in SharePoint on
2 Replies