Bulk Delete for Dataverse using Power Automate for Dataflow Run

Case Use: Power App exports a file that is created after a button is clicked.  The Power Automate clears out the dataverse table, refreshes a dataflow, writes it to the clean dataverse table, then a csv file is created from the dataverse table and placed in a sharepoint document library.

This is only the Bulk Delete Action of my Power Automate. (Perform an Unbound action/ Dataverse Action)
 

1. Select "BulkDelete" for the Action Name

2. Enter your dataverse table's logical name in the "QueryExpressionEntityName1" field. (Towards the bottom)
You can find your table's logical name in your table's properties in the advance section.

3. Job name. Call it what you'd like and it is recommended to add a formatDateTime expression to capture the time the bulk delete happened.
My expression: formatDateTime(utcNow(), 'yyyy-MM-ddHH:mm')

4. TRICKY!  These fields that are required are collapsed by default. 
Click the "T" icon to open

5. Enter opening and closing square brackets in these field.

6. Enter the below expression in the RecurrencePattern field.
Expression: base64ToString('')

7. Use the below date expression in the StartDateTime.
Expression: utcNow()

 

Results

Blog Type: