cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ChadBishop
Advocate I
Advocate I

Clone rows in Dataverse

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? 

ChadBishop_0-1668095272370.png

 

 

ChadBishop_1-1668095296770.png

 

 

It shows a successful run...

ChadBishop_2-1668095347403.png

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. 

ChadBishop_3-1668095744418.png

 

1 ACCEPTED SOLUTION

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". 

ChadBishop_5-1668108401464.png

 

ChadBishop_6-1668108509725.png

 

View solution in original post

2 REPLIES 2
srApps
Resolver III
Resolver III

If you were to remove the filter and view the output of the list rows, the createdon value will look like this

srApps_0-1668100097976.png

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". 

ChadBishop_5-1668108401464.png

 

ChadBishop_6-1668108509725.png

 

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (6,197)