Dynamic Dropboxes filtering from multiple choice lines.

(0) Share

Report

Posted on by MariusG96

Hello everyone.

I am building a help desk application which involves Category, Sub-Category and Person sections.

Categories like software, hardware or non-technical issues. These categories would be broken down in to more specific issues and would be displayed dynamically in the drop down boxes.

I got the sub categories showing based on what category is selected working just fine. I've used this command :

Filter('Sub-Categories',Category.Id = Dropdown1.Selected.ID).ID

The person would then have multiple of each of these sub-categories and then you could select a person for the task.

I've tried using similar code, however it comes up with an error saying "Invalid argument type"

Any suggestions?

Categories:

Building Power Apps

All responses (4)

Answers (0)

Sort by

WarrenBelz 156,720 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @MariusG96 ,
You can try the below (also valid format)

Filter('Sub-Categories',Category.Id = Dropdown1.Selected.ID, ID)

I assume the .ID comes from a collection

Please click and accept as Solution if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a Thumbs Up.
MariusG96 8 on at

Like
a
(0)

Report
Copy link

Link copied!
Filter(Employees,SubCategory.Id = Dropdown3.Selected.ID, ID)

Sorry for not specifying the code I've tried, but the one you've suggested returns with the same error.

To clafiry: Sub-Category has a look-up for category and emplyoees has a look-up for sub-category WITH ability to have multiple selections
WarrenBelz 156,720 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @MariusG96 ,
Interesting as I just tried the same on a test app with ID matches and it worked. Maybe someone else in our group has some ideas
MariusG96 8 on at

Like
a
(0)

Report
Copy link

Link copied!

Employees can have many different sub-categories and it just doesn't show any employees. The exact same code you've used has a squiggly line right underneath "=" saying "Invalid argument type.". There might be a different way of filtering columns that can have multiple choices, but I haven't found it.