Skip to main content

Notifications

Power Automate - General Discussion
Unanswered

Concat with character limit

(0) ShareShare
ReportReport
Posted on by 289

Hi Team,

I am trying to create a reference number comprising of several columns Prefix + Year + Sharepoint ID. 

The Prefix will always be 1 character in length, the year will always be 2 characters in length. I need the Sharepoint ID to be 4 characters in length by padding with 0s. Such as R210016

Here is my current expression, I need to edit it to only take the right 4 characters from the SharepointID. The ref should be 7 characters length in total

concat(outputs('Calculate_Prefix'),outputs('Calculate_Year'),'000',string(triggerOutputs()?['body/ID']))

 
  • JimJim Profile Picture
    JimJim 289 on at
    Re: Concat with character limit

    Thank you Scott, I just finished up for leave but I will try this as soon as I am back on my laptop

  • ScottShearer Profile Picture
    ScottShearer 25,150 on at
    Re: Concat with character limit

    @JimJim 

    Take a look at this post as I believe it will answer your question.  Let me know if you need more help.

     

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,422

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,711

Leaderboard