Forum Discussion

andreacocco5's avatar
andreacocco5
Copper Contributor
Apr 28, 2022

Microsoft 365 Teams Approval App Export Data

Hello,

we're using the Teams App "Approval" on Microsoft 365 to manage approvals with personalized forms and custom fields. In order to collect data input from users would be great to access to database tables where those data are recorded and export them for further processing.

Is there any way to collect form data inside Power Automate or other tool of Microsoft365?

Thank you for any advice.

Andrea

 

 

 

7 Replies

  • Ryan Steele's avatar
    Ryan Steele
    Bronze Contributor

    andreacocco5 If you haven't already, I would recommend doing a search at https://powerautomate.microsoft.com/en-us/templates/ with keywords "forms" and "approval" and see if anything comes up that appears to be relevant.

     

    For example, the most popular template I found with that search is https://powerautomate.microsoft.com/en-us/templates/details/4071c6b040c611e7ad68c1c80e905297/send-form-responses-for-approval/.

    • jgossard's avatar
      jgossard
      Copper Contributor

      Ryan Steele All of the data put into each Approval is located in FORMs.  It can all be downloaded into a CSV from the RESPONSES tab.

      • SSeres's avatar
        SSeres
        Copper Contributor

        jgossard  that's very helpful - I ran the export but now I cannot find the file in OneDrive.  I've searched for .csv files created today but there were none.  Do you know the file name or location it is stored in OneDrive? Thank-you!

Resources