cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Post Patron
Post Patron

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
Resident Rockstar
Resident Rockstar

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

Highlighted
Super User III
Super User III

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

Highlighted
Post Patron
Post Patron

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
Resident Rockstar
Resident Rockstar

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

Highlighted
Post Patron
Post Patron

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?

Highlighted
Super User III
Super User III

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

Highlighted
Post Patron
Post Patron

Re: How to Concat 19-Item ID

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

View solution in original post

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

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
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Upcoming Events

Experience what’s next for Power Automate

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

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