Error when 'Add row into table' if the subject is empty

(1) Share

Report

Posted on by frixel

1,089

Hello,

As you can see, I've already specified in the Subject flow that any = sign in the subject should be omitted, but I'm now getting an error message even if the subject is completely empty.
Is there anything I can do about this?

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

whitebeard 135 on at

Like (0)

Report
Copy link

Link copied!

Hello @frixel,

The error occurs because the replace() function requires a string as its first argument. When the Subject field is empty, it returns a null value instead of a string, which causes the expression to fail.

You can fix this by using the coalesce() function to handle the null value. Coalesce will return the first non-null value, so we can use it to default to an empty string ('') if the Subject is missing.

Try changing your expression to this:

replace(coalesce(item()?['Subject'], ''), '=', '')

This ensures that even if the Subject is empty, the replace function receives a valid empty string and the flow continues without error.

Hope this helps!

1 people found this reply helpful.

Was this reply helpful? Yes No
Suggested answer

chiaraalina 1,921 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi

An empty Subject from the email connector is usually null, not an empty string and replace() does not work on null.

Please try:

replace(coalesce(item()?['Subject'], ''), '=', '')

coalesce(..) turns a null subject into ''

Let me know if it worked!

1 people found this reply helpful.

Was this reply helpful? Yes No
frixel 1,089 on at

Like (1)

Report
Copy link

Link copied!

Thanks @chiaraalina & @iampranjal that is very helpfull

Was this reply helpful? Yes No