Seeing many request for Dynamic Content in Excel. Please add the ability to get dynamic content in the file field so we can perform operations from newly created Excel Files.
I've tried to build a scenario where every end of the month flow will duplicate a blank excel (since it's not possible to create new ones ffom flow) and create a table to fill with SQL data form our ERP.
In a simple manner, imagine to send automatically to your accountant a resume in excel files, from invoices; purchases; payments. Super easy to implement and super effective in a company daily tasks.
I've stumbled with this unability from excel connector where you onlty are able to fill in, create tables, remove data if the file is picked up manually from the drop down menu.
It means someone, every month need to go inside the flow and programe it for a certain excel.
Why does Microsoft leaves their own connectors actions "excel, sharepoint; and so on..." halfway in terms of development. In the past i saw more and better actions in Google drive connector rather onedrive.
I know it's on preview, but i think ti would be a huge improvement for this connector