cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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!


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
trishmalloy
Level: Powered On

Re: How to Concat 19-Item ID

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

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!


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
trishmalloy
Level: Powered On

Re: How to Concat 19-Item ID

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

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
firstImage

Microsoft Business Applications Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 Release Wave 2 Plan

Power Platform 2019 Release Wave 2 Plan

Features releasing from October 2019 through March 2020

thirdimage

Flow Community User Group Member Badge

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

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 Flow Community Video Gallery!

Top Kudoed Authors
Users Online
Currently online: 184 members 5,566 guests
Please welcome our newest community members: