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

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!

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

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors
Users online (9,928)