You’re offline. This is a read only version of the page.
Announcements
6
Hi,
I have a flow that automatically uploads an excel file to a SharePoint folder on daily basis.
File is uploaded with the same name everyday, so, the existing file gets replaced with the newly uploaded file that contains today's data.
Sometimes the newly uploaded file has system glitches and missing data, therefore contains less data than the currently existing file.
Is there a way to make a check if the file size (or row count) of the new file vs the existing file before uploading ? and prevent replacing the existing one, if the new one is of less size or less row count.
Thankful for your help and support.
Hi @mazer
One possibility is to save the size of the file or record counts in SharePoint custom list with date. This information will be saved by the recurrence flow before end of the flow. So, when a new instance of the recurrence trigger, it will first pick the size or records counts from the previous run date and compare with the current run. Based on the outcome of condition action, you could add the required action for further processing as per the need.
If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.
Thanks
Share
Report
All responses (
Answers (
