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
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on June 15, 2022 at 8am PDT.

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.

PA.JPG

New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

Top Solution Authors
Top Kudoed Authors
Users online (2,841)