Forum Discussion

Deleted's avatar
Deleted
Apr 05, 2018

Group Form Data

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.

  • Matt Coats's avatar
    Matt Coats
    Steel Contributor

    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.

Resources