I want to delete Opportunity Close Activities that are older than 6 years. I've created the flow for this and it says it suceeeds, but I dont see that the activities are being deleted.
What am I doing wrong? The condition is set to CreatedOn is greater than or equal to
Hey @nicole-dynamics
In the condition, use the function ticks to compare the time.
e.g., In the condition on the left input, click on expressions from the dynamic selector, type "ticks()" and in the bracket select the created on field from the dynamic content selector. Similarly wrap the subtract time function in the ticks() function.
Hope this Helps!
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!
So like this
condition
The created on will not work that way. Waht you can do is in the left input just select created on from the dynamic selector. Now tap into the left input box and select all (Ctrl A) and copy using ctrl c, now remove this and go to the expressions and type ticks() and paste the content within the bracket. from the content remove the '@' and any curly braces.
And then what goes into the right input box of the condition?
Hey @nicole-dynamics it will be ticks(subtract....).
The subtract function you already have wrapped inside of the ticks function.
Thank you for all of your assistance. I see that the flow succeeds but I dont actually see that it is deleting records based on the query I am doing in Dynamics CRM to validate.
Left input box :
I see a balnk condition branch in the flow. Can you please delete that and try again?
That is included by default and can not be removed. I have other flows where it is blank and it does not impact the flow.
Hi @nicole-dynamics ,
Yes I can see there are 512 records fetched for delete.
Try Settings of 'Apply to each' and set it execute in sequential. Lets see whether that works or not.
Thanks
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogPower Automate Video TutorialsCheck out new user group experience and if you are a leader please create your group
See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.
User | Count |
---|---|
45 | |
41 | |
38 | |
38 | |
32 |
User | Count |
---|---|
87 | |
84 | |
52 | |
48 | |
39 |