
Announcements
Hi!
I have gotten the WF to the point where I can extract a zipped email attachment, however, I want to take it a step further and have the .xls file in the Unzipped folder also extracted, so that it is not in its own folder.
Caveat is the filename sent daily in the Zipped folder is the same: "ItemErrorReport.xls". I would like it to be renamed with the date of the folder in the extracted xls so that it does not get replaced the next day.
How can I extract the unzipped folder containing the xls file then delete the extra folder?
WF
Folder with Name+Date
File
Goal:
Thank you!
Approach 1:
I would suggest rename the existing old excel file with filename_datetime.xls before extracting current zip file. You can add this step before extract the today's zip file.
Approach 2:
You can extract the file, rename the excel on daily basis. This should work, if you're setting the folder/ flow from the initial stage.
Approach 3:
You can extract, rename the zip file into temp folder on SharePoint Online and copy them into the actual SPE-Inventory folder.
Hope this helps.
Thanks,
Murali
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.