Hello everyone
I am trying to replicate this tutorial but for Smart Sheet.
https://www.youtube.com/watch?v=ffrDHr8DKF8&t=4s
But is not working for me
The code view is the following
{
"type": "Select",
"inputs": {
"from": "@range(1,length(outputs('Get_a_sheet_data_(dynamic_schema)')?['body/value']))",
"select": {
"ID": "@add(item(),1)",
"primary": "@outputs('Get_a_sheet_data_(dynamic_schema)')?['body/value'][item()]['Primary Column']"
}
},
"runAfter": {
"Get_a_sheet_data_(dynamic_schema)": [
"Succeeded"
]
}
InvalidTemplateThe execution of template action 'Select' failed: The evaluation of 'query' action 'where' expression '{ "ID": "@add(item(),1)", "primary": "@outputs('Get_a_sheet_data_(dynamic_schema)')?['body/value'][item()]['Primary Column']" }' failed: 'The template language expression 'outputs('Get_a_sheet_data_(dynamic_schema)')?['body/value'][item()]['Primary Column']' cannot be evaluated because property 'Primary Column' doesn't exist, available properties are ''
I double check case sensitive and still the error
I made a work around
{
"type": "Select",
"inputs": {
"from": "@range(1,length(outputs('Get_a_sheet_data_(dynamic_schema)')?['body/value']))",
"select": {
"ID": "@add(item(),1)",
"primary": "@items('For_each')?['Primary Column']"
}
}
}
it kinda works, but it repeats the first row of Primary Column every time
any advice I really apreciate it
