[Office Script] Setting object transparency based on list of object names and boolean.

[Rootero]

Hi all, I am somewhat familiar with VBA, but I am new to office script - so please be patient with me.

I am seeking to create an organigram for teams of variable sizes and compositions. I have a table of names and roles, which populate specific elements in the organigram (the structure of which is fixed). However, as the teams are of variable size the tool is meant to remove elements from the organigram which are not in use/vacant. The easiest way to do that is to set transparency to 100. Question: Is there a way for Office Script to go through the list of object names in a table and set the transparency to 0 or 100 depending on a simple boolean parameter? As I cannot wrap my head around how to do this, any help is appreciated.

Thank you very much in advance!

 

[Rootero]

I have put together this code, which does run, but does not make any changes. Please do advise.

function main(workbook: ExcelScript.Workbook) {
    let sheet = workbook.getActiveWorksheet();
   
 // Making a list of transparency values from Column G
    let listRange = sheet.getRange("G1").getEntireColumn().getUsedRange();
    let listValues = listRange.getValues();

    sheet.getShapes()
        .forEach(shape => {
            let shapeName = shape.getName();
            // Find the shape name in Column H and return the transparency value in the same row
            let transparencyValue = listValues.find(row => row[1] === shapeName);
            // if a value is defined, set shape transparency to value
            if (transparencyValue) {
                shape.select();
                shape.getFill().setTransparency(transparencyValue[0]);
            }
        });
}