You’re offline. This is a read only version of the page.
30
Is it possible to send automatically (every month) an excel with all the responses that my survey had?
I tried with Power Automate but I think it is not possible.
Can you help?
Yes this is feasible, but technically complicated if you have more than 5000 responses per month
You need to read the data from the dataverse tables (cf docs.microsoft.com/.../entity-reference) ... maybe in your case, you just need to look at msfp_quesitonresponse table, filtered by current/previous month
Then you would need to load the output of this card in an Excel file and add it as attachment to an email
The card that gets data from the dataverse table is limited to 5000 lines ... you could add a loop, if you need to read more than 5K lines
There are some tutorials over pagination of queries over tables.
I hope it will help
Share
Report
All responses (
Answers (
