Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Answered

If empty...

(0) ShareShare
ReportReport
Posted on by 802

Hi, 

 

Basic one but stumping me at this early hour. 

 

I want this expression to be.... if this column value is blank/empty, input my email address, else (so its not empty), put the value from this column value.... what am I doing wrong?

 

if(empty(outputs('Update_a_row')?['body/cr350_submittedintotoolbyemail']), "my email", outputs('Update_a_row')?['body/cr350_submittedintotoolbyemail'])

 

Thanks

K.

  • Verified answer
    Sundeep_Malik Profile Picture
    6,480 on at
    Re: If empty...

    @Kosenurm 

     

    Just check again. The mistake you have done is at my email. It should have single quotes around it not double quotes. So, try this:

     

     

    if(empty(outputs('Update_a_row')?['body/cr350_submittedintotoolbyemail']), 'my email', outputs('Update_a_row')?['body/cr350_submittedintotoolbyemail'])

     

  • Sundeep_Malik Profile Picture
    6,480 on at
    Re: If empty...

    Hey @Kosenurm 

     

    I was stuck in a similar scenario some days back. I tested a few things, and probably for you the following expression might work:

     

    if(conatins(outputs('Update_a_row')?['body/cr350_submittedintotoolbyemail'],''), "my email", outputs('Update_a_row')?['body/cr350_submittedintotoolbyemail'])

    Above they are empty single quotes: ''

    Not really sure, if the above fails, instead of those empty single quotes, you can try passing null too. Hopefully it will work. My scenario was a little different than yours.

  • grantjenkins Profile Picture
    11,059 Super User 2025 Season 1 on at
    Re: If empty...

    It looks fine to me - assuming you're using single quotes for the email.

     

    What is the error you're getting? Do you have some sample JSON you could provide?

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

Michael Gernaey – Community Spotlight

We are honored to recognize Michael Gernaey as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 566 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 516 Super User 2025 Season 1

#3
stampcoin Profile Picture

stampcoin 492