cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
taramoe
Level: Powered On

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
Highlighted
TimW
Level: Powered On

Re: Invalid Argument Type using cascading filter

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
PowerApps Staff CarlosFigueira
PowerApps Staff

Re: Invalid Argument Type using cascading filter

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

Highlighted
TimW
Level: Powered On

Re: Invalid Argument Type using cascading filter

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

taramoe
Level: Powered On

Re: Invalid Argument Type using cascading filter

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

TimW
Level: Powered On

Re: Invalid Argument Type using cascading filter

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
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (4,555)