Answered

Auto fill asset tag

(0) Share

Report

Posted on by Winterkid

Dear All,

thank you for reading.

I am having issue whereby on a data fill i am not able to get the fill to auto populated base on the asset tag.

base on the formula, that my Asset_Tag is TAKSG000039 +1 which i believe i am suppose to get TAKSG000040

but somehow the fill for my asset tag will alway appear as 1.
how can i resolve this?

Categories:

Building Power Apps

All responses (11)

Answers (1)

Sort by

Verified answer

WarrenBelz 156,574 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Winterkid ,

TAKSG000039 is Text, not a number, so you cannot add 1 to it (you will get 1). Assuming it will always have five leading letters (this is more complex than you thought . . .)

With( { wNo: With( {wTag: Last(IT_ASSET).Asset_Tag}, Value( Right( wTag, Len(wTag) - 5 ) ) ), wPre: Left( Last(IT_ASSET).Asset_Tag, 5 ) }, wPre & If( wNo < 100, "0000", wNo < 1000, "000", wNo < 10000, "00", wNo < 100000, "0" ) & Text(wNo + 1) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

I have a tutorial on auto increment

https://youtu.be/wsaMirkf3Pc

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

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.
Winterkid 42 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @WarrenBelz
Wow This work, and it way too complicated. Didn't think that it will end up that complicated.
Thank you spending times for coming up with the formulas.
Would it be better if i recreate the list and use the sharepoint ID to tag together with asset tag.
WarrenBelz 156,574 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
@Winterkid ,

A bit less complex - but will skip a number if something is deleted

With( { wNo: ThisItem.ID }, "TAKSG" & If( wNo < 100, "0000", wNo < 1000, "000", wNo < 10000, "00", wNo < 100000, "0" ) & Text(wNo + 1) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
Winterkid 42 on at

Like
a
(0)

Report
Copy link

Link copied!

@WarrenBelz
what about if i were to use the Sharepoint ID columns?
i dont mind redoing the sharepoint list to make it simpler.
WarrenBelz 156,574 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@Winterkid ,

I am using the ID in the example below I posted earlier.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
Winterkid 42 on at

Like
a
(0)

Report
Copy link

Link copied!

ohh sorry my bad.
Winterkid 42 on at

Like
a
(0)

Report
Copy link

Link copied!

hi @WarrenBelz
sorry to trouble you again.
i am confuse now, each time when i click on the Addbutton, it will goes to the add item page.
the asset tag now will only just keep showing TAKSG000001 no matter how many Asset id been use.

also on the sharepoint instead of showing 1,2,3 it show four, five instead of number.
i am confuse if i did wrongly.
WarrenBelz 156,574 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@Winterkid ,

Where did you put the code and exactly (in Text) what did you use? Understand I used ThisItem assuming you knew what this meant - you need the ID of the current item selected.
Winterkid 42 on at

Like
a
(0)

Report
Copy link

Link copied!

it under default,
and i use this,