How to export approval result in Microsoft Teams to excel

YUKI KOGA 6 Reputation points
2021-09-02T02:19:20.117+00:00

Hi,

I try to use latest approval app in teams.
It is very useful and so simple, but as the number of result data become more than 30, it is difficult to glance it.
So I'd like to export this result data to excel in table form and sort it to glance .
However I can't find these native data anywhere.
I would appreciate if you show the solution.

128512-approval-app-create.png

Microsoft Teams Development
Microsoft Teams Development
Microsoft Teams: A Microsoft customizable chat-based workspace.Development: The process of researching, productizing, and refining new or existing technologies.
2,965 questions
0 comments No comments
{count} vote

2 answers

Sort by: Most helpful
  1. Prithvi-MSFT 271 Reputation points Microsoft Vendor
    2021-09-02T12:26:04.473+00:00

    Hi, this looks like a feature request for Approval app. You can raise your voice here https://microsoftteams.uservoice.com/
    Microsoft will always focus on customer feedback and some features may be implemented in future.

    Thanks

    0 comments No comments

  2. Koji Shiraiwa 1 Reputation point
    2022-01-14T16:56:23.397+00:00

    I was able to download the list by use Forms. Go to 365 page and open Forms.
    Find your form and open it.
    There is "Responses" tab so click on it.
    You will see Open in Excel link. When you click it, it will download the Excel file.

    Only thing missing here is (as of Jan 2022) approver's information.
    Also, I noticed numbers are treated as a text. So if you want to calculate numbers (such as $ amount), you need to convert text to number (i.e., multiply that text by 1 and it will change to a number).

    0 comments No comments