News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics 365 | Integration, Dataverse... Data Import - Source F...

Microsoft Dynamics 365 | Integration, Dataverse...

Suggested answer

Data Import - Source File Archive

(0) Share

Report

Report

Posted on by John Holmes

260

Hi

I would like to to set up a Flow to archive our Import Source Files as they are taking up valuable space in the DB but I am struggling to see if it's actually possible.

Ideally I could set a Flow on a schedule to list records in the Import table, extract the file and create it in blob storage, then create a record in Azure Table Storage with the main attributes (file name, entity table, person who imported it etc.) then delete the record from the import table.

Sounds simple but I can't find a way of extracting the source file.

Any ideas?

Thanks

All responses Img

All responses (2)

Answers Img

Answers (0)

John Holmes 260 on at

Like (0)

Report

RE: Data Import - Source File Archive

As I thought.

Not sure on why the file is stored after the import at all if it can't be retrieved - doesn't make sense.

I'll go my my flow for managing the deletes, at least that way I will have a record that the import took place, how many records were affected and who was responsible for the import.

thanks anyway.
Suggested answer

Nya 29,056 on at

Like (0)

Report

RE: Data Import - Source File Archive

Hi,

It cannot be achieved unfortunately.

But you can refer to the following section to free up your storage simply.

Delete bulk import instances using a bulk deletion job

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2

Martin Dráb 230,214 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Get batch job history log from D365 FO to Power Automate

Product updates

Dynamics 365 release plans