cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper II
Helper II

Invalid Argument Type using cascading filter

I have a list in SP called 'Meeting Types' and am trying to get a cascading filter to work between the second and third drop downs (picture below).

 

The second drop down is from the SP field called 'MeetingType' (text) with the drop down being named 'SelectMeetingType'.

The third drop down is the SP field called 'MeetingDateTimeText' (text) and I only want this field to display available date/times that belong to that 'MeetingType'.

 

This is my formula that is giving me the 'Invalid Argument Type' with a squiggly under the equals sign.

 

Distinct(Filter('Meeting Schedule',MeetingType=SelectMeetingType.Selected.Value),MeetingDateTimeText)

 

What am I missing? 

 

Meeting Schedule.png

1 ACCEPTED SOLUTION

Accepted Solutions
Helper I
Helper I

Distinct(Filter('Meeting Schedule',MeetingType=SelectMeetingType.Selected.Value),MeetingDateTimeText)

I just had the same problem, how about:

Distinct(Filter('Meeting Schedule',MeetingType.Value=SelectMeetingType.Selected.Value),MeetingDateTimeText)

View solution in original post

4 REPLIES 4
Power Apps
Power Apps

What is the expression for the Items property of the second dropdown (SelectMeetingType)?

Helper I
Helper I

Distinct(Filter('Meeting Schedule',MeetingType=SelectMeetingType.Selected.Value),MeetingDateTimeText)

I just had the same problem, how about:

Distinct(Filter('Meeting Schedule',MeetingType.Value=SelectMeetingType.Selected.Value),MeetingDateTimeText)

View solution in original post

That worked!  Been fighting with this for days and all it took was a simple ".Value".  Thank you!

PowerApps trying to be helpful with Sharepoint list shenanigans - it's going to take some getting used to 😄

Glad I could help.

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 (5,856)