Power Platform Community Forum Thread Details

I'm having difficulty getting this right.

I have chkCompletedWSgals(check box) that when not checked shows requests scheduled for today AND request that are not completed before Today.
chkCompletedWSgals= true than it should show items in 1 and requests that were completed Today.
I have a date picker that should show only requests that were completed only on that day, if other than today.

My problem is with statement 2. When chkCompletedWSgals is false I get items in 1. When chkCompletedWSgals is true I ONLY see completed requests when I still want to see items from 1. I've changed things so many times 😐

SortByColumns(
If(
DatePickerWLscreen.SelectedDate = Today() And chkCompletedWSgals.Value = false,
Filter(
'Dispatch',
Truck.Value = "1234",
Or(
Status.Value = "In Progress",
Status.Value = "Approved"
),
ScheduledStartTime = Blank() Or ScheduledStartTime <= DateAdd(
Today(),
1,
Days
)
),
DatePickerWLscreen.SelectedDate = Today() And chkCompletedWSgals.Value = true,
Filter(
'Dispatch',
Truck.Value = "1234",
CompletedDate >= Today(),
CompletedDate < DateAdd(
Today(),
1,
Days
),
ScheduledStartTime = Blank() Or ScheduledStartTime <= DateAdd(
Today(),
1,
Days
)
),
Filter(
'Dispatch',
Truck.Value = "1234",
Or(
CompletedDate >= DatePickerWLscreen.SelectedDate And CompletedDate <= DateAdd(
DatePickerWLscreen.SelectedDate,
1,
Days
),
ScheduledStartTime >= DatePickerWLscreen.SelectedDate And ScheduledStartTime <= DateAdd(
DatePickerWLscreen.SelectedDate,
1,
Days
)
)
)
),
"BuildingText",
Ascending,
"Title",
Ascending,
"IDText",
Ascending
)

Categories:

Building Power Apps

I figured it out. I wasn't being specific enough with all different scenarios. Code looks a hot mess but its working 🙂

SortByColumns(
If(
DatePickerWLscreen.SelectedDate = Today() And chkCompletedWSgals.Value = false,
Filter(
'Dispatch',
Truck.Value = "1234",
Or(
Status.Value = "In Progress",
Status.Value = "Approved"
),
ScheduledStartTime = Blank() Or ScheduledStartTime <= DateAdd(
Today(),
1,
Days
)
),
DatePickerWLscreen.SelectedDate = Today() And chkCompletedWSgals.Value = true,
Filter(
'Dispatch',
Truck.Value = "1234",
Or(
CompletedDate >= DatePickerWLscreen.SelectedDate And CompletedDate < DateAdd(
DatePickerWLscreen.SelectedDate,
1,
Days
) And ScheduledStartTime = Blank(),
CompletedDate >= DatePickerWLscreen.SelectedDate And CompletedDate < DateAdd(
DatePickerWLscreen.SelectedDate,
1,
Days
) And ScheduledStartTime >= DatePickerWLscreen.SelectedDate And ScheduledStartTime <= DateAdd(
DatePickerWLscreen.SelectedDate,
1,
Days
),
Status.Value = "In Progress",
Status.Value = "Approved"
)
),
Filter(
'Dispatch',
Truck.Value = "1234",
Or(
CompletedDate >= DatePickerWLscreen.SelectedDate And CompletedDate <= DateAdd(
DatePickerWLscreen.SelectedDate,
1,
Days
),
ScheduledStartTime >= DatePickerWLscreen.SelectedDate And ScheduledStartTime <= DateAdd(
DatePickerWLscreen.SelectedDate,
1,
Days
)
)
)
),
"BuildingText",
Ascending,
"Title",
Ascending,
"IDText",
Ascending
)