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']))
Thank you Scott, I just finished up for leave but I will try this as soon as I am back on my laptop
Take a look at this post as I believe it will answer your question. Let me know if you need more help.