Error message when using one drop down choice to filter the choices on another

(0) Share

Report

Posted on by AlanR

149

Hi there, I am trying to limit the choices presented in one dropdown based on the selection in another. The functionality is working in that regard but when I open the app I get the errors below - one of each of the dropdowns I am trying to filter - does anyone know how to fix this?

Aln

Categories:

General Questions

All responses (4)

Answers (0)

AlanR 149 on at

Like (0)

Report

Error message when using one drop down choice to filter the choices on another

Guys, many thanks for the help. I am making some progress. I now have the app "error free" in the editor - i.e. no red "x" marks when I open the app. The filtering between the check boxes is working as I was hoping however I still get the two error messages I posted here when I open the app on my phone. I can close out the error messages and the app then functions as it should. Any ideas on what I am missing given this?
Suggested answer

dmb 12 on at

Like (0)

Report

Error message when using one drop down choice to filter the choices on another

Based on the code that you have shown, it seems that the 3rd param of the If expression is wrong. When falsy, you should return a filtered table - use the Filter formula: https://learn.microsoft.com/en-us/power-platform/power-fx/reference/function-filter-lookup

You can also wrap it with Sort for better user experiense: https://learn.microsoft.com/en-us/power-platform/power-fx/reference/function-sort
AlanR 149 on at

Like (0)

Report

Error message when using one drop down choice to filter the choices on another

Hi FLMike, many thanks for answering - please see capture below - I hope this helps you to help me!
Michael E. Gernaey 41,322 Super User 2025 Season 1 on at

Like (0)

Report

Error message when using one drop down choice to filter the choices on another

Hi

Not without seeing the actual code, can't help you.

Add photos of where this code is.