web

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

News and Announcements icon

Power Platform CommunityForums Power Automate Use of If in substring...

Power Automate

Answered

Use of If in substring expression in MS flow- The expression is invalid

(0) Share

Report

Report

Posted on by viveka

12

Hi all,

I'm having following issue.

If the length of the message is > 220, get the first 220 characters else show the existing message.

But it says following expression is invalid 😞

if(length(outputs('Compose_3')) greater 220, substring(outputs('Compose_3'),0,220),outputs('Compose_3'))

Can anyone tell me how to write the above expresison correctly?

Thank you

Categories:

I have the same question (0)

All responses Img

All responses (4)

Answers Img

Answers (1)

Verified answer

Pstork1 68,717 Most Valuable Professional on at

Like (3)

Report
You have to write the Greater than as a function.

if(greater(length(outputs('Compose_3')),220),substring(outputs('Compose_3'),0,220),outputs('Compose_3'))

Was this reply helpful? Yes No
viveka 12 on at

Like (0)

Report

Thank you so much for the help. It worked 😊🤗

Was this reply helpful? Yes No
WHSBPjM 59 on at

Like (0)

Report

@Pstork1

I have a similar issue where I have 3 types of strings being passed. Do I still use the Greater than function for this scenario where I only want to pull/return the numeric portion of the string?
ABC12345 = 12345
XY56789 = 56789
01234 = 01234

Was this reply helpful? Yes No
Pstork1 68,717 Most Valuable Professional on at

Like (0)

Report

Please post this as a new question. You'll get more responses that way and others will be able to find the answer.

Was this reply helpful? Yes No

Join the conversation