Power Platform Community Forum Thread Details

I'm using Get Calendar View of Events (V3), and I'm using a filter array to just show today's events. I've been around and around with this, and can't figure it out. I'm getting yesterday's all-day events, and tomorrow's all-day events.

Here's my filter:

@and(
    or(
        and(
            not(equals(item()?['isAllDay'], true)),
            lessOrEquals(
                convertFromUtc(formatDateTime(item()?['start'], 'yyyy-MM-ddTHH:mm:ssZ'), 'Eastern Standard Time'),
                formatDateTime(convertFromUtc(utcNow(), 'Eastern Standard Time'), 'yyyy-MM-ddT23:59:59')
            ),
            greaterOrEquals(
                convertFromUtc(formatDateTime(item()?['end'], 'yyyy-MM-ddTHH:mm:ssZ'), 'Eastern Standard Time'),
                formatDateTime(convertFromUtc(utcNow(), 'Eastern Standard Time'), 'yyyy-MM-ddT00:00:00')
            )
        ),
        and(
            equals(item()?['isAllDay'], true),
            lessOrEquals(
                convertFromUtc(formatDateTime(item()?['start'], 'yyyy-MM-ddTHH:mm:ssZ'), 'Eastern Standard Time'),
                formatDateTime(convertFromUtc(utcNow(), 'Eastern Standard Time'), 'yyyy-MM-ddT23:59:59')
            ),
            greaterOrEquals(
                convertFromUtc(formatDateTime(item()?['end'], 'yyyy-MM-ddTHH:mm:ssZ'), 'Eastern Standard Time'),
                formatDateTime(convertFromUtc(utcNow(), 'Eastern Standard Time'), 'yyyy-MM-ddT00:00:00')
            )
        )
    )
)

Please help!

Categories:

Building flows

Please try this

@and(
or(
and(
not(equals(item()?['isAllDay'], true)),
lessOrEquals(
convertFromUtc(item()?['start'], 'Eastern Standard Time'),
formatDateTime(convertFromUtc(utcNow(), 'Eastern Standard Time'), 'yyyy-MM-ddT23:59:59')
),
greaterOrEquals(
convertFromUtc(item()?['end'], 'Eastern Standard Time'),
formatDateTime(convertFromUtc(utcNow(), 'Eastern Standard Time'), 'yyyy-MM-ddT00:00:00')
)
),
and(
equals(item()?['isAllDay'], true),
lessOrEquals(
formatDateTime(convertFromUtc(item()?['start'], 'Eastern Standard Time'), 'yyyy-MM-dd'),
formatDateTime(convertFromUtc(utcNow(), 'Eastern Standard Time'), 'yyyy-MM-dd')
),
greaterOrEquals(
formatDateTime(convertFromUtc(item()?['end'], 'Eastern Standard Time'), 'yyyy-MM-dd'),
formatDateTime(convertFromUtc(utcNow(), 'Eastern Standard Time'), 'yyyy-MM-dd')
)
)
)
)