web

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

News and Announcements icon

Power Platform CommunityForums Power Apps How to split record Id...

Power Apps

Answered

How to split record Id number and increment when press button

(0) Share

Report

Report

Posted on by Community Power Pla... Microsoft Employee

Hi All,

I wana split and increment my number in every click of button.

Suppose ID=RRN0121, when I click button ,it increment like this , RRN0121.01,RRN0121.02 .....and so on

how we achieve this , I tried with split but not success

Thanks,

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (1)

Sort by

rubin_boer 4,843 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

hi @Chitrakant27

Your question is not compltely understood, here is a way to increment a variable.

UpdateContext({_number: _number + 1})

UpdateContext({ someVariable: ID & "." & _number})

Result

Having the ID you do not need to split it. Can you give more information on your use case, will you be saving the incremented value etc.?

Hope it helps,

R

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

Like
a
(0)

Report
Copy link

Link copied!

Hi @rubin_boer ,

I am using same but it will increment like RRN0126.1, RRN0126.2and so on
I need RRN0126.01,RRN0126.02,RRN0126.03.....

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Chitrakant27,

Do you want to increase the RRN by 0.01 once you click the button?

Here is a simple demo for your reference:

1). Create a variable as below to extract the number within, note I display this RRN number within a TextInput:

Set(varID,Value(Substitute(TextInput9.Text,"RRN","")))

I usually put this formula on the OnVisible property of the current screen.

2). Format the RRN number by the concatenate() function as below:

Concatenate("RRN",Text(varID,"0000.00"))

Was this reply helpful? Yes No

Join the conversation