How to Concat 19-Item ID

(0) Share

Report

Posted on by trishmalloy

415

Hello,

I want to build a flow that updates a "Number" field with a default value of 19- with the current Item ID e.g. 19-156, 19-157, 19-158, see flow attached.

Concat 19 with Item ID.PNG s a r

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (3)

Verified answer

AlanPs1 2,471 on at

Like (2)

Report
Hi @trishmalloy , thank you for your post.

You should need the below expression:

concat('19-', <ID of item>)

so, it should be more like:

concat('19-', item('When_an_item_is_created'))

But please double check the syntax of "ID of item"

If you have found my post helpful, please mark thumbs up.

Any other questions, just ask.

Thanks, Alan

Was this reply helpful? Yes No
trishmalloy 415 on at

Like (0)

Report

The problem is, I am unable to find/use the 'ID' field listed under Dynamic Content for the Number field. It's only available to use for the actual ID column. So when I use concat('19-, ID'), it shows up just like that after I've added a new item instead of 19-156, it's not pulling the number from the ID field. Using the concat function may not be the way to resolve this. @ScottShearer -maybe you can help?

Was this reply helpful? Yes No
Verified answer

ScottShearer 25,270 Most Valuable Professional on at

Like (3)

Report

@trishmalloy :

I believe your issue is that you need to click on "see more" at the top of the "When a new item is created section in Dynamic properties. The ID is exposed after you click on "see more". I tested this and it works properly in my Flow.

If this addresses your issue, please mark your post as Solved.

If you like my response, please give it a Thumbs Up.

Scott

Was this reply helpful? Yes No
Verified answer

trishmalloy 415 on at

Like (0)

Report

Ugh. Can't believe I missed that. Thank you!

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi @AlanPs1 - this issue is the same as mine - I need to have a unique PCR # assigned to each new list item, but I'm a bit confused on how to implement - where am I supposed to use the concat expression? I thought I needed to use Initialize Variable, then Increment Variable, but I don't see that in the screen shots for this issue. This is all I have for now, can you please help me?

Was this reply helpful? Yes No
AlanPs1 2,471 on at

Like (1)

Report

Hi Socalba.

Please a new thread. Reference this one and detail your issue and either I or another will reply. This will help you get a quicker response.

Best wishes.

Alan

Was this reply helpful? Yes No