cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
pfizer
Regular Visitor

Is there any alternative way (custom connector/trigger) by which it is possible to invoke a single flow on the submission of multiple microsoft forms

We have a requirement wherein we have more than 30 Microsoft forms and based on the responses we want to calculate the score and upload it on SharePoint but it seems we will need to have 1 flow for every form since we are 
fetching the responses either with a form name or form id. 

As per my knowledge, we can't trigger single flow based on submission for multiple flow. So it will be a replication of code for so many forms. Is there any alternative way (custom connector/trigger) by which it is possible to invoke a single flow on the submission of multiple forms.

Need help on the above inputs.

3 REPLIES 3
Babybots
Resolver I
Resolver I

To my understanding, theres not really a way to monitor for multiple triggers (easily atleast) from forms. But, one way you could go about this would be the following:

 

All form submissions return information to a singular share point sheet (master sheet).  Create a flow that is linked to this master sheet & triggers every time a new row is added. This will meet the criteria of a singular flow, while executing anytime a new form is submitted 

barret
Responsive Resident
Responsive Resident

Agree with @Babybots. This is about your best option. There's no way to get the responses for various forms through the built-in connector. And Forms doesn't have an API you can use to create your own custom connector. So, for your 30 forms, you would need 31 flows, one trigger for each form that gets the form ID and response ID and saves them to somewhere like a SharePoint list, then another flow that triggers off that list or a timer that grabs all the IDs and iterates through them, retrieving the results for each and condensing them into your final results. 

RezaDorrani
Dual Super User II
Dual Super User II

Hi @pfizer ,

 

Check How to Get Forms Responses using Power Automate | Download Excel, Filter, PDF of Quiz Results - YouT...

There is an undocumented forms API that can be leveraged.

For your case, you would have to call the API endpoint for all your forms (may be run the logic in a loop).

 

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

Thanks,
Reza Dorrani, MVP
YouTube
Twitter

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.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (1,781)