Showing results for 
Search instead for 
Did you mean: 
New Member

Cascading Drop Down SP Form - Retrieving Items from a Foreign Table

I'm using a PowerApps trial to see if I can help justify the cost to my department. I created a series of SharePoint lists:


Table 1: tbl_Meeting   

Fields: Titles Meeting Title


Table 2: tbl_MeetingDateTime

Fields: Meeting Title(lookup),  MeetingDateTime


Table3:tbl_Agenda Items

Fields: MeetingTitle(lookup), MeetingDateTime(lookup), Title...)    Note: MeetingTitle & MeetingDateTime are site columns


I'm trying to create a PowerApps form for Table 3 that has cascading drop down where you select the Meeting Title and then it filters the MeetingDateTime field to only show the times where there is a record matching the same meeting title in Table2. Is this possible?


I have connected the Table 2 & Table 3 to the app but when I try and get the DateTime items from tbl.MeetingDateTime, PowerApps seems to not like this.


Any advice appreciated.



Helpful resources

New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

New Power Super Users


We are excited to announce the Power Apps Super Users!

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

Top Solution Authors
Top Kudoed Authors
Users online (102,462)