Show maximum value of a list when a gallery item is selected.

(0) Share

Report

Posted on by angeldiaz96

Hello community,

Could you help me with that.

I'm trying to create an app that works like internal auctions,

I have 2 SharePoint lists as a database: 1. contains the article information and the other 2. is where the offers they make will be. (attach).

using a gallery that shows the items and an edit form that would enter the offers in the SP OFERTAS.

I would like the (VALOR ACTUAL) field to reflect the highest value offered, I am not sure how to do it or what the best option would be. Could you help me with any ideas?

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

Verified answer

v-bofeng-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @angeldiaz96 ,

If you wish to obtain all corresponding items from the list 'Ofertas' for the selected item in the gallery and retrieve the maximum 'Oferta' among them, you may consider trying this formula.

Max(Filter(Ofertas,Title=GaleryName.Selected.Title),'Oferta')

I think this link will help you a lot:

https://learn.microsoft.com/en-us/power-platform/power-fx/reference/function-aggregates

Best Regards,

Bof
angeldiaz96 57 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks @v-bofeng-msft,
It's just what I need.
angeldiaz96 57 on at

Like
a
(0)

Report
Copy link

Link copied!

@v-bofeng-msft I would like to add a text label where I can show the author of the maximum offer at that moment (assuming that I want to show the author from the email column of the list)