Flow to parse Smartsheet content to Yammer - empty fields causing trouble

(0) Share

Report

Posted on by ria12

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

Categories:

Business Process Flows

I have the same question (0)