Hi,
I am using Flow to pull excel advertising reports from daily emails and put them into OneDrive (for those to be read by PowerBI). Every time a new report arrives, it overwrites the old one. Unfortunately some reports have become exceedingly large (using "all time" reporting window) and started to fail to pull older data (advertising platform issue).
I'm trying to find out if it'd be possible for me to use "last 7 days" reporting window in those reports, and - instead of overwriting the existing file entirely - only to overwrite data of the past 7 days.
Each day has multiple rows in those reports as there are further hierarchies beyond date involved in reporting.
Would existing functionality of Flow allow me to achieve this, or should I look elsewhere for solution?
Thanks for your advise!