cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

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
Community Champion
Community Champion

Re: filter through status button and no delgation

Bumping for visibility 

 

@TopShelf-MSFT 

Helpful resources

Announcements
secondImage

Demo-Extravaganza 2020

Check out these cool Power Apps & vote on your favorite!

secondImage

Robotic Process Automation

Let's talk about the solution provided by Microsoft for Robotic Process Automation (RPA)

secondImage

Community Highlights

Check out whats happening in Power Apps

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (8,643)