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:
- I have an SPO list as a source;
- 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
