last record on a gallery

Question

I'd like to display last record value from a gallery.

Gallery is filtered by dropdown.

Using:

Last(Gallery3.AllItems,Quality_score= Dropdown2_2.Selected.Value)

Any ideas?

Thanks.

Where are you adding this formula? In which property of what control? Are you getting any error? What is the data/column type of Quality score column? — Ganesh Sanap - MVP, Oct 16, 2022 at 15:15
Are you facing any problem while using formula in my answer? — Ganesh Sanap - MVP, Oct 20, 2022 at 9:13
Are you facing any problem while using formula in my answer? — Ganesh Sanap - MVP, Oct 20, 2022 at 9:14

AIMEN BOULAHIA · Accepted Answer · 2022-10-17 13:06:59Z

1

If the Gallery is already filtred in the Items Property, you don't have to apply the filter, just apply the following formula :

Last(Gallery3.AllItems)

This will return the last record of the gallery, if you want to get a field you apply this :

Last(Gallery3.AllItems).FieldName

I hope this will answer your question.

answered Oct 17, 2022 at 13:06

AIMEN BOULAHIA

1,2361 gold badge11 silver badges31 bronze badges

Add a comment |

Ganesh Sanap - MVP · Accepted Answer · 2022-10-20 09:14:33Z

1

If you are trying to get the column value from last record in gallery based on dropdown selection, you can use the formula in below format:

Last(Filter(Gallery3.AllItems, Quality_score = Dropdown2_2.Selected.Value)).ColumnName

OR

Last(Gallery3.AllItems).ColumnName

answered Oct 16, 2022 at 15:24

42.9k21 gold badges30 silver badges58 bronze badges

Add a comment |

2 Answers 2