Power Platform Community Forum Thread Details

Filter for date

I have a Power Automate flow that sends me an email with a list of pages from my OneNote notebook that were created within the last seven days. Here's what I'm doing:

Loop through sections in the notebook.
Use "Get Pages for a Section" for each section.
Filter the pages to only include those created in the last seven days.

However, the filter always returns an empty array, even though the inputs contain pages with recent createdTime values. For example, one of the pages in the input is:

Here’s how I’ve set up the filter:

From Field:

body('Get_pages_for_a_specific_section')?['value']
Filter Condition:

@greaterOrEquals(item()?['createdTime'], variables('CutoffDate'))
Cutoff Date:
This is defined as a string variable using:

formatDateTime(addDays(utcNow(), -7), 'yyyy-MM-ddTHH:mm:ssZ')

The Problem:

The filter always returns an empty array.
I confirmed that the inputs to the filter include all the pages, and at least one page (Test page) has a recent createdTime (2024-12-21T10:49:52.458Z), so it should match

Any hints appreciated!

Many thanks,
Katharina

Categories:

Business Process Flows

Quick Links

Leaderboard > Power Automate