Answered

Issue Filtering Data Table linked to Drop Down Control

(0) Share

Report

Posted on by Community Power Pla...

Hello, I have a table of Standard Opertaing Procedure's where each record has a Category, Sub-Category (specific to Category), Name, Number, and Description. My goal is to have an initial screen where the user selects the Category and Sub-Category and hits a Search button to go to a Data Table with the SOP's that match the selected Sub-Category. For reference, the Category and Sub-Category drop down controls each utilize a Distinct formula since I only want the drop down to have unique entries.

I have been struggling to write the Filter command in the Items property of the Data Table. I have tried to use the following formulas but keep getting Errors:

FIlter (SOP_Table, SubCategory = Dropdown2.Selected)

Filter (SOP_Table, SubCategory = Text(Dropdown2.Selected))

Filter (SOP_Table, Dropdown2.Selected in SubCategory)

Filter (SOP_Table, StartsWith(SubCategory, Dropdown2.Selected))

Search (SOP_Table, Dropdown2.Selected, "SubCategory")

Search(SOP_Table, Text(Dropdown2.Selected), "SubCategory")

The error message is usually Invalid Argument Type or Unexpected Input. I've tried the Text function to get around the unexpected input but that doesn't work. For a control, I ran the filter command using the selected Sub-Category but just manually entered in quotation marks (" ") to see if the filter command actually works and it filtered properly.

Please help!

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Jeff_Thorpe 6,085 Super User 2024 Season 1 on at

Like (1)

Report

Are Category and Sub-Category a text fields on SOP_Table or are they choice fields. Here are some examples assuming you want your Data Table filtered by both category and sub category.

Example if Category and Sub-Category are text fields in SOP_Table:

Filter (SOP_Table, Dropdown1.Selected = Category, Dropdown2.Selected = SubCategory )

Example if Category and Sub-Category are choice fields in SOP_Table:

Filter (SOP_Table, Dropdown1.Selected = Category.Value, Dropdown2.Selected = SubCategory.Value )

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

Like (0)

Report

@Jeff_Thorpe, Thanks for the response. Category and SubCategory are both defined as Text in SOP_Table and are not selected from a dropdown in the excel file. I tried both options you suggested and both returned Error, invalid argument type.

Something I've noticed while trying to figure the formula out, the app recognizes Dropdown1.Selected and Dropdown2.Selected as a Record if that helps.

Thanks,
Brendan

Was this reply helpful? Yes No
Verified answer

Jeff_Thorpe 6,085 Super User 2024 Season 1 on at

Like (1)

Report

I should have noticed that before. The dropdown portion needs the column name. Normally that is ".Value" but some times that can be something else depending on the formula in Items. Just put a "." after selected and intellsense should show you your options.

Example if it is ".Value"

Filter (SOP_Table, Dropdown1.Selected.Value = Category, Dropdown2.Selected.Value = SubCategory )

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

Like (0)

Report

@Jeff_ThorpeThat worked, thank you very much. Dropdown2.Selected.Result worked for me.

Was this reply helpful? Yes No