web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Need help adding an ex...

Power Automate

Unanswered

Need help adding an expression to fill empty slots with "Unknown"

(0) Share

Report

Report

Posted on by rmartori

Hello So I added a compose funtion to my bot to look through the JobName column and check for empty cells. If it finds and empty cell it fills it with "unknown/notlisted" and if it doesnt it just uses what it does find. The expression I am using is.
if(empty(triggerBody()?['JobName']), 'Unknown/Not Listed', triggerBody()?['JobName'])

The problem is it fills all cells with "unknown/not listed" not just empty ones.

Categories:

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

v-yetonggu-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @rmartori ,

Please try this expression:

if(empty(triggerBody()?['JobName']),null,triggerBody()?['JobName'])

Best Regards,

Sunshine Gu
rmartori on at

Like
a
(0)

Report
Copy link

Link copied!

Sadly that just made both test emails empty, I dont know why but it is treating a non-empty cell as if it was empty and replacing it with either null with your expression or 'Unknown/Not Listed' with mine.

Join the conversation