Answered

Extract zip from email, rename file and replace the master file on sharepoint

(2) Share

Report

Posted on by Gamst

Hi All!

I'm trying to update an existing file which my powerBI model gets its data from. So when a new zipped file arrives, i want it to replace the existing file and delete the zip file. The whole extract the zip and store it to sharepoint was no problem, but the renaming and replacing (and cleaning up the zip etc.) is giving me a headache. Anyone tackled this issue before? Could really use som help here.

Thanks in advance.

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

CFernandes 8,482 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hey mate, Would it not be easier to first delete the file and then add the new file? You can use the "Delete File" action in SharePoint. If you have difficult in getting the file, you can use the "Get File" or "Get Files" action.

In the "Get files" action you can use a filter query and get the old file using the "Name".

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

P.S. take a look at my blog here and like & subscribe to my YouTube Channel thanks.

Was this reply helpful? Yes No
Gamst 14 on at

Like (0)

Report
Copy link

Link copied!

Hi CFernandes

Thanks for the answer, deleting the file before extracting the new one would probably be easier yes. I appologize for bad phrasing in my question, not my native language. But the main issue for me is renaming the file after extracting it so that it maches the filename/path the PowerBI model uses to colletct data.

Was this reply helpful? Yes No
Suggested answer

Michael E. Gernaey 53,969 Moderator on at

Like (2)

Report
Copy link

Link copied!

Hi,

You should be able to use the Move file SharePoint action and configure it to replace the existing file.

I don't see your flow so I am not sure what headaches you are getting from what you are trying.

But I would take the zip, unzip it. Take the file you want to replace in the other location and simply use the Move, where you can rename it and copy over the other in one step.

As for deleting, its possible that what you need to do is put a long Wait action, because once you open stuff etc it can be locked. So add this before you try to delete.

Also I do NOT recommend deleting the file on the power bi side first and then copying. Replace it to trigger Power Bi's internal mechanisms.

Was this reply helpful? Yes No
Gamst 14 on at

Like (0)

Report
Copy link

Link copied!

FLMike, Thank you for the answer!

Was this reply helpful? Yes No