cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

Using Flows To Solve Issue With Forms?

Background

I have created a Microsoft Forms survey. This is a sequence of multiple choice questions that will be answered by the respondent. The respondent will receive an URL (hyperlink), together with a username and password. When the respondent opens the URL in his browser, he can login to the Microsoft Forms survey and start answering the questions. The company I work for, has a Microsoft Forms Pro license. Together with Forms, we have acces to Power Automate and Power Apps and Flow.

Problem description

Suppose that the survey contains 75 questions. The respondent wants for instance to answer the first 30 questions on Monday, then he wants to answer the rest, so the remaining 45 questions on Thursday. The problem is, that when he re-opens the URL of the Forms survey in the session on Thursday, his answers to the first 30 questions are no longer visible. So in short the problem is that Microsoft Forms does not support the save and resume function.

What I am looking for

I am looking for a Microsoft Power platform engineer or software developer, that can solve this problem by either a Power Automate, or Power Apps solution. This solution should be lean, and retaining as much of the present Forms survey as possible.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: Using Flows To Solve Issue With Forms?

Hi @boelenz,

 

@ScottShearer is correct, store these answers into a SharePoint is an ideal approach.

Firstly, you could create a SharePoint list as below, the UserName is the respondent, Answer 1 stand for the first 30 questions, Answer 2 stand for the remaining 45 questions:

Annotation 2020-04-16 123318.png

 

Secondly, create a Flow as below:

Use Get items action to find the item belong to the respondent. If the above action finds it, the length of the Get items will equal 1 and create a new item, or it will be 0 and update the item to append these remaining answers into the item.

 

Annotation 2020-04-16 122948.png

 

Annotation 2020-04-16 123051.png

 

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

4 REPLIES 4
Highlighted
Super User
Super User

Re: Using Flows To Solve Issue With Forms?

@boelenz 

You might consider using a SharePoint list with the list forms customized using PowerApps or a straight Power Apps solution storing your data in SharePoint.

For example, you create an entry in the list for the user.  Power Automate sends the email to the user along with a link to the SharePoint list item.  The user can save the entries, leave and come back.  When the user clicks on a Submit button, validation of the entry could happen.

 

 

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

Scott
Highlighted
Community Support
Community Support

Re: Using Flows To Solve Issue With Forms?

Hi @boelenz,

 

@ScottShearer is correct, store these answers into a SharePoint is an ideal approach.

Firstly, you could create a SharePoint list as below, the UserName is the respondent, Answer 1 stand for the first 30 questions, Answer 2 stand for the remaining 45 questions:

Annotation 2020-04-16 123318.png

 

Secondly, create a Flow as below:

Use Get items action to find the item belong to the respondent. If the above action finds it, the length of the Get items will equal 1 and create a new item, or it will be 0 and update the item to append these remaining answers into the item.

 

Annotation 2020-04-16 122948.png

 

Annotation 2020-04-16 123051.png

 

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Highlighted
New Member

Re: Using Flows To Solve Issue With Forms?

Thank you for your answer!

 

When the respondent wants to resume answering questions, the second session, unfortunately the answers that were entered during the first session are no longer visible.

 

 

Highlighted
Community Support
Community Support

Re: Using Flows To Solve Issue With Forms?

Hi @boelenz,

 

Sadly, yes. There is no way to view the first session when user appends the second session.

 

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

Join the new Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Solution Authors
Top Kudoed Authors
Users online (7,668)