Items do show in preview but not in the gallery

(0) Share

Report

Posted on by wshalex123

160

In this formula, iam grouping a table upon employee id's and sum their holiday entries:

In the preview the results are correct, but it does not display them in my gallery:

left control = Thiitem.cr811_employee & right control = Thisitem.DasIstDieSumme

Woudl appreciate any help.

Thanks a lot

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

mmollet 3,187 on at

Like (0)

Report

Re: Items do show in preview but not in the gallery

When I have done things like this is the past what I will do is make a gallery that holds all the filtered results that I want. That is where you can add rows and columns from wherever you need to. Then I make the gallery invisible and send it to the back of the frame. This is then used to do calculations on. Like you want total a column for example so in your blank where you want that total to be you would simply put:
Text(Sum(GalleryName.AllItems, ColumnToSum),"#0.00")
This would sum the column in the gallery and then format it and display it in the text box.

Was this reply helpful? Yes No
CNT 10,921 Super User 2024 Season 1 on at

Like (0)

Report

Re: Items do show in preview but not in the gallery

@wshalex123 A bit strange. Can you display the same thing in a DataTable and see if it shows up?

Please remember to give a 👍 and accept my solution as it will help others in the future.

Was this reply helpful? Yes No
wshalex123 160 on at

Like (0)

Report

Re: Items do show in preview but not in the gallery

@CNT Nope i already tried it with the data table, also not working there.
@mmollet not working this way with your formula. I have to grou column1 and sum column 2 at the same time. In short, the origin table (Dataverse) looks like this:

Employee1 1h
Employee1 2h
Employee2 2h
Employee3 2h
Employee3 1h

... first i group the employees and sum their hour value afterwards, so the result is:

Employee1 3h
Employee2 2h
Employee3 3h

Was this reply helpful? Yes No
wshalex123 160 on at

Like (0)

Report

Re: Items do show in preview but not in the gallery

I also tried do create a collection first and display it after with this formula:

Also does not display the items in the gallery but shows them in the preview. Can this be because of the datatype and the control maybe?
The column iam working with is a calulcated Decimal:

Was this reply helpful? Yes No