Answered

Count Rows in Gallery

(0) Share

Report

Posted on by Natido

I have a text box to show the number of items in a gallery and I used the formula Text(CountRows(Gallery.AllItems)). The problem is that the value in the text box does not update. I have refreshed my dataset multiple times but it is not changing. What might be wrong?

Thanks.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

Marshal_Jerome 88 on at

Like (1)

Report

Hi @Natido
To show the value in the Text Input you need to reset the text input and change the default property of the text input.
The below example counts all items in a gallery and display the total count in text box.

1. Count all items and store it in a variable and reset your text input
Set(TotalCount,CountRows(Gallery2.AllItems));
Reset(TextInput1);
2. On Defaut property of the text input paste the below code
TotalCount

Was this reply helpful? Yes No
Gus81live 71 on at

Like (0)

Report

If your datsource is updated, should work with just:

CountRows(Gallery2.AllItems)

Try setting a temporary button with onselect:

refresh(Gallery)

To try it out.

Was this reply helpful? Yes No
Marshal_Jerome 88 on at

Like (0)

Report

@Natido
Please accept the solution if the suggested solution is working.

Was this reply helpful? Yes No
Natido 11 on at

Like (0)

Report

@Marshal_Jerome your solution works but I did not get exactly what I needed. With power apps, it looks like you will not get the actual count once the gallery exceeds a 100 rows I found this post by Matthew Devaney that gave more insight: https://www.matthewdevaney.com/count-the-rows-in-a-power-apps-gallery-with-allitemscount/

Was this reply helpful? Yes No