
Hi there
I'm using Power Automate to automate a Yammer post with Smart Sheet content.
I have to initialize each column name as a variable, and then I can call the row field data associated with it to parse it to a Yammer message.
It works perfectly, using the initalize variable function with a trigger body expression except when the field in question is empty.
This is the setup I'm using:
This works okay when all fields have data in them. When blank the flow fails and throws the following error:
I can't use a condition to check if the variable is blank because the variable needs to be initialized to do this, and it's failing at the initialize step.
Can anyone help here? I feel like this should be an easy fix but it's not obvious (to me, anyway!)
Thanks,
Victoria