cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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.

Thanks,

0 REPLIES 0

Helpful resources

Announcements
News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

Power Apps Community Call

Power Apps Community Call- January

Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST

PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

secondImage

Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

Top Solution Authors
Top Kudoed Authors
Users online (10,975)