Answered

Invalid Argument Type using cascading filter

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (1)

Sort by

CarlosFigueira Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Verified answer

TimW 82 on at

Like (0)

Report
Copy link

Link copied!

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)

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
TimW 82 on at

Like (0)

Report
Copy link

Link copied!

PowerApps trying to be helpful with Sharepoint list shenanigans - it's going to take some getting used to 😄
Glad I could help.

Was this reply helpful? Yes No
MK2005 5 on at

Like (0)

Report
Copy link

Link copied!
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')

Was this reply helpful? Yes No
TimW 82 on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
MK2005 5 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
TimW 82 on at

Like (0)

Report
Copy link

Link copied!

You would need to use the "in" predicate rather than "=", https://powerusers.microsoft.com/t5/Building-Power-Apps/How-to-Filter-a-Gallery-using-a-Combo-Box/td-p/68188 talks about this.
I don't think that "in" is delegable to SharePoint though, see https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/delegation-overview and https://docs.microsoft.com/en-us/connectors/sharepointonline/#power-apps-delegable-functions-and-operations-for-sharepoint

Was this reply helpful? Yes No