Nested Filter in a drop-down based on values from 2 tables

(0) Share

Report

Posted on by ChrisFromGufi

Hi experts,

I am having difficulties on a most likely easy nested filter question I cannot find the solution.

I have a dropdown that should provide a list of dates based on data from 2 tables with a 1:n relationship:

Table 1 - tbl_Meetings

ID (1)

MeetingDate

Table 2 - tbl_Project_Updates

MeetingID (many)

For some Project Updates a meeting (ID) is referenced in field MeetingID in table tbl_Project_Updates.

In the dropdown I only want to show the meeting dates from table tbl_Meetings where MeetingID is not blank() in table tbl_Project_Updates.

Filter 1: It is essentially clear how to filter the records from tbl_Project_Updates where an entry was made in column MeetingID.

Filter(tbl_Project_Updates, MeetingID <> Blank())

However, I am not able to relate the table created in the first filter to the tbl_Meetings and show the meeting dates in the dropdown where the MeetingID from tbl_Project_Updates matches the ID from tbl_Meetings.

I am sure there the community will have a solution quickly.

Unfortunately, searching the previous posts did not help me either.

Thank you in advance.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@ChrisFromGufi

AddColumns(GroupBy(tbl_Project_Updates,MeetingID),"mdate",LookUp(tbl_Meetings,ID=MeetingID).MeetingDate)

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@ChrisFromGufi

AddColumns( GroupBy( tbl_Project_Updates,MeetingID ),"mdate",LookUp(tbl_Meetings,ID=MeetingID).MeetingDate )

Was this reply helpful? Yes No
Verified answer

ChrisFromGufi 9 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Drrickryp,

Thank you a lot, this was a great help. Your formula was a great basis to get to the final working code

The working code actually is:

-----------------------
Sort(
    Filter(
        AddColumns(
            GroupBy(
                tbl_Project_Updates,
                "MeetingID",
                "Rest"
            ),
            "mdate",
            LookUp(
                tbl_Meetings,
                ID = MeetingID
            ). MeetingDate
        ),
        !IsBlank(mdate)
    ),
    mdate,
    Descending
)
-----------------------

Was this reply helpful? Yes No