Announcements
How to truncate dataverse table using powerautomate schedule flow
Hi @dipanjan2021,
The most efficient way would be to leverage the BulkDelete action in Dataverse. You can use the Dataverse Perform an Unbound Action to find this action and just fill in the necessary query expression fields.
---Please click Accept as Solution if my post answered your question. This will help others find solutions to similar questions. If you like my post and/or find it helpful, please consider giving it a Thumbs Up.
As I can't select any table there it is not possible to truncate a particular table
You specify the table where it says QueryExpression - EntityName.
Another constrain I am facing that it requires recurrence parameter and startdatetime parameter what are they??
Recurrence Pattern is optional if you want it to be a recurring job. If you just want to run it one time you can specify an empty string (" ").
The start time allows you to delay it and schedule at a later time. If you want it to start right away, just specify the expression function utcNow().
Now it is showing this error
For the ToRecipients and CCRecipients, you can just specify an empty array (you can add a prior Initialize Variable action, setting the Type to array and leaving the Value empty). Optionally if you want to receive an email notification when completed, you can specify an array of user ids from the User table.
I have intialised two array type variables but the problem is where I need to assign the variables in "perform unbound action " action as I couldn't find any box there
Next to the activity party, click the Switch to input entire array button so that it collapses down to ToRecipients. Do the same for the activity party below it for CCRecipients.
It will look like this afterward, where you can populate your array variables:
Now it is showing this things
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.
11manish 530
WarrenBelz 459 Most Valuable Professional
Haque 314
