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.
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?
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.
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 😉
@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!!!
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?
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.
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 😉
@Anonymous
Please refer this Video
Also request you to please subscribe it🙏
User | Count |
---|---|
25 | |
14 | |
12 | |
10 | |
9 |
User | Count |
---|---|
51 | |
29 | |
28 | |
24 | |
22 |