Hi All,
Is there a way I could automatically export survey results in excel and place it in sharepoint or one drive.
This process needs to be automated to even capture new responses.
Please advise would be helpful.
Thank you
Hi All,
Is there a way I could automatically export survey results in excel and place it in sharepoint or one drive.
This process needs to be automated to even capture new responses.
Please advise would be helpful.
Thank you
Hi
You will have to set up the table first and then tell the system which question should apply to which column.
1. Here are the steps to create the workflow.
2. This will not pull in already collected responses as the workflow starts when a new response is collected. However, because you have to build the table prior to setting up the workflow I found it easier to do a full data export from Data & Analytics tab and use that to create my table. I then crossed reference the last Response ID from my export with the first from the workflow to ensure I didn’t have any missing.
I ran into some trouble with this as well - but largely because we have so many files in the location I saved the worksheet. Qualtrics suggested reindexing the library. I eventually did use a file in my OneDrive as it was the quickest solution I could find and my use case had a tight turnaround time.
I did found this post about using API connections to do the same feature.
I just tried to search in the Excel task again and I saw that SharePoint libraries with a lot of data are not appearing compared with smaller libraries. Sorry I can’t help more than that.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.