You’re offline. This is a read only version of the page.
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!
I've been searching for it for such a long time!!!
Thank you, @adgkred 🙂
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.
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
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
#1
mmbr1606
22
Super User 2025 Season 1
#2
stampcoin
19
#3
Michael E. Gernaey
17
Super User 2025 Season 1
Share
Report
All responses (
Answers (