Answered

if statement apply the wrong logic

(0) Share

Report

Posted on by DPozzi

124

Good morning, following the suggestion from @Ashwin7104 in the post Solved: Re: Why isBlank it's true? - Power Platform Community (microsoft.com)

I've attempted to handle the Displaymode of three dropdownboxes with this check:

If(
IsEmpty(
Distinct(
Filter(
Automobili,
Assegnatario.Value = varUtente && Tipo_Veicolo.Value = "Furgone"
),
Title
)
),
Set(varTipo,true),
Set(varTipo,false)
)

unfortunately varTipo always comes false also when the isEmpty is True.

I'm missing something ? 😕

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (1)

Sort by

AJ_Z 3,711 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

where does this formula get updates is it onselect or onchange of something or is it onvisible?

Was this reply helpful? Yes No
DPozzi 124 on at

Like
a
(0)

Report
Copy link

Link copied!

@AJ_Z is in the screen onvisible

Was this reply helpful? Yes No
AJ_Z 3,711 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

I am guessing you have tried to navigate away and back to the screen to refresh the onvisible? as it will only set when you first come to the screen? 🙂

Was this reply helpful? Yes No
DPozzi 124 on at

Like
a
(0)

Report
Copy link

Link copied!

@AJ_Z yes I did multiple times, the syntax looks right to me, I really don't understand

Was this reply helpful? Yes No
AJ_Z 3,711 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
It looks good to me 🙂

Do either of the below options work?:

If( IsEmpty( Distinct( Filter( Automobili, Assegnatario.Value = varUtente && Tipo_Veicolo.Value = "Furgone" ), Title ).Result ), Set(varTipo,true), Set(varTipo,false) )

If( IsBlank( First( Distinct( Filter( Automobili, Assegnatario.Value = varUtente && Tipo_Veicolo.Value = "Furgone" ), Title ) ) ), Set(varTipo,true), Set(varTipo,false) )

If( IsBlank( First( Distinct( Filter( Automobili, Assegnatario.Value = varUtente && Tipo_Veicolo.Value = "Furgone" ), Title ) ).Result ), Set(varTipo,true), Set(varTipo,false) )

All of them work for my end 🙂 . Let me know how it goes

Was this reply helpful? Yes No
DPozzi 124 on at

Like
a
(0)

Report
Copy link

Link copied!

@AJ_Z no one works, they all behave in the same way of my first.. it's a non sense the isEmpty statement it's true, so why the variable is always "False"

Was this reply helpful? Yes No
MVP-Phipps 3,521 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

My only thought is there variable is also being set somewhere else. Can you confirm this is the only place in the app where you are setting the variable?

Please Accept as Solution if it solves your question. Or just give it a Thumbs Up if it is helpful as can help others.
LinkedIn: https://www.linkedin.com/in/charlie-phipps-%F0%9F%91%A8%E2%80%8D%F0%9F%92%BB-91338715b/
Subscribe to my YouTube: https://www.youtube.com/channel/UChmFBGU1YKIU91sNMQ7buGg

Was this reply helpful? Yes No
Verified answer

DPozzi 124 on at

Like
a
(0)

Report
Copy link

Link copied!

yes, if I remove this couple of "SET" the three dropdownboxes that use it in the display mode goes in error due the variable doesn't exist at all.

I've solved in my app with a text label that report the kind of vehicle:

Concat((SortByColumns(
Distinct(
Filter(
Automobili,
Title=SelTarga.Selected.Result),
Tipo_Veicolo.Value
),
"Result"
)), Result & "")

and then set the displaymode:

If(
IsMatch(
TipoVeicolo.Text,
"Furgone"
),
DisplayMode.Edit,
DisplayMode.Disabled
)

but this is just a walk around not a solution because this label it wasn't supposed to be showed and I don't like to "hide" labels just to use them as variables.
in powerapps FX variables are always "boolean" doesn't them? if yes it's really a dumb thing

Was this reply helpful? Yes No
MVP-Phipps 3,521 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

"display mode goes in error due the variable doesn't exist at all." have you tried setting the variable to false on the on app start or on the screen on visible property?

Was this reply helpful? Yes No