
Announcements
Wondering the best way to achieve the following:
Background:
Examples "Vehicle" list:
| Title | Date | Finish |
| DV_xyz013 | 01/04/2022 | 01/30/2022 |
| DV_xyz01a | 02/09/2023 | 02/19/2023 |
| M_123xzy | 01/05/2022 | |
| M_123xza | 01/23/2022 | 01/25/2022 |
The scenario is as follows:
User selected "DV_xyz013", "DV_xyz01a", and "M_123xza", I would like to find the "DV" has the latest date and return that particular row's Finish date.
Whats the best way to execute this?
Hi @jimi_hendrix ,
I cannot presently test this, but try
First(
Sort(
Filter(
Vehicles,
Title in ComboBoxName.SelectedItems
),
Date,
SortOrder.Descending
)
).Finish
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
MVP (Business Applications) Visit my blog Practical Power Apps