Dataverse

(0) Share

Report

Posted on by dipanjan2021

How to truncate dataverse table using powerautomate schedule flow

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (13)

Answers (1)

ChrisPiasecki 6,422 Most Valuable Professional on at

Like (1)

Report

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.

Was this reply helpful? Yes No
dipanjan2021 37 on at

Like (0)

Report

As I can't select any table there it is not possible to truncate a particular table

Was this reply helpful? Yes No
ChrisPiasecki 6,422 Most Valuable Professional on at

Like (0)

Report

Hi @dipanjan2021,

You specify the table where it says QueryExpression - EntityName.

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

Was this reply helpful? Yes No
dipanjan2021 37 on at

Like (0)

Report

Another constrain I am facing that it requires recurrence parameter and startdatetime parameter what are they??

Screenshot_2021-0...

IMG_20210428_1151...

Was this reply helpful? Yes No
ChrisPiasecki 6,422 Most Valuable Professional on at

Like (0)

Report

Hi @dipanjan2021,

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().

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

Was this reply helpful? Yes No
dipanjan2021 37 on at

Like (0)

Report

Now it is showing this error

Screenshot_2021-0...

Was this reply helpful? Yes No
ChrisPiasecki 6,422 Most Valuable Professional on at

Like (0)

Report

Hi @dipanjan2021,

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.

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

Was this reply helpful? Yes No
dipanjan2021 37 on at

Like (0)

Report

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

Was this reply helpful? Yes No
ChrisPiasecki 6,422 Most Valuable Professional on at

Like (0)

Report

Hi @dipanjan2021,

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:

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

Was this reply helpful? Yes No
dipanjan2021 37 on at

Like (0)

Report

Now it is showing this things

Screenshot_2021-0...

Was this reply helpful? Yes No