web

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

News and Announcements icon

Power Platform CommunityForums Power Apps How to add incremental...

Power Apps

Answered

How to add incremental id from specific number to existing collection

(0) Share

Report

Report

Posted on by Sakthi1

11

Hi,

I want to add incremental id from specific number to existing collection.

Existing Collection look like below:

ATA	Part Number	Description
0	737-700COCKPIT	737-700COCKPIT
21	0123FA	LOW FLOW DETECTOR
21	0123FA2	LOW FLOW DETECTOR
21	116817-3	DOOR AREA
21	123268-1-1	SUPPLY DUCT CHECK 4 1 2
21	162BL902	CABIN DUCT TEMP DEG FER
21	182820-3	PRIMARY SECONDARY HEAT EX
21	183010-4	WATER-AIR CONDITIONING

I want to add id field starting from 16 not starting from 1

ID	ATA	Part Number	Description
16	0	737-700COCKPIT	737-700COCKPIT
17	21	0123FA	LOW FLOW DETECTOR
18	21	0123FA2	LOW FLOW DETECTOR
19	21	116817-3	DOOR AREA
20	21	123268-1-1	SUPPLY DUCT CHECK 4 1 2
21	21	162BL902	CABIN DUCT TEMP DEG FER
22	21	182820-3	PRIMARY SECONDARY HEAT EX
23	21	183010-4	WATER-AIR CONDITIONING

Any suggestions on how we can achieve this

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (1)

Sort by

Verified answer

WarrenBelz 155,427 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Hi @Sakthi1 ,

Try this

Clear(YourNewCollection); ForAll( Sequence( CountRows(YourCollection) ), Collect( YourNewCollection, Patch( Last( FirstN( YourCollection, Value ) ), {ID: Value + 15} ) ) )

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.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Sakthi1 11 on at

Like (0)

Report
Copy link

Link copied!

Wow! This works perfect.

Was this reply helpful? Yes No
WarrenBelz 155,427 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@Sakthi1 ,

Glad I could help

Was this reply helpful? Yes No

Join the conversation