Add if statement to expression

(1) Share

Report

Posted on by vipfafen

Hi all,

I have the following expression that shortens URL links for me. Source is a Sharepoint list:

concat('<a href="', item()?['xxx'], '">xxx</a>')

The expression pulls the URLS from a SharePoint list, converts them into HTML and finaly send it as a report via email.

Unfortunately, "xxx" entries are also made where no URL has been set in the Sharepoint list.
I would like to add an if statement that, if URLs are not set, gives a note such as "please hand in later" as non url, just as non-executable text.

How do I best proceed?

Regards

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Suggested answer

David_MA 12,982 Super User 2025 Season 2 on at

Like (1)

Report
I would do the following if I am understanding what you need correctly:

Add a string variable to your flow and set the default value to "please hand in later".

Add a condition to your flow to check that the URL exists, if it does, on the yes side of the condition, set the variable to your expression.

Then use the variable in your e-mail.

Was this reply helpful? Yes No
Verified answer

Ellis Karim 11,683 Super User 2025 Season 2 on at

Like (1)

Report
Hi vipfafen,

If I have understood correctly, you could try the following expression in a compose action:

if(empty(item()?['xxx']), 'please hand in later', concat('<a href="', item()?['xxx'], '">xxx</a>'))

Here's a demo flow:

Ellis

Ellis Karim's Blog – IT doesn't have to be complicated!

Was this reply helpful? Yes No