web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Creating Excel File wi...
Power Automate
Unanswered

Creating Excel File with File Content That with the right extension

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

In my flow, A user drops a file in a folder. This then creates a variable which leads to a new folder with the file name in my sharepoint site. I then want to create an excel sheet that is blank but I see that it requires some sort of file content. When I put file content such as the file name for example I get an error message. My flow is below along with the error message.Capture2.JPG

Capture.JPG

Is there a way to input no file content because I need it to be blank and add information later on in the flow and what extension should I use? 

Categories:
  • ccc333ab Profile Picture
    1,144 on at

    I would suggest having a blank excel spreadsheet act as your template. Then: 

     

    1. Use a Get File Content and grab the file content from that blank template

    2. Use this file content in your Create File action. 

     

  • DamoBird365 Profile Picture
    8,942 Microsoft Employee on at

    Hi @Anonymous 

     

    Here's another method for you, very similar to @ccc333ab suggestion but you can stick the output of a get file content into a compose and then dump the excel file - never needing an empty file again.

     

    If you copy/paste the below into your clipboard in flow, new step-> my clipboard, you will get a scope with a demo to run.  All you need to do is update the paths for output.  This will create an excel file, a table and add a row with no get file or need for a blank file anywhere.

     

    {"id":"828c86fe-7418-4d70-aa6b-e45b-8d06406d","brandColor":"#8C3900","connectionReferences":{"shared_excelonlinebusiness":{"connection":{"id":"/providers/Microsoft.PowerApps/apis/shared_excelonlinebusiness/connections/shared-excelonlinebu-47960226-b338-4d03-bbc1-dcfb-43cc2fda"}},"shared_sharepointonline":{"connection":{"id":"/providers/Microsoft.PowerApps/apis/shared_sharepointonline/connections/shared-sharepointonl-69698088-5a9b-45c7-9260-eb06-f3fbc03b"}}},"connectorDisplayName":"Control","icon":"data:image/svg+xml;base64,PHN2ZyB3aWR0aD0iMzIiIGhlaWdodD0iMzIiIHZlcnNpb249IjEuMSIgdmlld0JveD0iMCAwIDMyIDMyIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPg0KIDxwYXRoIGQ9Im0wIDBoMzJ2MzJoLTMyeiIgZmlsbD0iIzhDMzkwMCIvPg0KIDxwYXRoIGQ9Im04IDEwaDE2djEyaC0xNnptMTUgMTF2LTEwaC0xNHYxMHptLTItOHY2aC0xMHYtNnptLTEgNXYtNGgtOHY0eiIgZmlsbD0iI2ZmZiIvPg0KPC9zdmc+DQo=","isTrigger":false,"operationName":"Create_An_Excel_File_with_DamoBird365","operationDefinition":{"type":"Scope","actions":{"ExcelFile":{"type":"Compose","inputs":{"$content-type":"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet","$content":"UEsDBAoAAAAAAAAAIQD/////UQEAAFEBAAAQAAAAW3RyYXNoXS8wMDAxLmRhdP////8AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAABQSwMECgAAAAAAAAAhAP/////vAAAA7wAAABAAAABbdHJhc2hdLzAwMDMuZGF0/////wAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAABQSwMEFAAGAAgAAAAhAGFJCRCJAQAAEQMAABAAAABkb2NQcm9wcy9hcHAueG1snJJBb9swDIXvA/ofDN0bOd1QDIGsYkhX9LBhAZK2Z02mY6GyJIiskezXj7bR1Nl66o3ke3j6REndHDpf9JDRxVCJ5aIUBQQbaxf2lXjY3V1+FQWSCbXxMUAljoDiRl98UpscE2RygAVHBKxES5RWUqJtoTO4YDmw0sTcGeI272VsGmfhNtqXDgLJq7K8lnAgCDXUl+kUKKbEVU8fDa2jHfjwcXdMDKzVt5S8s4b4lvqnszlibKj4frDglZyLium2YF+yo6MulZy3amuNhzUH68Z4BCXfBuoezLC0jXEZtepp1YOlmAt0f3htV6L4bRAGnEr0JjsTiLEG29SMtU9IWT/F/IwtAKGSbJiGYzn3zmv3RS9HAxfnxiFgAmHhHHHnyAP+ajYm0zvEyznxyDDxTjjbgW86c843XplP+id7HbtkwpGFU/XDhWd8SLt4awhe13k+VNvWZKj5BU7rPg3UPW8y+yFk3Zqwh/rV878wPP7j9MP18npRfi75XWczJd/+sv4LAAD//wMAUEsDBAoAAAAAAAAAIQD/////OQEAADkBAAAQAAAAW3RyYXNoXS8wMDAwLmRhdP////8AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAABQSwMECgAAAAAAAAAhAP/////qAAAA6gAAABAAAABbdHJhc2hdLzAwMDIuZGF0/////wAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAUEsDBBQABgAIAAAAIQCfiOttlgIAAAQGAAANAAAAeGwvc3R5bGVzLnhtbKRUW2vbMBR+H+w/CL27st04S4LtsjQ1FLoxaAd7VWw5EdXFSErnbOy/78iXxKVjG+2Ldc7x0Xe+c1N61UqBnpixXKsMRxchRkyVuuJql+GvD0WwwMg6qioqtGIZPjKLr/L371LrjoLd7xlzCCCUzfDeuWZFiC33TFJ7oRum4E+tjaQOVLMjtjGMVtZfkoLEYTgnknKFe4SVLP8HRFLzeGiCUsuGOr7lgrtjh4WRLFe3O6UN3Qqg2kYzWqI2mpt4jNCZXgSRvDTa6tpdACjRdc1L9pLrkiwJLc9IAPs6pCghYdwnnqe1Vs6iUh+Ug/IDuie9elT6uyr8L2/svfLU/kBPVIAlwiRPSy20QQ6KDbl2FkUl6z2uqeBbw71bTSUXx94ce0PXn8FPcqiWNxLPYzgsXOJCnFjFngAY8hQK7phRBShokB+ODYRXMBs9TOf3D++doccoTiYXSBcwT7faVDCL53qMpjwVrHZA1PDd3p9ON/DdauegZXlacbrTigqfSg9yEiCdkglx7+f1W/0Mu62ROshCutsqwzD5vgijCIkMYo/XKx5/itZjvxkWtfVzfECc0H5G+hQe+X5n+LNfMAGTM0Cg7YELx9UfCANm1Z5LEPoOOL8sXXFOUaASFavpQbiH088Mn+VPrOIHCUs1eH3hT9p1EBk+y3e+U9Hcx2Ctu7MwXnCig+EZ/nmz/rDc3BRxsAjXi2B2yZJgmaw3QTK7Xm82xTKMw+tfk619w852L0yewmKtrIDNNkOyA/n7sy3DE6Wn380o0J5yX8bz8GMShUFxGUbBbE4XwWJ+mQRFEsWb+Wx9kxTJhHvyylciJFE0vhJtlKwcl0xwNfZq7NDUCk0C9S9JkLET5Px8578BAAD//wMAUEsDBBQABgAIAAAAIQB1PplpkwYAAIwaAAATAAAAeGwvdGhlbWUvdGhlbWUxLnhtbOxZW4vbRhR+L/Q/CL07vkmyvcQbbNlO2uwmIeuk5HFsj63JjjRGM96NCYGSPPWlUEhLXwp960MpDTTQ0Jf+mIWENv0RPTOSrZn1OJvLprQla1ik0XfOfHPO0TcXXbx0L6bOEU45YUnbrV6ouA5OxmxCklnbvTUclJquwwVKJoiyBLfdJebupd2PP7qIdkSEY+yAfcJ3UNuNhJjvlMt8DM2IX2BznMCzKUtjJOA2nZUnKToGvzEt1yqVoBwjkrhOgmJwe306JWPsDKVLd3flvE/hNhFcNoxpeiBdY8NCYSeHVYngSx7S1DlCtO1CPxN2PMT3hOtQxAU8aLsV9eeWdy+W0U5uRMUWW81uoP5yu9xgclhTfaaz0bpTz/O9oLP2rwBUbOL6jX7QD9b+FACNxzDSjIvu0++2uj0/x2qg7NLiu9fo1asGXvNf3+Dc8eXPwCtQ5t/bwA8GIUTRwCtQhvctMWnUQs/AK1CGDzbwjUqn5zUMvAJFlCSHG+iKH9TD1WjXkCmjV6zwlu8NGrXceYGCalhXl+xiyhKxrdZidJelAwBIIEWCJI5YzvEUjaGKQ0TJKCXOHplFUHhzlDAOzZVaZVCpw3/589SVigjawUizlryACd9oknwcPk7JXLTdT8Grq0GeP3t28vDpycNfTx49Onn4c963cmXYXUHJTLd7+cNXf333ufPnL9+/fPx11vVpPNfxL3764sVvv7/KPYy4CMXzb568ePrk+bdf/vHjY4v3TopGOnxIYsyda/jYucliGKCFPx6lb2YxjBAxLFAEvi2u+yIygNeWiNpwXWyG8HYKKmMDXl7cNbgeROlCEEvPV6PYAO4zRrsstQbgquxLi/BwkczsnacLHXcToSNb3yFKjAT3F3OQV2JzGUbYoHmDokSgGU6wcOQzdoixZXR3CDHiuk/GKeNsKpw7xOkiYg3JkIyMQiqMrpAY8rK0EYRUG7HZv+10GbWNuoePTCS8FohayA8xNcJ4GS0Eim0uhyimesD3kIhsJA+W6VjH9bmATM8wZU5/gjm32VxPYbxa0q+CwtjTvk+XsYlMBTm0+dxDjOnIHjsMIxTPrZxJEunYT/ghlChybjBhg+8z8w2R95AHlGxN922CjXSfLQS3QFx1SkWByCeL1JLLy5iZ7+OSThFWKgPab0h6TJIz9f2Usvv/jLLbNfocNN3u+F3UvJMS6zt15ZSGb8P9B5W7hxbJDQwvy+bM9UG4Pwi3+78X7m3v8vnLdaHQIN7FWl2t3OOtC/cpofRALCne42rtzmFemgygUW0q1M5yvZGbR3CZbxMM3CxFysZJmfiMiOggQnNY4FfVNnTGc9cz7swZh3W/alYbYnzKt9o9LOJ9Nsn2q9Wq3Jtm4sGRKNor/rod9hoiQweNYg+2dq92tTO1V14RkLZvQkLrzCRRt5BorBohC68ioUZ2LixaFhZN6X6VqlUW16EAauuswMLJgeVW2/W97BwAtlSI4onMU3YksMquTM65ZnpbMKleAbCKWFVAkemW5Lp1eHJ0Wam9RqYNElq5mSS0MozQBOfVqR+cnGeuW0VKDXoyFKu3oaDRaL6PXEsROaUNNNGVgibOcdsN6j6cjY3RvO1OYd8Pl/EcaofLBS+iMzg8G4s0e+HfRlnmKRc9xKMs4Ep0MjWIicCpQ0ncduXw19VAE6Uhilu1BoLwryXXAln5t5GDpJtJxtMpHgs97VqLjHR2CwqfaYX1qTJ/e7C0ZAtI90E0OXZGdJHeRFBifqMqAzghHI5/qlk0JwTOM9dCVtTfqYkpl139QFHVUNaO6DxC+Yyii3kGVyK6pqPu1jHQ7vIxQ0A3QziayQn2nWfds6dqGTlNNIs501AVOWvaxfT9TfIaq2ISNVhl0q22DbzQutZK66BQrbPEGbPua0wIGrWiM4OaZLwpw1Kz81aT2jkuCLRIBFvitp4jrJF425kf7E5XrZwgVutKVfjqw4f+bYKN7oJ49OAUeEEFV6mELw8pgkVfdo6cyQa8IvdEvkaEK2eRkrZ7v+J3vLDmh6VK0++XvLpXKTX9Tr3U8f16te9XK71u7QFMLCKKq3720WUAB1F0mX96Ue0bn1/i1VnbhTGLy0x9Xikr4urzS7W2/fOLQ0B07ge1Qave6galVr0zKHm9brPUCoNuqReEjd6gF/rN1uCB6xwpsNeph17Qb5aCahiWvKAi6TdbpYZXq3W8RqfZ9zoP8mUMjDyTjzwWEF7Fa/dvAAAA//8DAFBLAwQUAAQACAAQM6lOz+ATSvYBAADXAwAADwAAAHhsL3dvcmtib29rLnhtbKyTzY7aMBDH7/sUlu/BSQhZQAmrUqiKVFXVLt09m8QhFv6IbKeAqj7ZHvpIfYWOkw2l3cse6ovH48xv5u+Z/Hr+md2dpEDfmLFcqxxHoxAjpgpdcrXP8dfth2CKkXVUlVRoxXJ8ZhbfLW6yozaHndYHBPHK5rh2rpkTYouaSWpHumEKbiptJHVwNHtiG8NoaWvGnBQkDsOUSMoV7glz8xaGripesJUuWsmU6yGGCeqgelvzxg40WbwFJ6k5tE1QaNkAYscFd+cOipEs5pu90obuBKg+RZOBDOYrtOSF0VZXbgQo0hf5Sm8UkijqJS9uEKys4oI99k+PaNN8ptKnEhgJat265I6VOU7hqI/sL4dpm2XLBdxGSRKHmLwAh6Z8MahkFW2F20I7hhzwdZqEUXT53PfvkbOj7cO7mgaE96PTE1elPuYYpuJ8ZR879xMvXZ3jOI5TuO99Hxnf1w4yxWkyuSQi/2TKuim4Tts5kOpe4MGPSARj5/eNF4mRmXMwzKb8Uz25hmQFFQXI9lsXksazaHwpgJ3cJ+uuZIIDtYbn+HuUhO9uw1kShOvxJEimsziYJuM4eJ+s4vXkdr1aLyc//n/z/WP7lcE8zYdH9wJqatzW0OIAf+A9q5bUwlBcVHchBKp/6bg3O2UZGSCL3wAAAP//AwBQSwMEFAAEAAgAB1LmRkZwAQt8AQAAngIAABgAAAB4bC93b3Jrc2hlZXRzL3NoZWV0MS54bWyM0s1u2zAMAOB7n0LQvZbTresaxAkGBMF6KDBs6+60TNtCJNGQmKZ5th32SHuF0XYTDOilN1OmPvBHf3//WW1eglfPmLKjWOlFUWqF0VLjYlfpp5+7689aZYbYgKeIlT5h1pv11epIaZ97RFYCxFzpnnlYGpNtjwFyQQNG+dNSCsASps7kISE006XgzU1ZfjIBXNSzsEzvMahtncUt2UPAyDOS0ANL+bl3Qz5rwb6HC5D2h+HaUhiEqJ13fJrQM/Oy+AhvpeBsokwtF3LTzDW9be/e3BuwWgW7fOgiJai9DHAS9fpKqVXjpIlx8CphW+kvC22m82lEvxwe8xhK4uVAMdQ/0KNlbGRbWo1rqIn2Y/aDHJWvhLlcmYxZ2E3L+JZUgy0cPH+n41d0Xc9C3UrHY6/L5rTFbGW4ghU3t/+XtAWGucIBOnyE1LmYlcd2yr3TKs1YWcg30zAKdwLXxEzhHPXyCFCWXRYftGqJ+BwIvTKXd7X+BwAA//8DAFBLAwQUAAYACAAAACEA+Chgbz8BAABbAgAAEQAAAGRvY1Byb3BzL2NvcmUueG1slJJfa8IwFMXfB/sOJe9tWkUnoa2wiU8TBnM49haSaw02f0iyVb/90la7Cr7sMfec+7vnXpIvT7KOfsA6oVWBsiRFESimuVBVgT6263iBIuep4rTWCgp0BoeW5eNDzgxh2sKb1QasF+CiQFKOMFOgg/eGYOzYASR1SXCoIO61ldSHp62woexIK8CTNJ1jCZ5y6ilugbEZiOiC5GxAmm9bdwDOMNQgQXmHsyTDf14PVrq7DZ0yckrhzybsdIk7ZnPWi4P75MRgbJomaaZdjJA/w5+b1/du1Vio9lYMUJlzRpgF6rUtV1QKUDttjzkeldsT1tT5Tbj2XgB/Ppc5vlPjrAve44BHIQrpg1+V3fRltV2jcpJmszidx+lsmy1I9kQm6Vc78qa/jdYX5GXwv4jzEfEK6HPffofyFwAA//8DAFBLAwQUAAYACAAAACEAVymYAx4HAAD5IAAAEwAoAGN1c3RvbVhtbC9pdGVtMS54bWwgoiQAKKAgAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAxFrbbts4EH1foP8gaJ9j+R7bqFMkcQsESNpiYyz2raBJKuZWElWSSpy/3yElUhfflRSbPCSWOMOZM7dDJh8/beLIe6ZCMp7M/V6n63s0wZyw5GnuZyq8mPifrj5iNcM8UTRRy9eUPuI1jZEHD3/Mfd+LkftZWfQVxXTuLzjOYhAzqypv7xZzv7vp9uC7211cDqafLyeL0efxdDScXE/H4+l0MLy9uV5cT2/6Tdm/rbWj5psFlViwVBlfbgVFinrIS+iLRwo7Ok2RR8xTsNM8LmDQtqE+HYwRGWFyueoR2hsPQoomk+6Q0AkK0dD3ALdEzrCa+2ul0lkQSIOK7MQMCy55qDqYxwEPQ4Zp0O92x0FMFSJIoaAChFUUozaKUgHWC8WoNMqvlRJslSkq/asPf3zcSDLLrfIUEk9U6ZjIFGFw+Hyjy70MWIJz8F2JjJqPIaMRkSasU9Qdhb2Qjlej7qQXDnAfhfCsNyTT/uoSoEtkP8+YHEMw09nz8vLSeRl0uHjSkPWCfx7u82yzOG3k6WtTt/SM2FTdzO0Dc+f+sN9FeEImF3hF6cUQDcYXq/4UX4xxdzhZjcLBZEgc6CxOuVBeUsJ9knhgg0YjqovGKJj7FYvsAsisNKIbXYz2kaS/Mqhc97muw+b/A0rQk1HujN2hC0WRVWvVCBrOfR24hyxS7J4lOuws+YZxJiAkXX/L+FKCEoYeqXiGQngoSqCV8Bck1dkKlussXiWIRbu2DHSJFN6a3xtgmGcFBBoR87mK9OlCpjtYVPdV5Ulp4hUGfeEiXtAQQUDm/q8MRQyKkJSF8puqisRlCR6vq+3ECxRkrbRmpvi0ImVJyFOk1rotXAbfkVAJFbcwkwSPym63XXgn97m9hrrEbqf8sOFOua0z3TPmfrXI0IwlhG7m/gQ6J4sitIpghWu8hMk0Qq/5uG3KKSoSFDXfuSwEjyJabSKCSpggWA9Qb4Uk7APRnn3lirp2EaPNPU2e1Np7RlEGK/qjUV78phYqGsqCqe3TrCldgg3vdzcMB8T0BCD2qVgzQigwHYcfA1pTAWmfHJAJ8i2JXgvJVhCaYOct5A2INLqgQ6UH1O1oflTc29JzBjRbsv8vPNUeX+IBxPEYHnXBEBoqgl66AFZF+EtiiE09P0qBczNgSTfq9xVRnlUnzZhGRwQCmQDPyX2XhnkBQ/wJLGGLtAp6UeEix8YQsmS0NqeypDKpVhHHP90I+xMGcTEWtmZCeytbcUzmDNhLSC9YIhUCwmUnGSknWZqJyCBJcFC0Nhn0Or2gXAtNpzJHqwLmjVvJYS45Y3aPW5uhAV8doqBF3KtbNWzL1d9zjPITVCFBslXE4EwoqPGpMCIAYGXwCzyEiTwIusOg2w8I7kA7L7ng3pFZtcI6/B7bG111G+qzRbvx3Z2afE+Tkbl/u/zReOEGc4URFnx8e7HtBft4M8EzrE+jXDRIKJydN5ZC90rYrMmGQhNsnMo1aH5Xo92naZgxGHpK88MzLcjpSO28emD7Ak090TWPSJ6KDmroC4wnuCmo0RXN3/Q5R1OQvd7PFFNR87RRd1srLkgSHC+buyyNvAtoA9yZzFb/Uqza4UrKG4fzFOTA/qSvL1wQYMNnobrXlwglTxm07oP6tqSLIMNtyRMXrwdltyO8R1txl/I+ygR9ZvqC6kxtriyThCvT0+wTS/btQ2/P13LNZM5zPcgvBo2RSk+tqZfAoZIKj4eeRM/wjAvPGik73hJWoDSNtICm0qAEeHHKE8mAvHswa70shZsgqBDQ5rZAIVS6RxFeO2WdD3/sMi0/iDa9yJ+imrfH2XakT9Vw4acPjzdvjn6tZcWF2oNx25NARc95hMBlrerDeH7sbJ/PnDwt3nRXdviY9w5cKecx73NcLi4vT7pLK7CxXTPvFd/hChbKsXhXGZEWydpllDvemeRI8WxRnlkbqXGlc9iub2xtpa8x5lmi7pqj8AxZM3DqPXdLWhvSuOqBS/Davdt+W3OYan7mTEMrzUfj1oal4wXRqDjaWjj39Hzxm8XttZQcM2h55DNwB/XaOtygq9BQh7w6xLNkBUElwG+2cGkGAnByZwtolHAvCSmVb/DV3rgWWty6IpXc5x1yJ4s8vkpF47uC/ustTxa1kMJQ2CenvT2aZqUfeaI1vXdjup5sTmwLjqYaS4yb6XpMww5sWtrShOpENfU+VWZe4XEDWe3e4VaVI1sr5BpV28pWUGltqOemTZi/aEiFvqlv0fpya+5I7w2ycC3S1gMyeIOsZubVPxicgRwZHZNt9oiTqsjGqZr8tUif3zaLABW9oRLq1qp0rNsLQ7DbC0O02wtDuNsLQ7zPF17qK5XWQ0pL38EfGRqZ1nJGtcg/Z0DbVqUVmKlyfp2ZvY/yqXcostLGdvHVpO+opLHT3YUGu/554eo/AAAA//8DAFBLAwQUAAYACAAAACEAdD85esIAAAAoAQAAHgAIAWN1c3RvbVhtbC9fcmVscy9pdGVtMS54bWwucmVscyCiBAEooAABAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAITPwYoCMQwG4LvgO5Tcnc54EJHpeFkWvIm44LV0MjPFaVOaKPr2Fk8rLOwxCfn+pN0/wqzumNlTNNBUNSiMjnofRwM/5+/VFhSLjb2dKaKBJzLsu+WiPeFspSzx5BOrokQ2MImkndbsJgyWK0oYy2SgHKyUMo86WXe1I+p1XW90/m1A92GqQ28gH/oG1PmZSvL/Ng2Dd/hF7hYwyh8R2t1YKFzCfMyUuMg2jygGvGB4t5qq3Au6a/XHf90LAAD//wMAUEsDBBQABgAIAAAAIQCo3L5+twAAAMkAAAAYACgAY3VzdG9tWG1sL2l0ZW1Qcm9wczIueG1sIKIkACigIAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAyNQYvCMBCF7wv+hzD3mFG0rWKUagl434W9hnSqhWZGmijCsv/dnB7vffC+w+kdJ/WiOY3CFlZLBEUcpB/5ZuHn2+kGVMqeez8JkwUWOB0XX4c+7Xuffcoy0zVTVGUYS147C3/oWldvu0rj6nzRm8rt9PlStxrbBlvXrLFG/AdV1FxukoV7zo+9MSncKfq0lAdxgYPM0edS55uRYRgDdRKekTibNWJlwrPo42+cwBw/AAAA//8DAFBLAwQUAAYACAAAACEAvYRiI5AAAADbAAAAEwAoAGN1c3RvbVhtbC9pdGVtMi54bWwgoiQAKKAgAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAbI47DsIwEAWvgtKTLejQ4jSBClHlAsY4iqWs1/IuH98eB0GBlHqeZh52JLx1HNVHHUryncETZxo8pdmql82L5iiHZlJNewBxkycrLQWXWXjU1jGBTDb7xCEqPHbwtWm1wVhd0hjsg1RfMT27O9XUOVyzzWVJIfwgHm9B1ycfghf/XMcLQPg7bt4AAAD//wMAUEsDBBQABgAIAAAAIQCz3nVhuAAAAMkAAAAYACgAY3VzdG9tWG1sL2l0ZW1Qcm9wczEueG1sIKIkACigIAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAyNwWrDMBBE74X8g9i7IikpcRIsBxvZkHsCvQp5nRis3WAppVD679VpmHkwr778xEV845pmJgtmq0EgBR5neli43wZ5BJGyp9EvTGiBGC7N5qMe03n02afMK14zRlGGueTVWfhte9e13d7Iw3Ds5GelnWxPxkld7bv+NAymN9UfiKKmcpMsPHN+nZVK4YnRpy2/kAqceI0+l7o+FE/THNBxeEekrHZaH1R4F338iguo5h8AAP//AwBQSwMEFAAGAAgAAAAhAFyWJyLDAAAAKAEAAB4ACAFjdXN0b21YbWwvX3JlbHMvaXRlbTIueG1sLnJlbHMgogQBKKAAAQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAACEz8FqwzAMBuB7oe9gdF+c9jBKidNLGeQ2Rgu9GkdJTGPLWEpp336mpxYGO0pC3y81h3uY1Q0ze4oGNlUNCqOj3sfRwPn09bEDxWJjb2eKaOCBDId2vWp+cLZSlnjyiVVRIhuYRNJea3YTBssVJYxlMlAOVkqZR52su9oR9bauP3V+NaB9M1XXG8hdvwF1eqSS/L9Nw+AdHsktAaP8EaHdwkLhEubvTImLbPOIYsALhmdrW5V7QbeNfvuv/QUAAP//AwBQSwMECgAAAAAAAAAhAP////94AQAAeAEAABAAAABbdHJhc2hdLzAwMDQuZGF0/////wAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAFBLAwQUAAYACAAAACEAiYjjDwYBAADXAwAAGgAAAHhsL19yZWxzL3dvcmtib29rLnhtbC5yZWxzvJNPa8MwDMXvg30H4/uiJN3KKHV6GYNeRwa7Gkf5Q2M7WOq2fPuZDtIVSnYJvRgk4fd+fsLb3bftxScG6rxTMktSKdAZX3WuUfK9fH14loJYu0r33qGSI5LcFfd32zfsNcdL1HYDiajiSMmWedgAkGnRakr8gC5Oah+s5liGBgZtDrpByNN0DeGvhiwuNMW+UjLsq5UU5ThE5/+1fV13Bl+8OVp0fMUCiMc+PkCUOjTISv7WSWSUcN0+X9KeYyx4dj+VcDqzOYZsSYYvHw7UIvKZY2oRnCazMOslYcyR2NuPGP+0kiSBqQsdo13NRfN0a5p8jubx1jTTpuDiOxY/AAAA//8DAFBLAwQUAAYACAAAACEAbueEcgIBAADGAQAAEwAoAGN1c3RvbVhtbC9pdGVtMy54bWwgoiQAKKAgAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAApJE/b4MwEEe/CvIOJglNKQIyZE2kSu3Q1ZgznITPln2UfPyG/kk7VF263fLe70lXHy52Sl4hRHTUiE2WiwRIux5paMTMJi3Foa195YPzEBghJleCYuUbMTL7SsqoR7AqZhZ1cNEZzrSz0hmDGuQ2z/fSAqtesZLfFvGpuUS8iZZlyZZd5sKwYhv5cj49vbtTpMiKNHxRXt+gP9eRjPOKx9V3Lx9VYIJwdMTBTVG0de/0bIH4rEgNsF5tfZ4nxhMSfBQ2otjmSpd9meoOIC3Ubp922wed7nVelN2d2ZVFfw2LWBFOjeAwg5Bt/TzOtiOF0z898rdI+fMj7RsAAAD//wMAUEsDBBQABgAIAAAAIQAW0BuZtQAAAMkAAAAYACgAY3VzdG9tWG1sL2l0ZW1Qcm9wczMueG1sIKIkACigIAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAyNwQrCMBBE74L/EPYek1aRWIyitgXvCl5DutVCsytNFEH8d3MaZh7M2+4/YRRvnOLAZKFYaBBInruB7haul1YaEDE56tzIhBaIYb+bz7ZdrDqXXEw84TlhEHkYcp5rC1+j10XTlkaazaaRq9NyJY+tOUm9POiirLU5ts0PRFZTvokWHik9K6Wif2BwccFPpAx7noJLuU53xX0/eKzZvwJSUqXWa+VfWR9uYQS1+wMAAP//AwBQSwMEFAAGAAgAAAAhAAyrwUUQAQAAkgEAABMACAFkb2NQcm9wcy9jdXN0b20ueG1sIKIEASigAAEAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAnNBNa4MwGMDx+2DfIeRu86j1JaIWNRZ226HbXTS2gknEpK4y9t0X6bbedwxP8uOfJz3cxIgWPutByQy7O8CIy1Z1gzxn+O10dGKMtGlk14xK8gyvXOND/vyUvs5q4rMZuEaWkDrDF2OmhBDdXrho9M6OpZ30ahaNscf5TFTfDy1nqr0KLg3xAELSXrVRwpn+OHz3ksX8l+xUu9Xp99M62dw8/cFX1AszdBn+ZEHFWACB49W0clxwS4f6NHIgBvBKrzrSov7CaNouexjJRtivV0oam72hL51VF5OM04c2cw43sAYAsMindRSzoA5psI8LGoaU+vuqLFhBSy8ljzcp+a3KU7Ll3peZfwMAAP//AwBQSwMEFAAGAAgAAAAhAHvzAqPDAAAAKAEAAB4ACAFjdXN0b21YbWwvX3JlbHMvaXRlbTMueG1sLnJlbHMgogQBKKAAAQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAACEz8FqwzAMBuB7Ye9gdF+cdDBKidPLKOQ2Rge7GkdxzGLLWOpY336mpxYGPUpC3y/1h9+4qh8sHCgZ6JoWFCZHU0jewOfp+LwDxWLTZFdKaOCCDIfhadN/4GqlLvESMquqJDawiOS91uwWjJYbypjqZKYSrdSyeJ2t+7Ye9bZtX3W5NWC4M9U4GSjj1IE6XXJNfmzTPAeHb+TOEZP8E6HdmYXiV1zfC2Wusi0exUAQjNfWS1PvBT30+u6/4Q8AAP//AwBQSwMEFAAGAAgAAAAhABNevmUFAQAA3wIAAAsAAABfcmVscy8ucmVsc6ySz07DMAzG70i8Q5T76m4ghNDSXSak3RAqD2AS94/axlGSQff2BCQElUa7A8fYnz///Cnb3Tj04o18aNkquc5yKchqNq2tlXwpH1f3UoSI1mDPlpQ8UZC74vpq+0w9xjQUmtYFkVxsULKJ0T0ABN3QgCFjRzZ1KvYDxvT0NTjUHdYEmzy/A//bQxYTT3EwSvqDuZGiPLm0edmbq6rVtGd9HMjGMyuAxkjWkFk5n9h8bNM1okRfU1TSsH5K5QDoXJawJZwn2lxO9Pe1MFBEgxFBs6d5nk/FHND6cqDliKaKn3TGHt7Zd6/M3RzL7X+y6GOIPCyE86X5RoLJtyw+AAAA//8DAFBLAwQUAAYACAAAACEAwPpStYUBAAARBgAAEwAAAFtDb250ZW50X1R5cGVzXS54bWy8lMtuwjAQRfeV+g+RtxUxUKmqKgKLPpYtCyp16zoTYuGXPIbC39cxEFQUXk3VTaLEnnvuXE8yGC2VTBbgUBidkV7aJQlobnKhpxl5n7x07kmCnumcSaMhIytAMhpeXw0mKwuYhGqNGSm9tw+UIi9BMUyNBR1WCuMU8+HRTallfMamQPvd7h3lRnvQvuMrDTIcPEHB5tInz8vweu3EgUSSPK43VqyMMGul4MwHp3Sh8z1KZ0NIQ2Xcg6WweBNsENpIqFYOAzZ1byEaJ3JIxsz5V6aCDZobPnbGIg2G0uMqDTZNUQgOQWOuQgQpVC3nkHdskATnBdSem9hLSdGvJGBrMFoHLMcSwCuZrkW3aR0g+3C6QOO115ofZU4Av4ybfRozaw3ba7ZqOlVM6DP4MSGk8da+659Gqv6i8DEf9bhx4+DyJLafRVV95pDxOXqjPpSkwoOKs96/HLw36LVopXd60OvtOw/t069Ff+3h9r9z2J1+PJQ/wjcMAo0/9OE3AAAA//8DAFBLAQItAAoAAAAAAAAAIQD/////UQEAAFEBAAAQAAAAAAAAAAAAAAAAAAAAAABbdHJhc2hdLzAwMDEuZGF0UEsBAi0ACgAAAAAAAAAhAP/////vAAAA7wAAABAAAAAAAAAAAAAAAAAAfwEAAFt0cmFzaF0vMDAwMy5kYXRQSwECLQAUAAYACAAAACEAYUkJEIkBAAARAwAAEAAAAAAAAAAAAAAAAACcAgAAZG9jUHJvcHMvYXBwLnhtbFBLAQItAAoAAAAAAAAAIQD/////OQEAADkBAAAQAAAAAAAAAAAAAAAAAFMEAABbdHJhc2hdLzAwMDAuZGF0UEsBAi0ACgAAAAAAAAAhAP/////qAAAA6gAAABAAAAAAAAAAAAAAAAAAugUAAFt0cmFzaF0vMDAwMi5kYXRQSwECLQAUAAYACAAAACEAn4jrbZYCAAAEBgAADQAAAAAAAAAAAAAAAADSBgAAeGwvc3R5bGVzLnhtbFBLAQItABQABgAIAAAAIQB1PplpkwYAAIwaAAATAAAAAAAAAAAAAAAAAJMJAAB4bC90aGVtZS90aGVtZTEueG1sUEsBAi0AFAAEAAgAAAAhAM/gE0r2AQAA1wMAAA8AAAAAAAAAAAAAAAAAVxAAAHhsL3dvcmtib29rLnhtbFBLAQItABQABAAIAAAAIQBGcAELfAEAAJ4CAAAYAAAAAAAAAAAAAAAAAHoSAAB4bC93b3Jrc2hlZXRzL3NoZWV0MS54bWxQSwECLQAUAAYACAAAACEA+Chgbz8BAABbAgAAEQAAAAAAAAAAAAAAAAAsFAAAZG9jUHJvcHMvY29yZS54bWxQSwECLQAUAAYACAAAACEAVymYAx4HAAD5IAAAEwAAAAAAAAAAAAAAAACaFQAAY3VzdG9tWG1sL2l0ZW0xLnhtbFBLAQItABQABgAIAAAAIQB0Pzl6wgAAACgBAAAeAAAAAAAAAAAAAAAAABEdAABjdXN0b21YbWwvX3JlbHMvaXRlbTEueG1sLnJlbHNQSwECLQAUAAYACAAAACEAqNy+frcAAADJAAAAGAAAAAAAAAAAAAAAAAAXHwAAY3VzdG9tWG1sL2l0ZW1Qcm9wczIueG1sUEsBAi0AFAAGAAgAAAAhAL2EYiOQAAAA2wAAABMAAAAAAAAAAAAAAAAALCAAAGN1c3RvbVhtbC9pdGVtMi54bWxQSwECLQAUAAYACAAAACEAs951YbgAAADJAAAAGAAAAAAAAAAAAAAAAAAVIQAAY3VzdG9tWG1sL2l0ZW1Qcm9wczEueG1sUEsBAi0AFAAGAAgAAAAhAFyWJyLDAAAAKAEAAB4AAAAAAAAAAAAAAAAAKyIAAGN1c3RvbVhtbC9fcmVscy9pdGVtMi54bWwucmVsc1BLAQItAAoAAAAAAAAAIQD/////eAEAAHgBAAAQAAAAAAAAAAAAAAAAADIkAABbdHJhc2hdLzAwMDQuZGF0UEsBAi0AFAAGAAgAAAAhAImI4w8GAQAA1wMAABoAAAAAAAAAAAAAAAAA2CUAAHhsL19yZWxzL3dvcmtib29rLnhtbC5yZWxzUEsBAi0AFAAGAAgAAAAhAG7nhHICAQAAxgEAABMAAAAAAAAAAAAAAAAAFicAAGN1c3RvbVhtbC9pdGVtMy54bWxQSwECLQAUAAYACAAAACEAFtAbmbUAAADJAAAAGAAAAAAAAAAAAAAAAABxKAAAY3VzdG9tWG1sL2l0ZW1Qcm9wczMueG1sUEsBAi0AFAAGAAgAAAAhAAyrwUUQAQAAkgEAABMAAAAAAAAAAAAAAAAAhCkAAGRvY1Byb3BzL2N1c3RvbS54bWxQSwECLQAUAAYACAAAACEAe/MCo8MAAAAoAQAAHgAAAAAAAAAAAAAAAADNKwAAY3VzdG9tWG1sL19yZWxzL2l0ZW0zLnhtbC5yZWxzUEsBAi0AFAAGAAgAAAAhABNevmUFAQAA3wIAAAsAAAAAAAAAAAAAAAAA1C0AAF9yZWxzLy5yZWxzUEsBAi0AFAAGAAgAAAAhAMD6UrWFAQAAEQYAABMAAAAAAAAAAAAAAAAAAi8AAFtDb250ZW50X1R5cGVzXS54bWxQSwUGAAAAABgAGAAuBgAAuDAAAAAA"},"runAfter":{}},"Create_file":{"type":"OpenApiConnection","inputs":{"host":{"connectionName":"shared_sharepointonline","operationId":"CreateFile","apiId":"/providers/Microsoft.PowerApps/apis/shared_sharepointonline"},"parameters":{"dataset":"https://abdndamodev.sharepoint.com/sites/DamoBird365","folderPath":"/DocLibMetaData","name":"thisisatestfile.xlsx","body":"@outputs('ExcelFile')"},"authentication":{"type":"Raw","value":"@json(decodeBase64(triggerOutputs().headers['X-MS-APIM-Tokens']))['$ConnectionKey']"}},"runAfter":{"ExcelFile":["Succeeded"]},"runtimeConfiguration":{"contentTransfer":{"transferMode":"Chunked"}}},"Add_a_row_into_a_table":{"type":"OpenApiConnection","inputs":{"host":{"connectionName":"shared_excelonlinebusiness","operationId":"AddRowV2","apiId":"/providers/Microsoft.PowerApps/apis/shared_excelonlinebusiness"},"parameters":{"source":"groups/28d3ec1b-2f15-49c8-ac27-3f070a89a141","drive":"b!x_IAGCMIo0yfQDsdE3DrCKQbS0QJK0hKhBzj3yHaF2nYyApC7ss2SrKcbASLXzhN","file":"@outputs('Create_file')?['body/Id']","table":"NewTable","item":{"Name":"Lucy","Address":"Scotland","Postcode":"Highlands"}},"authentication":{"type":"Raw","value":"@json(decodeBase64(triggerOutputs().headers['X-MS-APIM-Tokens']))['$ConnectionKey']"}},"runAfter":{"Create_table":["Succeeded"]}},"Create_table":{"type":"OpenApiConnection","inputs":{"host":{"connectionName":"shared_excelonlinebusiness","operationId":"CreateTable","apiId":"/providers/Microsoft.PowerApps/apis/shared_excelonlinebusiness"},"parameters":{"source":"groups/28d3ec1b-2f15-49c8-ac27-3f070a89a141","drive":"b!x_IAGCMIo0yfQDsdE3DrCKQbS0QJK0hKhBzj3yHaF2nYyApC7ss2SrKcbASLXzhN","file":"@outputs('Create_file')?['body/Id']","table/Range":"A1:C1","table/TableName":"NewTable","table/ColumnsNames":"Name,Address,Postcode"},"authentication":{"type":"Raw","value":"@json(decodeBase64(triggerOutputs().headers['X-MS-APIM-Tokens']))['$ConnectionKey']"}},"runAfter":{"Create_file":["Succeeded"]}}},"runAfter":{}}}

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
    Cheers,
    Damien


    P.S. take a look at my new blog here and like & subscribe to my YouTube Channel thanks 😉

  • ccc333ab Profile Picture
    1,144 on at

    @DamoBird365 - Too funny. I've actually done this myself in one of my flows. No idea why I didn't suggest it in the first place!!! 

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    This is great, I will take a look. Is there a way to then add data to just a cell instead of a row in excel using power automte?

  • DamoBird365 Profile Picture
    8,942 Microsoft Employee on at

    Hi @Anonymous 

     

    Look into office scripts.  https://docs.microsoft.com/en-us/office/dev/scripts/overview/excel

     

    You can very quickly build a bepsoke action that can write to excel without a table being present.

     

    https://youtu.be/Q7GLQnvJJF0

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
    Cheers,
    Damien


    P.S. take a look at my new blog here and like & subscribe to my YouTube Channel thanks 😉

  • Powerplatform01 Profile Picture
    386 on at

    @Anonymous 

    Please refer this Video

    https://youtu.be/GA_f5GX5H-Q

    Also request you to please subscribe it🙏

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Automate

#1
Mohsin Ali Profile Picture

Mohsin Ali 430

#2
11manish Profile Picture

11manish 341 Super User 2026 Season 2

#3
M Bilal Khan Profile Picture

M Bilal Khan 282

Last 30 days Overall leaderboard