cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Sastro_Chang
Helper I
Helper I

Connecting Ms Form and Flow

Hi,

I have to create a form template and share to all my users. Users then duplicate this to become their own form.

I have requirement to gather all responses counts receipt by each user in ONE Excel sheet.

I managed to find solution using MS. Flow, to gather every responses count to one excel file but the problem I am facing is I need to setup the Flow for every users. Imagine if I have more than 200 users.

Is there any other more efficient way to do this? ie : sharing my form template with integrated flow in it so I don’t need to setup every individual connector to each user form.

Thank you for your help.

Regards,
5 REPLIES 5
ScottShearer
Super User
Super User

@Sastro_Chang 

Is there a reason that everyone can't respond to a single Form?  Why do your users need to publish their own Form? 

If you did that, you wouldn't need Flow as Forms natively exports to Excel.

 

 

 

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott

Everyone need their own form it’s regarding their own performance/feedback they got from customers but I need to collect how many feedback counts we got in a certain period without to ask users 1 by 1 or ask them to send the feedback result.
Anonymous
Not applicable

I there a way to send their feedback based on their name rather than send it to them on a. Form ? They could then approve the feedback they have received and then update the excel sheet ? Unless I am misunderstanding the use case.

@Sastro_Chang 

As long as all of your users have access to the Excel workbook, technically there is no reason why all of the Flows can't be writing back to the same Excel file.  You could add a column to indicate the form that generated the new row of data.

 

I suggest that a better way might be to have all of the Flows write back to a SharePoint list rather than an Excel workbook.  You can, at any time, export he SharePoint data to Excel. I woiuld rather use SharePoint than Excel because I suspect that it is likely that you'll run into file locking issues if you use Excel.

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott

Hi Scott,

Thanks for your answer to my question, during the test for some users, they able to write into Excel no problem at all.

But my question is as below ;
Is there any other more efficient way to do this? ie : sharing my form template with integrated flow in it so I don’t need to setup every individual FLOWconnector to each user’s form.

Imagine if I have 200 users, I need to setup the Flow one by one in order to point to users individual Form and also point to the same excel file.

Best Regards,

Helpful resources

Announcements
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.

Power automate tips 768x460 v2.png

Restore a Deleted Flow

Did you know that you could restore a deleted flow? Check out this helpful article.

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.

Users online (2,727)