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...
Microsoft Flow
sharepoint
  • stormin_30's avatar
    stormin_30
    Jul 06, 2021

    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

stormin_30's avatar
stormin_30
MVP
Jul 06, 2021
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
    Jul 06, 2021
    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
      Jul 06, 2021

      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