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 II
Super User II

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 II
Super User II

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

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 User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Top Solution Authors
Top Kudoed Authors
Users online (3,519)