Answered

How to add zeros at the start on Id

(0) Share

Report

Posted on by skd

Hey team,

I was wondering if someone has come across this issue. I have a field in my form called position id which I need to increment from the back end by 1. But my total number should be of 6 digits. For example my incremented id is suppose 501 but I want to Patch it as "000501" to maintain the uniformity. Please suggest me how to write the code to append zeros at the start depending on the number of digits the positionid column has. Also my positionid column is string datatype.

I'm using this formula to get the last position id:

First(Sort(ListName,Positionid,Descending)).PositionId+1

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (1)

Sort by

eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

What you can do is to start the first number with 100000.

That way, increment by one would be ok. Example 100001
First(Sort(ListName,Positionid,Descending)).PositionId+1
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
skd 82 on at

Like
a
(0)

Report
Copy link

Link copied!

Hey @eka24 ,
Actually the PostionId is already a column in my company data and I just have to create a power app for it and they have standard way of writing it with zeros at the start.Therefore pls help me to add the logic accordingly.

Was this reply helpful? Yes No
eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

If they are already in your Datasource then create another column, a calculated column with the formula:
Text(PositionId,"000000")
Or
Right (PositionId&"000000",6)

What is your Datasource, SharePoint or excel.
Try the above
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

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@sayalides,
Do you want to add zeroes to the start of the position id based on the number of the digits?
I have a test on my side, please take a try as below.

Text(Value(Concat(Filter(Split(First(Sort(USER2,PositionId,Descending)).PositionId,""),IsMatch(Result,Digit)),Result)),"[$-en-US]000000")

Note: Please replace the correct parameters with your related column name.
Best Regards,
Qi

Was this reply helpful? Yes No
skd 82 on at

Like
a
(0)

Report
Copy link

Link copied!

Hey @v-qiaqi-msft ,
This is working but I want to patch the incremented value.By this formula I'm getting the last value from my back end of the positionId. I tried to set this value in a variable and then increment it but it as soon as I use this formula in Set function it gives and error saying "You can't use this property to set elsewhere in the app". Please let me know how can I increment the last value and then Push it.

Was this reply helpful? Yes No
skd 82 on at

Like
a
(0)

Report
Copy link

Link copied!

hey @eka24 ,
This is not working.

Was this reply helpful? Yes No
eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

Can you show what you did
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
skd 82 on at

Like
a
(0)

Report
Copy link

Link copied!

Hey @eka24 ,
I got the solution. I used the formula given by @v-qiaqi-msft and I just made a few changes to it and hence got the solution. Thank you so much.

Was this reply helpful? Yes No
skd 82 on at

Like
a
(0)

Report
Copy link

Link copied!

Hey @v-qiaqi-msft ,
Thank you so much. The formula given by you is working I just made a few changes to get the value of PositionId auto-incremented.

Was this reply helpful? Yes No