Multiselect field to parse and then lookup from different SharePoint List

(0) Share

Report

Posted on by jimi_hendrix

Wondering the best way to achieve the following:

Background:

- Have one "master" Sharepoint list.
1. Within this list there is a multiselect field (call it DV_Selection)
- Have one "Vehicle" Sharepoint list
1. This is the list that the "master" list multiselect field references (its title column)

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?

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

WarrenBelz 154,547 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
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

Was this reply helpful? Yes No