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:
ShowColumns(
'User Journeys',
"ID",
"Path",
"StepLabel",
"PreviousSteps",
"Conditions",
"StepType",
"Options",
"ScreenForwarding",
"Variable",
"LookUpFilter",
"UnitOptions",
"Title"
)
[
{
"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"
}
]
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"
}
)
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
Solved! Go to 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"
}
)
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"
}
)
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.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
User | Count |
---|---|
182 | |
52 | |
41 | |
40 | |
34 |
User | Count |
---|---|
251 | |
81 | |
71 | |
66 | |
66 |