Answered

Concat Columns with ID

(0) Share

Report

Posted on by New1

I have a very simple task to create a unique ID by concatenating a CurrentTitle column with '-' and the ID of the item. Only requirement is the ID should be 4 character long so for example if ID is 12 than the unique ID should be CurrentTitle - 0012.

I tried different formulas to update item with no success. Can you please tell me what am i doing wrong in the formulas below ?

concat(triggerOutputs()?['body/CurrentTitle'] , ' - ' , triggerOutputs()?['body/ID'])

This will concat only title- ID but ID is not 4 character.

The other formula I used but it says expression is invalid.

concat(triggerOutputs()?['body/CurrentTitle'], '-', 
    if(length(string(triggerOutputs()?['body/ID'])) = 1, 
        concat('000', string(triggerOutputs()?['body/ID'])), 
        if(length(string(triggerOutputs()?['body/ID'])) = 2, 
            concat('00', string(triggerOutputs()?['body/ID'])), 
            if(length(string(triggerOutputs()?['body/ID'])) = 3, 
                concat('0', string(triggerOutputs()?['body/ID'])), 
                string(triggerOutputs()?['body/ID'])))))

Thank you.

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Anastasia 22 on at

Like (0)

Report
Copy link

Link copied!

Please try the following instead of triggerOutputs()?['body/ID']) :

concat(substring('0000', 0, sub(length('0000'), length(string(triggerOutputs()?['body/ID'])))), string(triggerOutputs()?['body/ID']))

Was this reply helpful? Yes No
Verified answer

Pstork1 69,127 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Try the following:

concat(triggerOutputs()?['body/CurrentTitle'], '-', formatNumber(triggerOutputs()?['body/ID'],'0000'))

Make sure the ID field comes through as an Integer or use a toint() function to convert it before formatting the number.
----------------------------------------------------------------------------------
If this Post helped you, please click "Does this answer your question" and give it a like to help others in the community find the answer too!

Paul Papanek Stork, MVP
Blog: https://www.dontpapanic.com/blog

Was this reply helpful? Yes No