cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
chris_young
Helper III
Helper III

Update Dropdown from Different Screen

Hello all, 

 

I have a filter question. 

 

I have a home page, that has a count of different items in certain status'. When someone pushes the count number I would like to to navigate to the screen with the dropdown selected so it filters to that requested view. I am hoping to do this all from one screen so I don't need different screens. 

 

Below is my filter and when manually selected it works. What I need help with is on page 1, I click In process and it directs to me to page with 1 - In Process populated into the dropdown so that is all that shows. Any advice?

 

If(Dropdown3_1.Selected.Value = "1 - In Process",
Filter('BIS_3RD PARTY', StartsWith('Resource Name', TextInput1_12.Text), 'Request Status'.Value = "1 - In Process"),
If(Dropdown3_1.Selected.Value = "2 - Submitted",
Filter('BIS_3RD PARTY', StartsWith('Resource Name', TextInput1_12.Text), 'Request Status'.Value = "2 - Submitted"),
If(Dropdown3_1.Selected.Value = "3 - Pending",
Filter('BIS_3RD PARTY', StartsWith('Resource Name', TextInput1_12.Text), 'Request Status'.Value = "3 - Pending"),
If(Dropdown3_1.Selected.Value = "4 - Confirmed",
Filter('BIS_3RD PARTY', StartsWith('Resource Name', TextInput1_12.Text), 'Request Status'.Value = "4 - Confirmed"),
If(Dropdown3_1.Selected.Value = "5 - Rejected",
Filter('BIS_3RD PARTY', StartsWith('Resource Name', TextInput1_12.Text), 'Request Status'.Value = "5 - Rejected"),
SortByColumns(Filter('BIS_3RD PARTY', StartsWith('Resource Name', TextInput1_12.Text)|| StartsWith(Customer, TextInput1_12.Text) || StartsWith(Project, TextInput1_12.Text)), "Title"))))))

1 ACCEPTED SOLUTION

Accepted Solutions
RandyHayes
Super User III
Super User III

@chris_young 

Yes, so the Dropdown is on your second screen then.

I am not entirely sure what the controls are that you have on the main screen, but let's focus on the #1 and I will assume that it is a Label.

First, apply the formula I sent for your items property of your Gallery and then, back on the main screen, set the OnSelect of the Label to the following:

    Set(glbFilterValue, "1 - In Process"); Navigate(yourOtherScreen)

Then on the DropDown, set the Default property to glbFilterValue

All the rest should fall in line.

 

One other thing you might want to do is on the second screen, set the OnHidden action to Set(glbFilterValue, "")

 

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up below. Solved your problem? - Click on Accept as Solution below. Others seeking the same answers will be happy you did.
Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes

View solution in original post

5 REPLIES 5
gabibalaban
Super User II
Super User II

Hi @chris_young ,

Can you show me a printscreen ? To have a picture of what you want to achieve ...

DavesTechTips
Super User
Super User

Hi @chris_young

 

You can write the default value into variable using the Set function, and use that variable name in the Default property for the Drop Down on the second screen.

Set(var_DefaultStatus,"1 - In Process")

 

Let me know if you don't come right.

 

RandyHayes
Super User III
Super User III

@chris_young 

You might consider simplifying your formula a bit to the following:

SortByColumns(
    Filter('BIS_3RD PARTY', 
       (
         StartsWith('Resource Name', TextInput1_12.Text) || 
         StartsWith(Customer, TextInput1_12.Text) || 
         StartsWith(Project, TextInput1_12.Text)
       )         
       &&
       (IsBlank('Request Status'.Value) || 'Request Status'.Value = Dropdown3_1.Selected.Value)      
    ), 
    "Title"
)

Just a bit easier to read and maintain and it also avoid multiple filter statements (not a desired thing in your app).

 

Now, I am not entirely sure what you mean though about:

Below is my filter and when manually selected it works. What I need help with is on page 1, I click In process and it directs to me to page with 1 - In Process populated into the dropdown so that is all that shows. Any advice?

Are you stating that is the problem or that is what you need?

Where is your dropdown - page 1 or something that is on the other page?

 

 

 

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up below. Solved your problem? - Click on Accept as Solution below. Others seeking the same answers will be happy you did.
Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes
chris_young
Helper III
Helper III

@RandyHayes @DavesTechTips @gabibalaban 

 

Thank you all for the quick responses and I will definitely correct my filter selection statement. Thank you for that. 

 

In the attached images you see the main screen. There are the processing queues which help direct users to those specific filters instead of having to go to the page and select the filter. I'm hoping to have the user click the 1, and it directs to them to page with the filter for that queue applied. Each area has it's own queue and single main screen. I was hoping to use that one screen to apply filters for the gallery based on what someone clicked. 

RandyHayes
Super User III
Super User III

@chris_young 

Yes, so the Dropdown is on your second screen then.

I am not entirely sure what the controls are that you have on the main screen, but let's focus on the #1 and I will assume that it is a Label.

First, apply the formula I sent for your items property of your Gallery and then, back on the main screen, set the OnSelect of the Label to the following:

    Set(glbFilterValue, "1 - In Process"); Navigate(yourOtherScreen)

Then on the DropDown, set the Default property to glbFilterValue

All the rest should fall in line.

 

One other thing you might want to do is on the second screen, set the OnHidden action to Set(glbFilterValue, "")

 

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up below. Solved your problem? - Click on Accept as Solution below. Others seeking the same answers will be happy you did.
Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes

View solution in original post

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

secondImage

Demo Extravaganza Winner Announcement

Please join us on Wednesday, July 21st at 8a PDT. We will be announcing the Winners of the Demo Extravaganza!

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Top Kudoed Authors
Users online (1,723)