cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
trishmalloy
Post Partisan
Post Partisan

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

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 :

 

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
Post Partisan
Post Partisan

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

View solution in original post

6 REPLIES 6
AlanPs1
Resident Rockstar
Resident Rockstar

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

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?

@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
Post Partisan
Post Partisan

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

View solution in original post

Anonymous
Not applicable

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

AlanPs1
Resident Rockstar
Resident Rockstar

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
MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MSFTBizAppsLaunchEvent

Experience what’s next for Power Virtual Agents

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

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Top Solution Authors
Users online (28,580)