Answered

How to either return the value of a colum or return a specific text if empty?

(0) Share

Report

Posted on by Rob_CTL

Hi,

I have a simple Flow that pulls together a number of colums from a SharePoint list and puts them into a HTML table which gets emailed. The issue I am hitting is one of these columns is a "choice" column and if the a user creates an item and doesn't select a choice from the list the Flow fails because the column doesn't contain anything.

What I am trying to achieve is if the column contains a value then that value is written to the HTML table, or if there is no value the Flow updates the HTML table with "Not Set" text.

Any help gratefully received.

Rob

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

I've come across null values myself lately. They can be frustrating. You can always check for a null value in a column with this formula to check for empty value: @empty(triggerBody()?['Name_Column/Variable']

To acheive what you want to do you need an if formula that checks if the column is empty. If the column is empty (evaluates to true) you can use a replace function. If the condition evaluates to false you do nothing.

Formula (I didn't fully test this, but can you try this)?

if(@empty(triggerBody()?['Name_Column/Variable'],replace(['Name_Column/Variable'],'Not Set'),'')

Was this reply helpful? Yes No
Verified answer

v-yuazh-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Rob_CTL,

I have made a test on my side and have create a "status" column with type "choice" in the sharepoint list.

The screenshot of the sharepoint list as below:

You could refer to screenshot below to create the flow:

Th expression for the status column as below:

if(empty(item()?['status']?['Value']),'Not Set',item()?['status']?['Value'])

The flow would run successsfully as below:

Best regards,

Alice

Was this reply helpful? Yes No
Rob_CTL on at

Like (0)

Report
Copy link

Link copied!

Thanks @v-yuazh-msft and @Anonymous for the help, that worked perfectly!

Was this reply helpful? Yes No