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:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Michael E. Gernaey 53,963 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Hi

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

Add photos of where this code is.

Was this reply helpful? Yes No
AlanR 149 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi FLMike, many thanks for answering - please see capture below - I hope this helps you to help me!

Was this reply helpful? Yes No
Suggested answer

dmb 12 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
AlanR 149 on at

Like
a
(0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No