Unanswered

Prepending an ID with Text

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi all, I am hoping to get some assistance for prepending an ID for a form. So in my examples, I have a field called Form ID where the formula is:

If(SharePointForm1.Mode = FormMode.New, Last('IRF Center').ID + 1,Parent.Default)

This gets me what I am looking for which is the ID of the last form submitted +1.

Where I need assistance is I want to prepend all of the Form ID's with "IRF-" so instead of returning just the number, it will be "IRF-1", etc. I feel like there should be a concat in there, but have no idea how that would work. Can anyone help me?

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

@Anonymous

Are you looking to prepend the ID for display only, or in your SharePoint list?

If for display only, then you can simply use the Concatenate function Concatenate("IRF-", ID) or a shorter version - "IRF-" & ID

Note in both above, ID is referenced out of context, so whatever leads you to the actual ID is what is needed (ThisItem.ID, Formx.LastSubmit.ID, etc).

HOWEVER...you are messing with the ID of your list. In general this is not something you assign or alter. And, in fact, you will not be able to alter the ID with any prepended text within the actual SharePoint record.

As well, ID is auto-incrementing, so you don't need to determine the next number in order to assign it. It will happen automatically. In general, the ID, if used in a form, should always be display only and not something to edit. Otherwise you will have errors. From a New record perspective - not even worth displaying as it does not exist yet.

If you need some sort of ID'ing process that would have prepended values or other requirements, then I would suggest putting it in its own column apart from the SharePoint record ID.

I hope this is helpful for you.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous how are you progressing with this? Was the above reply helpful?

@Anonymous

Was this reply helpful? Yes No