Hi 

I hope someone might be able to help/guide me .. I am looking to import responses submitted via MS Forms into my application. 

Considerations  a) There may be a number of forms created b) the data contains personal data, more automated the better ;)  

As I see it I have a number of options 

i) Connect the forms to a SharePoint list via MS automate and read each SharePoint list as its created. But this needs a new integration for each form and leaves the data residing in SharePoint (messy)- can I import/ sync from a SharePoint list?

ii) create an Azure Microsoft Graph API connection with permissions form.read.all, create a Rest APi in OS to connect to Graph APi and map all response data. Again could be cumbersome if there are many forms.

iii) manual extract of the CSV data and import the responses periodically - again will need to set up many imports 

it is possible to create a table based on the import file?

Has anyone attempted bringing such data in reliably ?

Any guidance much appreciated.

(PS use of MS forms not my idea)