20
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.
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
#1
André Arnaud de Cal...
291,431
Super User 2024 Season 2
#2
Martin Dráb
230,503
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
