cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
trishmalloy
Level: Powered On

How to Concat 19-Item ID

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.PNGs a r  

 

 

3 ACCEPTED SOLUTIONS

Accepted Solutions
Super User
Super User

Re: How to Concat 19-Item ID

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


Did I answer your question? Mark my post as a solution!

Proud to be a Flownaut!


View solution in original post

Super User
Super User

Re: How to Concat 19-Item ID

@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.

SeeMore1.jpgSeeMore2.jpgSeeMore3.jpgSeeMore4.jpg 

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

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

 

Scott

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott

View solution in original post

trishmalloy
Level: Powered On

Re: How to Concat 19-Item ID

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

View solution in original post

6 REPLIES 6
Super User
Super User

Re: How to Concat 19-Item ID

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


Did I answer your question? Mark my post as a solution!

Proud to be a Flownaut!


View solution in original post

trishmalloy
Level: Powered On

Re: How to Concat 19-Item ID

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?

Super User
Super User

Re: How to Concat 19-Item ID

@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.

SeeMore1.jpgSeeMore2.jpgSeeMore3.jpgSeeMore4.jpg 

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

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

 

Scott

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott

View solution in original post

trishmalloy
Level: Powered On

Re: How to Concat 19-Item ID

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

View solution in original post

Anonymous
Not applicable

Re: Confused on solution for: How to Concat 19-Item ID

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?

PCR # issue.png

Highlighted
Super User
Super User

Re: Confused on solution for: How to Concat 19-Item ID

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

Did I answer your question? Mark my post as a solution!

Proud to be a Flownaut!


Helpful resources

Announcements
firstImage

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

firstImage

Incoming: New and improved badges!

Look out for new contribution recognition badges coming SOON!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Solution Authors
Top Kudoed Authors
Users online (5,576)