cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mehul_sompura
Level: Powered On

filter through status button and no delgation

I am tring to to select filter my search with the status of request (which is submitted,approved,declined). I do not want them to mulpile select the buttons. You can only use one at a time. Also have a clear button which removes the filter and shows all itme. On top of this it gices a delegation waring if i use if loop in my filter equation so what do i do to not have that. 

 

P.S. in my filter equation in use login email to show the request depending on securty level of that person. 

This is my filter eqaution :

If(
IsMatch(
admins.users,
User().Email,
Contains
) = true && !myview,
SortByColumns(
Filter(
'Out of Office',
Or(
StartsWith(
Title,
TextSearchBox1.Text
),
StartsWith(
Department.Value,
TextSearchBox1.Text
)
),
If(
Pending = false && Approved = false && Declined = false && Cancelled = false,
true,
If(
Pending,
'Status of Request'.Value = "Pending",
false
) || If(
Approved,
'Status of Request'.Value = "Approved",
false
) || If(
Declined,
'Status of Request'.Value = "Declined",
false
) || If(
Cancelled,
'Status of Request'.Value = "Cancelled",
false
)
)
),
"Title",
If(
SortDescending1,
Descending,
Ascending
)
),
SortByColumns(
Filter(
'Out of Office',
Or(
StartsWith(
Title,
TextSearchBox1.Text
),
StartsWith(
Department.Value,
TextSearchBox1.Text
)
),
If(
Manager.Email = User().Email && !myview,
Manager.DisplayName = User().FullName,
Requester.DisplayName = User().FullName
),
If(
Pending = false && Approved = false && Declined = false && Cancelled = false,
true,
If(
Pending,
'Status of Request'.Value = "Pending",
false
) || If(
Approved,
'Status of Request'.Value = "Approved",
false
) || If(
Declined,
'Status of Request'.Value = "Declined",
false
) || If(
Cancelled,
'Status of Request'.Value = "Cancelled",
false
)
)
),
"Title",
If(
SortDescending1,
Descending,
Ascending
)
)
)

 

Annotation 2019-10-28 135030.png

1 REPLY 1
Highlighted
TopShelf-MSFT
Level 10

Re: filter through status button and no delgation

Bumping for visibility 

 

@TopShelf-MSFT 

Helpful resources

Announcements
thirdimage

Power Apps Super User Class of 2020

Check it out!

thirdimage

New Badges

Check it out!

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

SecondImage

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors
Users online (4,927)