Showing results for 
Search instead for 
Did you mean: 
Impactful Individual
Impactful Individual

code help please

Hello all,

I have a canvas app, with SPO as its datasource.

I have a scenario where User1 has completed a section of the form.

User2 has now come to section2 to enter up to 7 reviewers (this is a case by case scenario, sometimes 2 reviewers sometimes 1, other times 5)

I have on that screens OnVisible created a variable Set(MyReviewer1,Lbl_Reviewer1.Text);// and so on for each reviewer (this is to cater for another scenario).

On my next button I want to it to be able to only navigate to a screen which has a reviewer entered by User2. So if User2 has entered Reviewer1 then the next button should navigate to Reviewer1Screen, but if User2 entered the names for Reviewer2 and 3 navigate to Reviewer2Screen then Reviewer3Screen.

I want to avoid the scenario where users need to click through 7 screens when there will be data on say 3 screens.

Is this possible?

I have a status column to cater for which reviewers complete there sections but not sure how I achieve this? 

Thank You 

Power Apps
Power Apps


Reviewer1, Navigate(Screen1, Fade),

Reviewer2, Navigate(Screen2, Fade),

Reviewer3, Navigate(Screen3, Fade)


The code might look like to simple, but the logic inside a Switch() function should help you to select based on your scenario

Hi @Carsten_Growth 


But I havent used the switch function before.

How will it know which screen to navigate to?

take a look here for further documentation. OnSelect of one of your footer items, you would set a variable. Let´s say it becomes 1, 2 or 3. Then you can type something like Switch(variableName,

1, Navigate(Screen1, Fade), //do action when variableName = 1

2, Navigate(Screen2, Fade) //do action when variableName = 2


Got the idea?

HI @Carsten_Growth 

Afraid not, im not from a developer background.

Some help if you can, would be appreciated in terms of the code I would use on my button, or maybe if you have similar code, just so i can get the idea with how to use it 

You don´t need developer background. I already provided you a sample with

1, Navigate(Screen1, Fade), //do action when variableName = 1
2, Navigate(Screen2, Fade) //do action when variableName = 2

All you need to do is use variableName and OnSelect of your buttons to show specific gallery set it to be 1, 2, ...

Helpful resources

Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (3,768)