SharePoint List Schema and Components

[henkenTech]

Hi all,

hope you are well! I have been sitting over this for hours now and I just cannot understand why this isn't working:

1. I have an SPO list as a source;
2. OnStart() is used to store ShowColumns() for that data source to a collection as follows:

ShowColumns(
        'User Journeys',
        "ID",
        "Path",
        "StepLabel",
        "PreviousSteps",
        "Conditions",
        "StepType",
        "Options",
        "ScreenForwarding",
        "Variable",
        "LookUpFilter",
        "UnitOptions",
        "Title"
    )

• The resulting collection when viewed as a JSON() is:

[
    {
        "Conditions": [
            {
                "Value": "Always"
            }
        ],
        "ID": 2,
        "LookUpFilter": "test",
        "Options": [
            {
                "Id": 3,
                "Value": "Amendment"
            },
            {
                "Id": 7,
                "Value": "Buying"
            }
        ],
        "Path": {
            "Value": "HOME"
        },
        "PreviousSteps": [
            {
                "Id": 1,
                "Value": "HOME: Topic Selection"
            }
        ],
        "ScreenForwarding": {
            "Value": "Home"
        },
        "StepLabel": "HOME: Example",
        "StepType": {
            "Value": "Tiles"
        },
        "Title": "Example",
        "UnitOptions": [
            {
                "Value": "GBP"
            },
            {
                "Value": "USD"
            }
        ],
        "Variable": "test"
    }
]

• I need to load this into a Component as an input variable and to be able to use these fields, I provided the following sample schema in the component advanced settings:

Table(
    {
        Conditions: [
            {
                Value: "Always"
            }
        ],
        ID: 2,
        LookUpFilter: "test",
        Options: [
            {
                Id: 3,
                Value: "Amendment"
            },
            {
                Id: 7,
                Value: "Buying"
            }
        ],
        Path: {
            Value: "HOME"
        },
        PreviousSteps: [
            {
                Id: 1,
                Value: "HOME: Topic Selection"
            }
        ],
        ScreenForwarding: {
            Value: "Home"
        },
        StepLabel: "HOME: Example",
        StepType: {
            Value: "Tiles"
        },
        Title: "Example",
        UnitOptions: [
            {
                Value: "GBP"
            },
            {
                Value: "USD"
            }
        ],
        Variable: "test"
    }
)

• If I now set the collection as the input variable for the component, I get the "not the right record structure" error. When I pass the example schema, it works just fine. 

What am I missing here??! I have tried literally everything. Is there some weird invisible property in collection I cannot see?

Any pointers are greatly appreciated 🙂

Max

[henkenTech · Accepted solution]

I finally found the issue.... [] is not the same as Table(). I had to change the schema kin my component to:

Table(
    {
        Conditions: Table(
            {
                Value: "Always"
            }
        ),
        ID: 2,
        LookUpFilter: "test",
        Options: Table(
            {
                Id: 3,
                Value: "Amendment"
            },
            {
                Id: 7,
                Value: "Buying"
            }
        ),
        Path: {
            Value: "HOME"
        },
        PreviousSteps: Table(
            {
                Id: 1,
                Value: "HOME: Topic Selection"
            }
        ),
        ScreenForwarding: {
            Value: "Home"
        },
        StepLabel: "HOME: Example",
        StepType: {
            Value: "Tiles"
        },
        Title: "Example",
        UnitOptions: Table(
            {
                Value: "GBP"
            },
            {
                Value: "USD"
            }
        ),
        Variable: "test"
    }
)

[Eelman]

@henkenTech 

Try using a variable instead of a collection (even though collections are technically a variable ...)

Set(
    mySchema,
    Mid(
        // change colName to the collection name from your OnStart
        JSON(colName),
        2,
        Len(JSON(colName)) - 2
    )
)
  

Then send the variable mySchema to your component. Haven't tried this myself, just offering a possible solution.