Replacing null values using Compose

(0) Share

Report

Posted on by EMSSS

I have data coming in from SQL Server that has some null values which I want to replace.

In this example I have 3 rows of data, 2 rows have a null value and one has my email address.

The Select step is obtaining this data

Output:

null,

emsss@example.com

Compose 2 step is me trying to replace the null values with the following expression

if(equals(body('Select'), null), 'emsss@example.com', body('Select'))

Output:

null,

emsss@example.com

Compose step is trying to make sure there's no repeats of same value in this case output:

null,

emsss@example.com

What I want to see is just my email and no null values. Ideal output:

emsss@example.com

Can anyone help with this?

Categories:

Building flows

I have the same question (0)

All responses (13)

Answers (0)

Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (0)

Report

Hi @EMSSS

I think you can use filter action in power automate.

Could you show how output from sql looks in power automate, i meant json structure ?

Was this reply helpful? Yes No
EMSSS 15 on at

Like (0)

Report

I'm using SQL Get Rows V2. Connected to my database and table.

Was this reply helpful? Yes No
EMSSS 15 on at

Like (0)

Report

Why doesn't this expression work in replacing null values

if(equals(body('Select'), null), 'emsss@example.com', body('Select'))

Also, I don't want to filter I want to replace!

Was this reply helpful? Yes No
Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (0)

Report

Hi @EMSSS

body('Select') would return output in json format overall which won't be the null overall, so that is why it is not replacing null values

If possible could u show how output values body('Select') look like .

Also do body('Select') is the output of select action, if yes you can replace null value there easily 😊

Was this reply helpful? Yes No
VictorIvanidze 13,073 on at

Like (0)

Report

Show your flow in edit mode.

Was this reply helpful? Yes No
abm abm 32,865 Most Valuable Professional on at

Like (2)

Report

Hi @EMSSS

If your result sets are returned as an array then use the following:

This will return only the values are not null.

Thanks

Was this reply helpful? Yes No
EMSSS 15 on at

Like (1)

Report

Hi,

Thank you for your comment. I would like to replace the null value with my email rather then filter. Any idea on best way of doing this?

Thanks

Was this reply helpful? Yes No
abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi @EMSSS

Not sure what you meant by? Please show a sample of data you getting from your flow run history and explain how you would like to format that data.

Thanks

Was this reply helpful? Yes No
EMSSS 15 on at

Like (0)

Report

Current Example:

null,
null,
emsss@example.com

Desired output example:

emsss@example.com
emsss@example.com
emsss@example.com

I want to replace null values in my array with a string value (my email)

Was this reply helpful? Yes No
VictorIvanidze 13,073 on at

Like (0)

Report

You have been already told:

if(equals(body('Select'), null), 'emsss@example.com', body('Select'))

Was this reply helpful? Yes No