Hi all,
I have a flow that at the end has 5 output tools that write to 5 excel tabs. I also have a formula included to make a file name based on a column which I use in the end to write to different files.
Let me put it easier: I have data for 3 countries mixed and in the end my flow writes this in 3 excel sheets with each 5 tabs:
1 file for Belgium with 5 tabs with on each tab an analysis
1 file for Germany with the same 5 tabs, but with of course data about Germany
and 1 file for Spain with the Spanish data on those 5 tabs.
The 3 files have a certain layout. I've added some comments on top, I've used some nice colors, the column width (this is an important one) is how I like it so it is easy to read. So I each time I run the flow it overwrites a certain range and the layout stays the same.
In the future we would like to move our flow to the server version. So then I will not be able to start from a template.
Other option I thought about is the reporting section and rendering to an excel file. With reporting I can put the text on top and have the desired layout.
However, I cannot find a way to split up the files based on a certain filter.
Goal is in the end to either run this for all countries and I would have 3 excel output files (for Belgium, Germany and Spain) or even to have a certain input field in the server version where you can put/pick the country and you would get 1 excel output file.
Issue is that without the template, I do not see a way to have a nice looking excel output file. And if I use the reporting/rendering function I do not know how to automatically divide the data over the different country files.
Is there anyone that might have an idea on how to solve this?
Kind regards,
Tienemientje
