Forum Discussion

experi1610's avatar
experi1610
Copper Contributor
Jul 06, 2021
Solved

Puxar todos os items de uma lista do Sharepoint e criar uma planilha em excel

Prezados, bom dia!
Seria possível com que eu pegasse um item de uma lista do sharepoint, pegasse todos os campos desse item e criasse uma planilha em excel, e enviasse por e-mail, utilizando o Power Automate?

Tô quebrando a cabeça aqui mas tá complicado hahaha

Obrigado pela ajuda 🙂

  • Hi experi1610,

     

    1. Manually create and upload the template file
    2. Copy the template file to a new name
    3. Get List items
    4. Add List items to the new Excel file
    5. Send email

    I hope this helps.

     

    Norm

3 Replies

  • Hello experi1610,

    You will need an Excel "template" file that you will copy, add List items too and then send via email. The template file must match the List schema and must be in a table.

    I hope that makes sense.

    Norm

    • experi1610's avatar
      experi1610
      Copper Contributor
      First, do I need to obtain Items from the list or to create this Excel on the documents of the SharePoint Site?
      • stormin_30's avatar
        stormin_30
        MVP

        Hi experi1610,

         

        1. Manually create and upload the template file
        2. Copy the template file to a new name
        3. Get List items
        4. Add List items to the new Excel file
        5. Send email

        I hope this helps.

         

        Norm

Resources