Answered

Deleting the excel file in sharepoint after the data extracted to database

(0) Share

Report

Posted on by Community Power Pla...

Hi,

I want to know whether is it possible to delete the excel file that saving in share point on daily basis soon after the data are extracted to database.

This is for security purpose of the data, so that the data will no longer exist in Share Point.

If this is possible, please suggest me the way of doing it.

Thank you.

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (1)

Rhiassuring 8,690 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi there,

Yes, it is possible - but - it depends on what you'd need to trigger it. You've let us know that the data is being extracted to another database - how is that currently being done? If it's via a Power Automate flow, well, that's great - it'll be easy! If it's done through a script or something else, then you may need to find a time that will work daily, or something similar.

Cheers,

Rhia

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report
Copy link

Link copied!

Hi,
I'm still creating the trigger. The data in a excel sheet is daily being sending to a specific mail. And I'm planning to do is, get the data in the excel sheet through power automate and save it in a share point and extract the data to Azure database. And from the database get the data to power BI to report.
Once the data is transferred to the database, I want to delete those data in the Share Point as the data are confidential.

Hope you got clear.
Thank you

Was this reply helpful? Yes No
Verified answer

Rhiassuring 8,690 Moderator on at

Like (1)

Report
Copy link

Link copied!

Ah, yes, I see. So we want to delete the rows of data you've created FROM the sheet, out of SharePoint. If it's alright with you for it to end up in the Recycle Bin (yourself and site owners would be able to see it), you could just loop through the same data after and delete the items. I'm guessing the list you're using will ONLY contain this data, and then will be cleared daily as well - is this correct? You could just do a "Get items" on the list, get them all, then loop through and Delete Items.

You can also skip the Recycle Bin entirely using this method:

https://michelcarlo.com/2021/10/09/permanently-delete-sharepoint-list-items-using-power-automate-skip-the-recycle-bin/

Cheers,

Rhia

Was this reply helpful? Yes No
Community Power Pla... on at

Like (1)

Report
Copy link

Link copied!

Thank you so much. I'll try in this way

Was this reply helpful? Yes No