How to validate parameters from Revit against a set of allowed values coming from an Excel

Hi everyone!

I’m a beginner in Dynamo an I’m trying to compare a list of door parameters extracted from Revit with a list of allowed values coming from Excel. Both inputs are structured as lists of lists: each door is a sublist of parameters, and each Excel sublist contains all valid options for that specific parameter index. My goal is simply to check, for each door, whether each parameter value exists in the corresponding Excel sublist at the same index, and return a list of boolean results for all doors. The difficulty is that many native Dynamo nodes don’t reliably align parameter index with the matching Excel sublist when working with nested lists, often comparing the wrong level or the entire Excel structure instead of the sublist. Below is the stage where I stopped:

If anyone knows a node setup or pattern to achieve this alignment and comparison, I would really appreciate some guidance. Thanks!

Hi @isa_pat

Cab you please provide a sample of the excel file structure and Revit file so we can see a bit more clearly what data structure you are working with?

Is the validation structure something like this (sublists 2+3 in the the dataset have intentionally ‘bad’ values when compared against the list of valid values)

Also,

Are the Parameters all the same or can they be different per Family and / or Family Type?
If it is the second. Is there a value in the Excel you can use to ‘map’?
In example a Family or Family Type name?