Answered

How to add serial number in text property of label in gallery ?

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi All,

I have a gallery in which I have added labels to display list item. text property of each label, I am using ThisItem.ColumnName. This is working fine and data is showing correctly in the gallery. Now I have added another label called "labelSerialNumber' to show the serial number like 1,2,3. On text property of 'labelSerialNumber' = varCountRow . In all rows it's showing 0 which I have set the value in the variable. Please help to resolve this issue.

On button click below code:-

Set(varCountRow,0);
ClearCollect(colSPListItemsAB,(Filter(collectionHSRH,
Created >= datePickerFromAB.SelectedDate || IsBlank(datePickerFromAB.SelectedDate),
Created <= datePickerToAB.SelectedDate || IsBlank(datePickerToAB.SelectedDate),
Status.Value = ddlStatus.Selected.Value || IsBlank(ddlStatus.Selected.Value)
))
);

ForAll(
Sequence(CountRows(colSPListItemsAB)),
varCountRow = varCountRow +1;
);

Thank you so much !!

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

NandiniBhagya20 4,667 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous,
Try using below formula -
ClearCollect(colSPListItemsAB, Filter(collectionHSRH,
Created >= datePickerFromAB.SelectedDate || IsBlank(datePickerFromAB.SelectedDate),
Created <= datePickerToAB.SelectedDate || IsBlank(datePickerToAB.SelectedDate),
Status.Value = ddlStatus.Selected.Value || IsBlank(ddlStatus.Selected.Value)
));
Clear(colTemp);
ForAll(colSPListItemsAB As Data, Collect(colTemp,Last(FirstN(AddColumns(colSPListItemsAB,"SerialNumber",
CountRows(colTemp)+1), CountRows(colTemp)+1)) ))

Use colTemp in Items property of your Gallery

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous ,

In ForAll function, you are setting the value of the varCountRow variable instead of setting the value of the Text property of the label. you can use the following formula to set the value of the 'labelSerialNumber' label ->
Text(varCountRow + 1)

Try this one -
Set(varCountRow, 0); ClearCollect(colSPListItemsAB, Filter(collectionHSRH, Created >= datePickerFromAB.SelectedDate || IsBlank(datePickerFromAB.SelectedDate), Created <= datePickerToAB.SelectedDate || IsBlank(datePickerToAB.SelectedDate), Status.Value = ddlStatus.Selected.Value || IsBlank(ddlStatus.Selected.Value) )); ForAll(colSPListItemsAB, Set(varCountRow, varCountRow + 1) );

Let me know if this helps
Thanks 😀

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @NandiniBhagya20 ,
Thank you. two thing needs to set.
1. colTemp in Items property of Gallery
2. ThisItem.SerialNumber in the text property of label.

Was this reply helpful? Yes No