dropdown for status view on gallery

[mbhatt]

Hello @WarrenBelz 

Could you assist me With this formula 

As i am trying to get filter by status value on gallery . with previous code everything look nice and working now currently i add another dropdown for status filter 

here is i am try to use this 

Sort(
With(
{_IsAdmin: !IsBlank(LookUp('User ID Hahelp', 'Admin '.DisplayName = User().FullName))},
Filter(
'HH Power App',
'Created By'.DisplayName = User().FullName || _IsAdmin,
IsBlank(TextInput6.Text) || ID = Value(TextInput6.Text),
IsBlank(Dropdown1.Selected.Value) || Status = Dropdown1.Selected.Value
)
),
ID,
SortOrder.Descending
)

how do i add dropdown1 in this gallery want to view status of ticket 

[zeg]

Hi @mbhatt  
If Status is a choice column, please try Status.Value = Dropdown1.Selected.Value in the filter.
Hope this helps.

[mbhatt]

Hello ,

@zeg 

this formula not working 

[zeg]

Hi

@mbhatt 

Is Dropdown1 items set to Choices([@'HH Power App'.Status])?

[mbhatt]

Hello 

@zeg 

What are the codes to can see the status 

here is drop down property 

as well your given code is applied on item property of gallery now what i have to use on drop down ? 

[zeg]

@mbhatt 

Please try  Status.Value = Dropdown1.SelectedText.Value

[mbhatt]

Hello @zeg 

I try with status.value =dropdown1.selected.value

nothing happen code not given me error but seem like nothing happen when i click and valu from dropdown item from gallery not filter 

[zeg]

@mbhatt 

Please use Dropdown1.SelectedText.Value not

Dropdown1.Selected.Value

[mbhatt]

Hello 

@zeg 

I am Leveraging This code for all other dropdown and also maintaining roll base security roll for admin and user with search capability. 

also, I have been confirm that this code is working fantastically and provide me result by filtering.

here is code what i make for all things together ,

Sort(
With(
{
_IsAdmin: !IsBlank(
LookUp(
'User ID Hanhelp',
'Admin '.DisplayName = User().FullName
)
)
},
Filter(
'HH Power App',
'Created By'.DisplayName = User().FullName || _IsAdmin,
IsBlank(TextInput6.Text) || ID = Value(TextInput6.Text),
_IsAdmin,IsBlank(Dropdown1.SelectedText.Value) || Dropdown1.SelectedText.Value = Status.Value,
_IsAdmin, IsBlank(Dropdown2.SelectedText.Value) || Dropdown2.Selected.Value = Category.Value,
_IsAdmin, IsBlank(Dropdown3.SelectedText.Value) || Dropdown3.SelectedText.Value = Priority.Value,
_IsAdmin, IsBlank(Dropdown5.SelectedText.Value) || Dropdown5.SelectedText.Value= Property.Value
)
),
ID,
SortOrder.Descending
)

No I need to confirm that this formula has facility can provide reset function when value is not selected by dropdown. also need to check other previous function is working or not . thanks 

[mbhatt]

Hey 

@zeg 

I just confirm that this code is work for only admins.

user are not able to see any of their own records.

can you assist me with this code what i made mistake overhere ?