web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Remove Prefix from Sin...

Power Apps

Answered

Remove Prefix from Single Text Alphanumeric Column, calculate the highest number and add 1

(0) Share

Report

Report

Posted on by Marty3012

Hi,

I am using PowerApps SharePoint Integration and in my List I have a column called 'Request ID';

Request ID

------------

CR30

CR29

CR28

etc

What I would like to do is produce the next incremented ID, in this case 'CR31'. The result 'CR31' would simply be displayed in a text box and then that text box value would be used in a Patch function to populate the Request ID column. I'm having a lot of trouble getting this to work and I've tried the Substitute function along with the Filter function, collections etc, but I'm stumped. I would prefer not to create a calculated column in SP and instead have all the logic in the Power App

Any help appreciated.

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Verified answer

Adrian_Celis 1,652 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hi @Marty3012 ,
Does the Request ID always have the prefix "CR"?
If so, firstly, get the last ref number from your SP List

Set(varLastRequestID,First(Sort(YourSPList,'Request ID',SortOrder.Descending)).'Request ID')

Remove the "CR" and then turn the remaining text into a number, add + 1, then turn it back into text.

"CR" & Value(Substitute(varLastRequestID,"CR",""))+1

Let me know if this works.

Was this reply helpful? Yes No
Marty3012 on at

Like (0)

Report
Copy link

Link copied!

Yes, it works, thanks. Sorry, was working on this over the weekend, hence the delay.

Was this reply helpful? Yes No

Join the conversation