Update Dropdown from Different Screen

[chris_young]

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"))))))

[gabibalaban]

Hi @chris_young ,

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

[DavesTechTips]

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]

@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?

[chris_young]

@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 · Accepted solution]

@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, "")