Submit Microsoft Forms using PowerApp?

[photonacl]

Greetings,

Just wondering if anyone knows a way for PowerApp to submit a form response on behalf of the regular MS Forms. Basically using PowerApp as an interface to collect data (more fancy) and store the data as form responses.

I ran into the connector that is already out there, but it seems that the data flow could only go one way (get instead of set). So PowerApp could pull data from Forms, but cannot submit to it.

The real reason I'm trying to use Forms instead of other data sources like SharePoint or SQL is due to the issue of lacking data protection that some of you may already aware of. 

Ideas of making MS Form to create more fancy interfaces (instead of line by line questions) are also welcome 🙂

[Drrickryp · Accepted solution]

Hi @photonacl,

it is my understanding that MS Forms stores its data in an Excel workbook in OneDrive for business. If this is the case, you should be able to use the Excel connector and let PowerApps create an app from data already in Excel. The data would have to be formatted as a table in Excel first,

[Anonymous]

Thank you for posting this thread @photonacl and thank you for your quick response @Drrickryp!

@photonacl can you review the latest reply and advise if it answers your question?

@Anonymous