cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
photonacl
Frequent Visitor

Submit Microsoft Forms using PowerApp?

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 🙂

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Drrickryp
Super User
Super User

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,

View solution in original post

2 REPLIES 2
Drrickryp
Super User
Super User

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
Not applicable

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

Helpful resources

Announcements
PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Top Solution Authors
Top Kudoed Authors
Users online (1,199)