Unanswered

Clear all rows in a table in dataflow

(0) Share

Report

Posted on by UlricusR

Hi, I'm running a dataflow which creates a large table (let's call it result table) from various data sources as basis for reporting. I plan to run this dataflow once a day.

Issue: When running the dataflow, all results are appended to the existing result table. However, I'd like to clear all rows of the result table before, but do not find a matching command in the transformation user interface.

Desired behavior: Clear all result table rows as part of the daily dataflow before re-filling it with the new rows.

Any hint is highly appreciated!

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (4)

Answers (2)

Verified answer

adgkred 228 on at

Like (1)

Report

Hey @UlricusR,

I don't know if you can do it directly with the dataflow but here's an alternative solution:
In Power Apps go to Advanced Settings > Settings > Data Management > Bulk Record Deletion
Once there you can set up and schedule a daily bulk record deletion.

Hope it helps

Was this reply helpful? Yes No

Verified answer

AhmedSalih

6,678 Moderator on at

Like (0)

Report

Hello @UlricusR, you don't need to clear all the data if you have a primary key in your data source that won't change. Use the an Alternate key in your Dataverse table and make sure that use it in your mapping. This way when you run the dataflow, it will not create new records for those existing records with previous primary key, but it will change the other columns values if they have changed in the data source. It will also create new records for the new primary keys.

Check this tutorial to see how we create Alternate key and how we map it.

https://powerplatformplace.com/f/excel-to-dataverse-migration---part-1

If my reply helped you, please give a 👍 , & if it solved your issue, please 👍 & Accept it as the Solution to help other community members find it more.

I am primarily available on weekdays from 6-10 PM CT and 5-10 PM CT on weekends.

Visit my Blog: www.powerplatformplace.com

Was this reply helpful? Yes No

UlricusR 35 on at

Like (0)

Report

Hi @adgkred , thanks for the reply, this could indeed be a solution. I will, however, try the approach suggested by @AhmedSalih , it’s the cleaner alternative.

Was this reply helpful? Yes No
SZ-23070748-0 23 on at

Like (0)

Report

I've been searching for it for such a long time!!!
Thank you, @adgkred 🙂

Was this reply helpful? Yes No