cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
taramoe
Advocate II
Advocate 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
TimW
Helper II
Helper II

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

8 REPLIES 8
CarlosFigueira
Power Apps
Power Apps

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

TimW
Helper II
Helper II

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)

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.

MK2005
Regular Visitor

Need some help with this formula on why it's saying it's an invalid argument at the "=" between "'Trainer(s) Assigned'.Value" and "ComboBox1.Selected.Items.Value,"

 

Filter('CI Training Request Sandbox','Request Approval Status' <> "Denied", 'Trainer(s) Assigned'.Value = ComboBox1.SelectedItems.Value, Text('Assignment Start Date', DateTimeFormat.ShortDate) = Text(_dateSelected,DateTimeFormat.ShortDate))

 

Trainer(s) assigned is pulling from a Choice Field from a SharePoint List.  The ComboBox1 was set to

 and pull the distinct field properly.

 

If I remove that area of the formula, the gallery items populate correctly, albeit not filtered by the ComboBox selection.

 

How can I get this corrected to filter properly with it included?

 

Choices('CI Training Request Sandbox'.'Trainer(s) Assigned')

 

@MK2005I think maybe you are using a combo (which can do multiple select) when you wanted a dropdown?

MK2005
Regular Visitor

Yes, that worked..is there a different way to do write it...had I used a Combo instead?

TimW
Helper II
Helper II

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Carousel_PP_768x460_Wave2 (1).png

2022 Release Wave 2 Plan

Power Platform release plan for the 2022 release wave 2 describes all new features releasing from October 2022 through March 2023.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Top Solution Authors
Users online (2,995)