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
Highlighted
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
Highlighted
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

socalba
Level: Powered On

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

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
thirdimage

Power Automate Community User Group Member Badge

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

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

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 Kudoed Authors (Last 30 Days)
Users online (4,807)