News and Announcements icon

Power Platform CommunityForums Power Automate - Building Flows Take Right 6 character...

Power Automate - Building Flows

Answered

Take Right 6 characters of a string

(0) Share

Report

Report

Posted on by TesDA

611

For some reason I'm getting an error on this function, does anyone know how to get the right 6 characters of a string?

substring(

triggerOutputs()?['body/{Name}'],

length(triggerOutputs()?['body/{Name}'])-6,

6)

Error - the expression is invalid

All responses Img

All responses (2)

Answers Img

Answers (1)

TesDA 611 on at

Like (0)

Report

Re: Take Right 6 characters of a string

Worked flawlessly. Appreciate it!
Verified answer

ScottShearer 25,228 Most Valuable Professional on at

Like (2)

Report

Re: Take Right 6 characters of a string

@TesDA

You need a sub() expression to subtract the number of characters from the string length.

See my example below:

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Leaderboard > Power Automate

#1

Michael E. Gernaey 497 Super User 2025 Season 1

#2

David_MA 436 Super User 2025 Season 1

#3

Riyaz_riz11 244 Super User 2025 Season 1

Last month Overall leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans