Next, use a Create File action, name the file as per your requirement and for the file content use the expression: base64ToBinary(outputs('ExcelDoc'))įinally, create add a new action by searching for HTTP and you should see this action:Īt the time of writing this post, this is a preview action and it is not available in all Office 365 Tenants. Next step is to create your Excel file and populate it with the data from your Select action:įirst, create a Compose action called ExcelDoc and paste in the Base64 representation of your template file. You can switch to Text mode by clicking on this:Ĭreate the Excel File and Populate with your Data It will download the query.iqy file to your computer. Trying to automate a series of interactions between Excel & PowerPoint for my team which require the Desktop open a sharepoint file from power automate. Your Select action may look a different to mine, because the default mode is Key/Value mode.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |