It has taken me a good deal of browsing and meddling to get this flow to work. My main hurdles was:
move the file from SP to OD, rename it in OD, move it back to SP and delete any traces. This loop takes a template and produces a weekly report every friday. I hope it can help others or at least inspire to a more simple flow.
NB. It is eesential to use dynamic content in all the steps in this flow.
Disclaimer: The programme is messy and cumberhensome, I have used a lot of effort to get here since Flow is still limited with SP tools. And to be frank I am tired of this programme by now, Flow should have been able to do this simple operation much easier.
Solved! Go to Solution.