News and Announcements icon

Power Platform CommunityForums Power Apps - Building Power Apps Sequence not working i...

Power Apps - Building Power Apps

Answered

Sequence not working in collection

(0) Share

Report

Report

Posted on by Kepcla

Hi experts!

I made this:

ClearCollect(sequenceFROM, Sequence(CountRows(MyCollection),0,2));

ClearCollect(Sequence1, Sequence(400,50969200,1));
ClearCollect(MASTERLIST,{FROM: sequenceFROM, Value :Sequence1})

But I get this:

I need to achieve this:

Appreciate a lot your help!!

Categories:

General Questions

All responses Img

All responses (2)

Answers Img

Answers (1)

Kepcla on at

Like (0)

Report

Re: Sequence not working in collection

Hi Warren I appreciate a lot your guidance, it works!!
Verified answer

WarrenBelz 146,547 Most Valuable Professional on at

Like (0)

Report
Re: Sequence not working in collection

Hi @Kepcla ,

The fundamental issue is that you have a different number of items in those two tables, therefore even if you could Ungroup them, they are not going to look like your example. This produces something like your requirement and may give you a start on the direction required.

Clear(MASTERLIST); ForAll( Sequence( 400, 0 ), Collect( MASTERLIST, { FROM: Value * 2, Value: 5096920 + Value } ) )

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.

MVP (Business Applications) Visit my blog Practical Power Apps