Answered

Conditional navigate with CountIf variable

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi everyone!

I have an app linked to a sharepoint list. I have a screen which I use a dashboard, in this screen I have some indicators that are calculated using the CountIf formula. I would like to set a variable based on this numbers, when the sum of them is 0, I would like my gallery to change its navigation conditions (attached photo of the dashboard).

The CountIf formula I am using is the following (this formula works perfectly):

CountIf(SPList;Colum1 = ThisItem.Result && 'Colum2'= "YES")

CountIf(SPList;Colum1 = ThisItem.Result && 'Colum2'= "NO")

and so on...

Then, I would like something like this (but this formula does not work):

Set(Variable1;CountIf(SPList;Colum1 = ThisItem.Result && 'Colum2'= "YES"))

Set(Variable2;CountIf(SPList;Colum1 = ThisItem.Result && 'Colum2'= "NO"))

And then, change the OnSelect properties of my gallery using something like this:

If(Variable1+Variable2+Variable3=0;Navigate(Screen1);Navigate(Screen2))

I need help with all those formulas. Is possible to achieve what I want?

Many thanks!

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous

Not sure why you want separate variable (var 1, var 2) when you are summing up these variables to decide on which screen to nagivate.

You can have
Set(Variable1;CountIf(SPList;Colum1 = ThisItem.Result && ('Colum2'= "YES" || 'Colum2'= "NO" )))

Further the count of below will always be > 0 :

Set(Variable1;CountIf(SPList;Colum1 = ThisItem.Result) // if you want to check specific value you should hardcode Colum1 = "VALUE"

and so the variable1 depend on colum2. So the column 2 value should be other than YES/NO to get Variable1 = 0.

Thanks.
Verified answer

v-yutliu-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Anonymous ,

Do you mean that :

1)these two formulas work well

CountIf(SPList;Colum1 = ThisItem.Result && 'Colum2'= "YES")

CountIf(SPList;Colum1 = ThisItem.Result && 'Colum2'= "NO")

2)these two formulas do not work

Set(Variable1;CountIf(SPList;Colum1 = ThisItem.Result && 'Colum2'= "YES"))

Set(Variable2;CountIf(SPList;Colum1 = ThisItem.Result && 'Colum2'= "NO")) ?

Could you tell me how do you set variable1 and variable2?

Since Set function is a behaviour function, you can use it only within a behavior formula.

For example, set a button's OnSelect.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks @v-yutliu-msft and @Anonymous , I didn't take into account that "set" is a behaviour formula, that's why it didn't work.