Creating Tables in Excel from a flow can be painful, but if you can create them using a script inside your Excel then that might quite well work. The run Script is more for small steps that you want to complete in an Excel. I wouldn’t recommend using this kind of scripting to develop full blown apps in Excel. I remember many years ago developing an app in Excel. If you want to learn about this scripting language in excel then you could always start by using the record option when you create a new script. Open your excel file on office online and you will notice the automate option.Ĭlick on the New Script and your first script is thereĪnd now when you try again we will see the Script 1 that we just created. What can we do with Scripts? Run Scripts in the Excel connector Now we got to a blank screen kind of thing!
This will Let users automate their tasks in Office on the web. In the admin center go to Setting -> Org settings and search for office scripts and then tick the box. To enable Office Scripts you will have to go to your Office 365 Admin Center. Within the sea of junk you might find the clue! When you start with this action you will most likely bump into the There’s a problem error.
