Could you please show a bit more about WorkBook?
I suppose that you want to add a new excel file from OneDrive to WorkBook which is a Advertising SoftWare Suite automatically in Microsoft Flow. Is it true?
The WorkBook connector is not supported in Microsoft Flow currently, if you would like this feature to be added in Microsoft Flow, please submit an idea to Flow Ideas Forum:
It sounds a bit more complicated that what I meant:) I am not familiar with WorkBook as a tool.
In other words: my idea was to merge different excel files into one and make it not a one time event with the help of macros, but do it constantly as soon as new file is added to onedrive.
Or you are mentioning same?
I am doing this via Power Query and I adore this option:-)
This will work only if your file structure are identical.
You can check this option from Data tab --> Get Data --> From File --> From Folder
Here you enter folder path, where your files are stored and then Edit your File template from any file in the folder.
After finalizing transormation process, all your files are in one table.
Whenever you are adding or removing files, all these updates will be reflected in summary table.
Let me know if you need any other assistance.
Fill out a quick form to claim your user group badge now!
We've given our badges an overhaul and also added some brand new ones!
Learn how to build the business apps that you need.
Find out where you can attend!
Watch & learn from the Power Automate Community Video Gallery!