I am trying to create a Recurrence flow to create recurring tasks based on data store in a table.
I can see the table in the list rows option but it doesn't pull through any dynamic data so i can select the ones that need to be created today based on their run date.
Why can't i see the fields in the entity. Oh FYI it is a customer entity.
Thanks in advance Frostie
Hi Frostie8467,
Filter rows: Use to define an OData-style filter expression to narrow down the set of rows that Dataverse returns, such as "createdon ge 2021-01-01T00:00:00-00:00" for rows with createdon greater than or equal to the year 2021.
standard filter operators
Note: Filter expressions cannot contain this string, $filter=, because it only applies when you use the APIs directly.
You can refer following link for more details:
Use lists of rows in flows - Power Automate | Microsoft Docs
Filter today's date:
Power Automate Date Filtering on Today's Date - RSM Technology Blog (rsmus.com)
Hey Frostie,
Records from "Recurring Jobss" table will be available in the next step where you can use "Apply to each" with conditions to create tasks based on requirement.
In "List rows" you can specify the columns you need from that table , filter criteria or fetchXml, like we do in the webApis.
Thanks
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Mansi Soni as our August 2025 Community…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Abhilash Warrier 100 Super User 2025 Season 2
Suresh Kulla 72 Super User 2025 Season 2
DAnny3211 54