dropdown for status view on gallery

(0) Share

Report

Posted on by mbhatt

525

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

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (0)

zeg 96 on at

Like (0)

Report

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

Was this reply helpful? Yes No
mbhatt 525 on at

Like (0)

Report

Hello ,
@zeg
this formula not working

Was this reply helpful? Yes No
zeg 96 on at

Like (0)

Report

Hi
@mbhatt

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

Was this reply helpful? Yes No
mbhatt 525 on at

Like (0)

Report

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 ?

Was this reply helpful? Yes No
zeg 96 on at

Like (0)

Report

@mbhatt

Please try Status.Value = Dropdown1.SelectedText.Value

Was this reply helpful? Yes No
mbhatt 525 on at

Like (0)

Report

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

Was this reply helpful? Yes No
zeg 96 on at

Like (0)

Report

@mbhatt

Please use Dropdown1.SelectedText.Value not
Dropdown1.Selected.Value

Was this reply helpful? Yes No
mbhatt 525 on at

Like (0)

Report

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

Was this reply helpful? Yes No
mbhatt 525 on at

Like (0)

Report

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 ?

Was this reply helpful? Yes No
zeg 96 on at

Like (0)

Report

Hi @mbhatt

Please try without _isAdmin

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),
IsBlank(Dropdown1.SelectedText.Value) || Dropdown1.SelectedText.Value = Status.Value,
IsBlank(Dropdown2.SelectedText.Value) || Dropdown2.Selected.Value = Category.Value,
IsBlank(Dropdown3.SelectedText.Value) || Dropdown3.SelectedText.Value = Priority.Value,
IsBlank(Dropdown5.SelectedText.Value) || Dropdown5.SelectedText.Value= Property.Value
)
),
ID,
SortOrder.Descending
)

Was this reply helpful? Yes No