cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
TopShelf-MSFT
Level 10

Re: filter through status button and no delgation

Bumping for visibility 

 

@TopShelf-MSFT 

Helpful resources

Announcements
New Ranks and Rank Icons in April

'New Ranks and Rank Icons in April

Read the announcement for more information!

Better Together’ Contest Finalists Announced!

'Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

thirdimage

Community Summit North America

Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications

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