SOLVED

Make a Excel file with Power Automate in a Microsoft Team

%3CLINGO-SUB%20id%3D%22lingo-sub-1510987%22%20slang%3D%22en-US%22%3EMake%20a%20Excel%20file%20with%20Power%20Automate%20in%20a%20Microsoft%20Team%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1510987%22%20slang%3D%22en-US%22%3E%3CP%3EIs%20it%20possible%20to%20use%20Power%20Automate%20for%20creating%20a%20new%20Excel%20file%20from%20a%20Template%20as%20a%20trigger%20with%20Power%20Automate%20in%20Microsoft%20Teams%3F%26nbsp%3B%20So%20every%20time%20a%20work%20process%20is%20started%20a%20new%20excel%20has%20to%20be%20created%20in%20a%20specific%20team%20that%20comes%20from%20a%20Template.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1510987%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPowerAutomate%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ETeams%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ETemplates%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1517492%22%20slang%3D%22en-US%22%3ERe%3A%20Make%20a%20Excel%20file%20with%20Power%20Automate%20in%20a%20Microsoft%20Team%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1517492%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F504059%22%20target%3D%22_blank%22%3E%40FemkeCornelissen%3C%2FA%3E%26nbsp%3BI%20don't%20completely%20understand%20what%20would%20be%20your%20trigger%20in%20this%20case.%20The%20next%20steps%20should%20be%20doable.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3COL%3E%0A%3CLI%3EStore%20the%20Excel%20file%20template%20somewhere%20on%20SharePoint%3C%2FLI%3E%0A%3CLI%3ECreate%20a%20Power%20Automate%20flow%2C%20with%20your%20preferred%20trigger%3C%2FLI%3E%0A%3CLI%3EUse%20the%20%22Copy%20file%22%20action%20in%20the%20%22SharePoint%22%20connector%2C%20point%20it%20to%20your%20template%20file%20from%20step%201%20and%20enter%20the%20destination%20location%20(SharePoint%20document%20library%20backing%20your%20Teams%20team).%3C%2FLI%3E%0A%3C%2FOL%3E%0A%3CP%3ETeams%20uses%20SharePoint%20for%20file%20storage%2C%20so%20you%20can%20use%20the%20SharePoint%20connectors%20for%20manipulating%20files%20in%20Teams.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1523457%22%20slang%3D%22en-US%22%3ERe%3A%20Make%20a%20Excel%20file%20with%20Power%20Automate%20in%20a%20Microsoft%20Team%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1523457%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F4392%22%20target%3D%22_blank%22%3E%40Yannick%20Reekmans%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks.%26nbsp%3BThat%20is%20what%20I%20want.%20Copy%20a%20Excel%20file.%26nbsp%3B%3C%2FP%3E%3CP%3EUnfortunately%20it%20does%20not%20work.%20Afgeschaft%20(abolished).%26nbsp%3B%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22afgeschaft.PNG%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F205458iBEE68BD6461E9919%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22afgeschaft.PNG%22%20alt%3D%22afgeschaft.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1523588%22%20slang%3D%22en-US%22%3ERe%3A%20Make%20a%20Excel%20file%20with%20Power%20Automate%20in%20a%20Microsoft%20Team%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1523588%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F504059%22%20target%3D%22_blank%22%3E%40FemkeCornelissen%3C%2FA%3E%26nbsp%3BSeems%20like%20you%20are%20using%20the%20wrong%20action.%20When%20I%20check%20(in%20English)%20it%20gives%20me%20two%20options%2C%20a%20deprecated%20one%20(like%20your%20screenshot)%20but%20also%20a%20new%20action.%3C%2FP%3E%0A%3CP%3EYou%20should%20be%20able%20to%20use%20the%20new%20one.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22CopyFile.PNG%22%20style%3D%22width%3A%20902px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F205477iF1515FDC29A56887%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22CopyFile.PNG%22%20alt%3D%22CopyFile.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

Is it possible to use Power Automate for creating a new Excel file from a Template as a trigger with Power Automate in Microsoft Teams?  So every time a work process is started a new excel has to be created in a specific team that comes from a Template. 

3 Replies
Highlighted
Best Response confirmed by ThereseSolimeno (Microsoft)
Solution

@FemkeCornelissen I don't completely understand what would be your trigger in this case. The next steps should be doable.

 

  1. Store the Excel file template somewhere on SharePoint
  2. Create a Power Automate flow, with your preferred trigger
  3. Use the "Copy file" action in the "SharePoint" connector, point it to your template file from step 1 and enter the destination location (SharePoint document library backing your Teams team).

Teams uses SharePoint for file storage, so you can use the SharePoint connectors for manipulating files in Teams.

Highlighted

Hi @Yannick Reekmans 

 

Thanks. That is what I want. Copy a Excel file. 

Unfortunately it does not work. Afgeschaft (abolished). afgeschaft.PNG

Highlighted

@FemkeCornelissen Seems like you are using the wrong action. When I check (in English) it gives me two options, a deprecated one (like your screenshot) but also a new action.

You should be able to use the new one.

CopyFile.PNG