web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Add if statement to ex...

Power Automate

Answered

Add if statement to expression

(1) Share

Report

Report

Posted on by vipfafen

98

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:

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Suggested answer

David_MA 13,491 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
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,819 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
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

Join the conversation