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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / change null to blank f...
Power Automate
Answered

change null to blank for choice values

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Hello,

I have a Flow that Gets Items from a SharePoint List and then Selects the items so that it can be placed into a CSV table.

I receive the same type of error when there are blank and null fields within the Select Card, for example this kind of error:

…failed: 'The template language expression 'item()['TestDate']' cannot be evaluated because property 'TestDate' doesn't exist, available properties are '…

I have successfully addressed all of the fields except for Choice Fields.  Does anyone know the proper syntax for choice fields missing a value?

 

This is my Flow:

 

FlowFlow

 

SelectSelect

 

ExpressionsExpressions

The expressions I have tried for the choice field are:

 

if(equals(coalesce(item()?['Development_x0020_Team_x0020_1']['Value'],'NULL'),'NULL'),'',coalesce(item()?['Development_x0020_Team_x0020_1']['Value']))

 

 

If(equals(length(item()?['Development_x0020_Team_x0020_1']['Value']), 1), item()?['Development_x0020_Team_x0020_1']['Value'], '')

 

Thank you,

Joanna

 

  

Categories:
  • Verified answer
    v-yuazh-msft Profile Picture
    Microsoft Employee on at

    Hi @Anonymous,

     

    I have made a test on my side and have created a list with a choice type column TestDate as below:

    Capture.PNG

     

    You could refer to screenshot below to create the flow:

    Capture.PNG

     

    The expression of the TestDate in the Select actin as below:

    if(empty(item()?['TestDate']?['Value']),null,item()?['TestDate']?['Value'])

     

    The flow would run successfully as below:

    Capture.PNG

     

     

     

    Best regards,

    Alice

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    OMG  You are so smart!  It works.  Thank you Thank you

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Any idea for person or group (Single as well as Multi-Select?

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Automate

#1
11manish Profile Picture

11manish 302 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 263

#3
Henil Profile Picture

Henil 115

Last 30 days Overall leaderboard