cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Anonymous
Not applicable

Conditional navigate with CountIf variable

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!

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: Conditional navigate with CountIf variable

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 Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
Highlighted
Anonymous
Not applicable

Re: Conditional navigate with CountIf variable

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.

 

 

 

Highlighted
Community Support
Community Support

Re: Conditional navigate with CountIf variable

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 Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Highlighted
Anonymous
Not applicable

Re: Conditional navigate with CountIf variable

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. 

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Watch Now

Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (7,077)