Unanswered

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

(0) Share

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.

I have the same question (0)

All responses (2)

Answers (0)

v-yetonggu-msft on at

Like (0)

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

Hi @rmartori ,

Please try this expression:

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

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No
rmartori on at

Like (0)

Report

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

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.

Was this reply helpful? Yes No