Been trying to get this working for ages and could use some assistance:
If(
_varSiteAdmin,
If(
IsBlank(drpRequestStatusFilter.SearchText),
If(
IsBlank(cmbRequestTypeFilter.Selected.Result),
Sort(
CustomerRequests,
Created,
Descending
),
Sort(
Filter(
CustomerRequests,
'Customer Request Type' exactin cmbRequestTypeFilter.Selected.Result
),
Created,
Descending
)
),
If(
IsBlank(cmbRequestTypeFilter.Selected.Result),
Sort(
Filter(
CustomerRequests,
Status = drpRequestStatusFilter.Selected.Result
),
Created,
Descending
),
Sort(
Filter(
CustomerRequests,
Status = drpRequestStatusFilter.Selected.Result And 'Customer Request Type' exactin cmbRequestTypeFilter.Selected.Result
),
Created,
Descending
)
)
),
/*isAdmin False/Else Value Code:*/
If(
IsBlank(drpRequestStatusFilter.SearchText),
If(
IsBlank(cmbRequestTypeFilter.Selected.Result),
Sort(
Filter(
CustomerRequests,
'Customer Email' exactin _varUserEmail
),
Created,
Descending
),
Sort(
Filter(
CustomerRequests,
'Customer Request Type' exactin cmbRequestTypeFilter.Selected.Result And 'Customer Email' exactin _varUserEmail
),
Created,
Descending
)
),
If(
IsBlank(cmbRequestTypeFilter.Selected.Result),
Sort(
Filter(
CustomerRequests,
Status = drpRequestStatusFilter.Selected.Result And 'Customer Email' exactin _varUserEmail
),
Created,
Descending
),
Sort(
Filter(Filter(
CustomerRequests,
Status = drpRequestStatusFilter.Selected.Result And 'Customer Request Type' exactin cmbRequestTypeFilter.Selected.Result), 'Customer Email' exactin _varUserEmail
),
Created,
Descending
)
)
)
)
The code has no errors but just doesn't seem to like the current configuration.
_varSiteAdmin is set OnStart by the following code:
If(Is blank(Lookup ('Lookup - AdminSettings','Setting Type' exactin "Site Admin" And 'Setting Value' exactin _varUserName)), Set(_varSiteAdmin,false),Set(_varSiteAdmin,true))
This code is fine and works for my purposes but the Items code above is what is no longer working.
I want to be able to use two separate combo boxes to filter results and if the boxes are empty/if you remove a selected option from combo box then I want it to show all items.
Thanks in anticipation
