Answered

how to use regex on textfield in powerapp to generate a unique ID

(0) Share

Report

Posted on by Community Power Pla...

Hello, I am working on powerapp. I want to generate a unique ID upon clicking on sending order button. I am trying to explore using regex but I have no idea how to implement the code. Can someone teach me how to use regex (regular expression) in powerapp to generate a unique ID?

my current code for ID

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (1)

Verified answer

v-xiaochen-msft on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous ,

You might consider using the GUID function to generate unique IDs efficiently.

Text(GUID())

Best Regards,

Wearsky

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

Like (0)

Report
Copy link

Link copied!

Hi @v-xiaochen-msft
I tried using GUID function but it doesnt work.
I want to create an unique ID with prefix "ABC_" so the sharepoint list data will have ABC_1432 as an example.
May I know how to do so?

Was this reply helpful? Yes No
v-xiaochen-msft on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous ,

Please try:

With(
{OrderID:First(Sort(OrderList,OrderID,Descending)).Value},
"ABC_"&Text(Value(Last(Split(OrderID,"_")).Result)+1,"0000")
)

Best Regards,

Wearsky

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

Like (0)

Report
Copy link

Link copied!

Hi @v-xiaochen-msft

I have modified the code abit.
The error I received after clicking on submit button is The value 'PSA_329378073' cannot be converted to number.

Submit button
May I know how to resolve this? thank you

Was this reply helpful? Yes No
v-xiaochen-msft on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous ,

The point is that the string "PSA_329378073" can not be converted to number...

It's by design.

Best Regards,

Wearsky

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

Like (0)

Report
Copy link

Link copied!

Hi @v-xiaochen-msft
Okay I understand. May I know if there is any way for me to auto generate an ID that contain "PSA_329378073" in powerapps. I need use as reference ID.

Was this reply helpful? Yes No
v-xiaochen-msft on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous ,

Please replace

Value(OrderID)

with

With(
{TheOrderID:First(Sort(OrderList,OrderID,Descending)).Value},
"PSA_"&Text(Value(Last(Split(TheOrderID,"_")).Result)+1,"00")
)

Best Regards,

Wearsky

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

Like (0)

Report
Copy link

Link copied!

Hii, if I replace Value(OrderID) with the following you mentioned, I will have error.
may I know if is it possible to store lbl_Orderid into a variable then use OrderID = newvar in my submit button

Was this reply helpful? Yes No