question

YUKIKOGA-4111 avatar image
0 Votes"
YUKIKOGA-4111 asked KojiShiraiwa-3784 answered

How to export approval result in Microsoft Teams to excel

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


office-teams-app-dev
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

PrithviKamble-MSFT-9239 avatar image
0 Votes"
PrithviKamble-MSFT-9239 answered

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

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

KojiShiraiwa-3784 avatar image
0 Votes"
KojiShiraiwa-3784 answered

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).

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.