Allow Auto export of responses
It would be great if you could schedule the extract of responses in an excel format and automatically send it to an email address.
I would like for it to create a new worksheet every Monday morning on our network shared drive - then have it collect data for the next week, and then Monday morning, any new responses get added to a new worksheet. That way, I could just load the last week's spreadsheet into my robot and have it process the items.
I have tried using flow but I have only been able to get individual responses to extract. I would like to send a batch per day. I have tried using the recurrance function but I have not been successful so far.
You can do this all through Microsoft Flow, but it takes some time and testing to set up. I would be nice to only have responses from the last week or month sent out.
It would be great if the responses could be automatically emailed out on schedule in an excel file