Apr 04 2018
11:13 PM
- last edited on
Aug 06 2023
03:39 PM
by
TechCommunityAP
Apr 04 2018
11:13 PM
- last edited on
Aug 06 2023
03:39 PM
by
TechCommunityAP
Hi all,
Apologies if this question has been covered, I was unable to find it.
I have a Group Form.
How can an external Excel sheet pull the data from that Group Form Data Sheet?
I'm unsure which 'Get Data' option to choose, all the ones I try simply cannot 'see' the Group Form Data sheet within the SharePoint directory.
Many thanks for any time with a response.
Apr 05 2018 08:05 AM
If your Form was made through the Applet and not from a Group/Team site, I'm not sure if there is a way to get to the source sheet directly, you'd have to rely on downloading it.
One thing you could try to get to the data more easily would be creating a List replicating the structure of your Form, copying over what submissions you already have, and creating a Flow to direct responses to your List. This makes working with Form data a little more reliable in my mind, and would accomplish your need if the source sheet proves elusive.