In short, I'm creating an Automated FLOW to run daily at midnight. The purpose it so copy "yesterday's" records and create them for "today" and allowing the dataverse field "createdon" default to "today's date". The FLOW runs successfully but no new rows are created.
Below is my FLOW design. What am I missing?
It shows a successful run...
Output Status Reason = 200 but I can't view anything it returned. The Apply To Each shows a successful run but grayed out like there was no input data.
Accepted Solutions
Thank you @srApps !
After posting this question, I thought that the time being excluded would be assumed in the filter as you described. Once I made my modifications to include the time, the FLOW ran successfully and copied my rows from "yesterday" to "today".
If you were to remove the filter and view the output of the list rows, the createdon value will look like this
It includes the time as well which is why the eq filter isn't returning any data. You could instead use a filter query like this to, for example, get rows created on 11-04:
createdon lt '2022-11-05' and createdon gt '2022-11-04'
As far as I can tell, if you just put a date it uses T00:00:00Z for the time.
Thank you @srApps !
After posting this question, I thought that the time being excluded would be assumed in the filter as you described. Once I made my modifications to include the time, the FLOW ran successfully and copied my rows from "yesterday" to "today".
Helpful resources
Power Automate News & Announcements
Keep up to date with current events and community announcements in the Power Automate community.
Community Calls Conversations
A great place where you can stay up to date with community calls and interact with the speakers.
