Answered

Getting Invalid expression

(1) Share

Report

Posted on by eccountable_dev

Was trying to build a simple cloud flow that looped a few times after reading the name of an account that ended FBO

I am having a problem with getting my code below to be accepted, I keep getting "invalid expression" on the editor and I do not understand why. I was going to use the RIGHT function but that does not seem to be an option, so I came up with what I have below to pull the last three letters so I can check to see if the record has FBO on the end.

substring(body('Get_a_row_by_ID')?['name'],(length(body('Get_a_row_by_ID')?['name'])-3),3)

Below is a picture of my current flow
and an image of my problem

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Nived_Nambiar 18,136 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @eccountable_dev

Try this expression

substring(body('Get_a_row_by_ID')?['name'],sub(length(body('Get_a_row_by_ID')?['name']),3),3)

Also there is no -,+ operator used in expression- have to use add, sub functions instead.

Also if you want to check whether a string ends with FBO- use following expression in condition directly instead of using substring and then comparision

endsWith(body('Get_a_row_by_ID')?['name'],'FBO')

The above expression gives a boolean value whether the string ends with FBO or not 🙂

Thanks & Regards,
Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel
Blog: Nived Nambiar's Blogs

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

Was this reply helpful? Yes No
eccountable_dev 18 on at

Like (0)

Report
Copy link

Link copied!

This helped! Thank you!

Was this reply helpful? Yes No