Announcements
I am basically building this exact flow Create Dataverse Links / URLs in HTML Tables using Power Automate — Amey Holden | ABC Enthusiast & Power Platform Specialist, but i want to find all the records that were created within the last 7 days. I am having issues with the date comparison in the filter records box.
CreatedOn = system column from Dataverse table. Format =
"2022-09-09T19:13:40Z"
Filter Rows code
CreatedOn gt subtractFromTime(utcNow(),7,'Day','F')
Error Message: Syntax error at position 20 in 'CreatedOn gt Friday, September 23, 2022 4:06:55 AM'.
@zachm
can you try this?
Microsoft.Dynamics.CRM.LastXDays(PropertyName='createdon',PropertyValue=7)
Hi @zachm ,
@Mira_Ghaly has a great option and another I use frequently is the FetchXML option as shown below (as an example). This worked successfully to pull the filtered list with only the attributes I selected. Of course this is an example from the Accounts table...
<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false"><entity name="account"><attribute name="name" /><attribute name="primarycontactid" /><attribute name="telephone1" /><attribute name="accountid" /><order attribute="name" descending="false" /><filter type="and"><condition attribute="createdon" operator="on-or-after" value="2022-01-16" /></filter></entity></fetch>
You can replace the hard coded date with a variable that you set of course as well...
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.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Haque 88
WarrenBelz 85 Most Valuable Professional
Valantis 45
