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
Anonymous
Not applicable

Re: filter through status button and no delgation

Bumping for visibility 

 

@Anonymous 

Helpful resources

Announcements
Check this Out

Helpful information

Featuring samples like Return to the Workplace and Emergency Response Applications

August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

secondImage

Super Users Coming in August

We are excited for the next Super User season.

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 (7,274)