web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Flow to parse Smartshe...
Power Automate
Unanswered

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

(0) ShareShare
ReportReport
Posted on by

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:

ria12_0-1639033997841.png

 

This works okay when all fields have data in them. When blank the flow fails and throws the following error:

ria12_1-1639034042408.png

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:
I have the same question (0)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 462 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 456 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard