web

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

News and Announcements icon

Power Platform CommunityForums Power Automate How to substr value an...

Power Automate

Answered

How to substr value and add next number

(0) Share

Report

Report

Posted on by Palucci12

I have such an initialized variable

I would like to, after fulfilling some condition, cut off 001 and add another number, i.e. 002, after releasing another flow, so that Revision003 would be created and so on.I wanted to add something like this in Compose, but it shows me that exxpresion is not valid. Where am I doing wrong?

concat('Revision', int(substring(variables('Revision'), 8, 3)) + 1)

Categories:

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

Rhiassuring 8,692 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Hi there,

Try this instead:

concat('Revision',concat(substring('000',1,sub(3,length(string(add(int(substring(variables('Revision'),8,3)),1))))),string(add(int(substring(variables('Revision'),8,3)),1))))

To break this down and make it a bit easier to read, you could instead try adding another variable, "NewRevision", with this formula:

string(add(int(substring(variables('Revision'),8,3)),1))

And then your compose would be:

concat('Revision',concat(substring('000',1,sub(3,length(variables('NewRevision')))),variables('NewRevision')))

A wee bit cleaner, but, always fun to try and get it into one line 🙂

Cheers,

R

Was this reply helpful? Yes No

Join the conversation