I am pulling information from the Smartsheet API and it only returns a value property if a cell has information in the field.
I am parsing it row with an apply to each and checking the cell as follows:
The problem is some of the rows do not have a value property. I am ignoring the error but technically every time my flow runs it returns that the flow failed.
The error message I am getting is below:
InvalidTemplate. Unable to process template language expressions in action 'ExecutiveSponsor' inputs at line '1' and column '2906': 'The template language expression 'variables('trackerRows').cells.value' cannot be evaluated because property 'value' doesn't exist, available properties are 'columnId'. Please see https://aka.ms/logicexpressions for usage details.'.
It seems that you already understand why it's failing, and have a work-around that's allowing you to ignore the failures, so I'm not sure what your exact question is in this post. What are you hoping to accomplish? Would you like the flow to report that it has succeeded instead of failed? Or are you looking for a different way of accomplishing this task?