You’re offline. This is a read only version of the page.
20
Background: In order to prevent delegation issues, I am populating a Collection via SharePoint List.
Issue: I am trying to further reduce the result set to not show any Completed items that are older than 90 days. Unfortunately, I cannot get the logic to do both.
I've tried filtering within the gallery as well as my current attempt, filter before generating the collection. If I uncomment //&& Status.Value <> "Completed", not only does it remove any Completed items, it also triggers a delegation warning.
Share
ReportClearCollect(
colRequestDetails,
ForAll(
Filter(
'Requests',
Created > DateAdd(Today(), -90, TimeUnit.Days) //&& Status.Value <> "Completed"
),
{
RequestNum: ThisRecord.ID,
Requestor: ThisRecord.Requestor,
RequestFam: ThisRecord.'Request Family',
RequestType: ThisRecord.'Request Type',
Status: ThisRecord.Status.Value,
ShortDesc: ThisRecord.Description,
Priority: ThisRecord.Priority.Value,
Comments: ThisRecord.Comments,
Assignee: ThisRecord.'Assigned To',
CreatedDate: ThisRecord.Created
}
)
)
Separating out the condition nets the same result.
Created > DateAdd(Today(), -90, TimeUnit.Days),
Status.Value <> "Completed"
All responses (
Answers (
