Generating Row Number in Gallery

(0) Share

Report

Posted on by firda59

372

Hi,

I want to make a sequence number in my gallery, so people can see sequence of the machine based on list.

I tried this:

Clear(colNumberedMachine);
ForAll('Recap SOW', 
Collect(colNumberedMachine,
Last(FirstN(AddColumns('Recap SOW',
"MachineNumber",
CountRows(colNumberedMachine)+1
), 
CountRows(colNumberedMachine)+1
)
) 
)
)

Source: Power Apps Guide - Formulas - Generating Row Numbers - Power Apps Guide - Blog

But, the label doesn't show the number. Can anyone help me?

Thank you.

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (2)

Sort by

EddieE 4,641 Moderator on at

Like (1)

Report
Copy link

Link copied!

@firda59

I'm not sure how you are using this code by @timl , but it should be set up on a Button, Icon or any On... function eg OnVisible, App OnStart, etc

You can use this code by @mdevaney directly on your gallery, if that is your design need?

Was this reply helpful? Yes No
Verified answer

WarrenBelz 154,966 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hi @firda59 ,

If you use the first part of this blog of mine you will have the column you need.

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

Was this reply helpful? Yes No
firda59 372 on at

Like (0)

Report
Copy link

Link copied!

Hi @EddieE

I write the code in OnVisible, like this:

I want to show the number like 1, 2, 3, etc.

Was this reply helpful? Yes No
firda59 372 on at

Like (0)

Report
Copy link

Link copied!

Hi @WarrenBelz

I put this code OnVisible function:
With(
{
wList:
Filter(
'Recap SOW',
StartsWith('# No. PO', cobacoba.Text))
},
ForAll(
Sequence(CountRows(wList)),
Patch(
Index(
wList,
Value
),
{RowNo: Value}
)
)
)

Then what should I do next? I input RowNo in my label text in Gallery, but error

Was this reply helpful? Yes No
Verified answer

WarrenBelz 154,966 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

@firda59 ,

That is the Items of the Gallery, not the OnVisible code.

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

Was this reply helpful? Yes No
firda59 372 on at

Like (0)

Report
Copy link

Link copied!

@WarrenBelz

Still error,

Was this reply helpful? Yes No
WarrenBelz 154,966 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Please see my amended post. You were too quick

Was this reply helpful? Yes No
firda59 372 on at

Like (0)

Report
Copy link

Link copied!

@WarrenBelz

Done, thankyouuu!

Was this reply helpful? Yes No