Hello. I'm building a little debugging menu into my app and ran into an issue.
I have one variable (varSubdiv) which returns a table of data. In the debugging menu, I want to show "true" or "false" for each variable in my app. However I can't find a way to set a status label Text Property to varSub if it returns a table.
How can I determine the status of a non-boolean variable?
So far I've tried putting the following in the Text Property of of the status label:
varSubdiv
and...
If( varSubdiv, "true", "false")
and..
If( varSubdiv = //the table I'm querying// Distinct( Filter( theTable, column = dropdown.Selected.Value), returnColumn), "true","false")
All return some form of the error: "Invalid argument type."
Solved! Go to Solution.
For which values of 'varSubdiv' would your debugging menu show true or false? Since that variable is a table, there are some options for that:
If( And( CountRows(varSubdiv) = CountRows(otherTable), 0 = Sum( ForAll( varSubdiv, If(IsBlank(LookUp(otherTable, column = subDivColumn)), 0, 1)), Result)), "true", "false")
Let us know the logic that you're using to determine whether that variable should be shown as true/false, and we should hopefully be able to help you get there!
For which values of 'varSubdiv' would your debugging menu show true or false? Since that variable is a table, there are some options for that:
If( And( CountRows(varSubdiv) = CountRows(otherTable), 0 = Sum( ForAll( varSubdiv, If(IsBlank(LookUp(otherTable, column = subDivColumn)), 0, 1)), Result)), "true", "false")
Let us know the logic that you're using to determine whether that variable should be shown as true/false, and we should hopefully be able to help you get there!
Thank you @CarlosFigueira, this is the exact logic I needed to understand and get into my head. I'm so used to boolean variables that I was blinded to "true / false" as an only option.
Take care
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
User | Count |
---|---|
197 | |
70 | |
49 | |
42 | |
30 |
User | Count |
---|---|
264 | |
119 | |
100 | |
92 | |
81 |