Power Automate Exchange

Please login or click SIGN UP FOR FREE to create your FlowUG account to join this user group.
 View Only
  • 1.  Filter items based on Created "Today"

    Gold Contributor
    Posted Jun 23, 2022 11:01 AM
      |   view attached
    I have a request to get all the items submitted today and send an email at the end of the day with the items displayed in a table. The issue I'm running into is that when I run the Flow at 11:55pm each night, my Get Items action doesn't capture items created today. I'm using this Filter Query expression and on Eastern Time.

    Filter query with Expression: Created ge 'startOfDay(addHours(utcNow(),-5), 'yyyy-MM-ddTHH:mm:ssZ')' and Created lt 'startOfDay(addHours(utcNow(),-5), 'yyyy-MM-ddTHH:mm:ssZ')'
    See also screen shot.

    I'm totally stumped as to why this isn't working. I originally had the Filter Query expression set to a slightly different expression - Created ge 'startOfDay(utcNow(), 'yyyy-MM-ddTHH:mm:ssZ')' - and changed the recurrence to run at 6PM ET. That worked, but that's not desired because some items may be submitted after 6PM ET.

    Beth Beck
    O365 Business Analyst
    Fort Myers FL

  • 2.  RE: Filter items based on Created "Today"

    Top Contributor
    Posted Jun 24, 2022 06:53 AM

    take time out of the equation and format the date time to date only, and try filtering that way.

    I think your problem is your filter expression has the same value. So it is impossible to satisfy the query.

    Created ge 12:00am and Created lt 12:00

    Created ge 'startOfDay(addHours(utcNow(),-5), 'yyyy-MM-ddTHH:mm:ssZ')' and
    Created lt   'startOfDay(addHours(utcNow(),-5), 'yyyy-MM-ddTHH:mm:ssZ')'

    Sam Duval
    Data Quality Analyst
    Element Financial
    Indianapolis IN