Jan 31 2020
09:45 AM
- last edited on
Aug 06 2023
05:02 PM
by
TechCommunityAP
Jan 31 2020
09:45 AM
- last edited on
Aug 06 2023
05:02 PM
by
TechCommunityAP
I am looking to create a form that multiple users can fill out:
Is the above realizable through Microsoft forms?
Jan 31 2020 10:00 AM
@Rafael91 - the only way you could do this would be to have two different surveys. If you are using Forms Pro, you could then link the two surveys together with variables. Depending on who these people are, and where you have their information stored, you could link this all together and send an email to the 3rd party when the two questions from Survey 1 are complete.
You could then pass through those answers (if this makes sense for the 3rd party person to see them) and display them on Survey 2. The 3rd party person could then respond to the questions, then submit.
You could then have an email sent to you (or whomever needs the results) with all of the responses combined.
You would need to A) use Forms Pro for the surveys, and B) use Power Automate for the triggers and linking everything together.
Jan 31 2020 10:27 AM
@Megan_V_Walker thank you! This is invaluable information!!!
Feb 01 2020 04:57 AM
@Rafael91 personally I would use a flow in Power Automate to save the form response to a SharePoint list, send the email to the next person with the answers submitted and include a link to the item in the SharePoint list where they can add their own answers. Once they do that another flow would send the email back to you with whatever information you needed from the SharePoint list.
Rob
Los Gallardos
Microsoft Power Automate Community Super User
Feb 01 2020 09:30 AM
@RobElliott - would you want to give a 3rd party access to your SharePoint list? Although the approach might work for an internal process, it might not be as beneficial where external people need to be involved.
Feb 01 2020 10:50 AM
@Megan_V_Walker the poster didn't mention whether the 3rd party was internal or external.
Apr 22 2020 06:19 PM
@Megan_V_Walker would you be able to help with the following?
I have two forms set up and have created the initial flow in power automate, but I cant quite figure out the next steps.
Here's what I have:
Step 1 - Trigger: New submission in Form A1
Step 2 - Action: Get response details from Form A1
Step 3 - Action: Send an email to the second person in the process to notify them of the new submission.
At step 3, I cant figure out how to:
(1) Display the data from Form A1 for the second user to review
(2) Send the second user to Form A2 to complete the second part of the form
Sorry if this is an easy question, this is my first time using Forms and Power Automate!
Thanks.
May 02 2020 03:44 AM
@arg123 : did you figure this out ? I have a similar query.
@Megan_V_Walker : your expert comments on this please ?
May 04 2020 02:16 AM
You cannot have more than one person complete the same survey response. If a survey response is submitted, that's it, it's complete and cannot be partially completed by two different people.
@arg123 here is what you need.
Then this process:
Jun 07 2020 07:04 PM
Hi Rob, I like what you are proposing (as I will be using this internally with my team), so how do you suggest this to be implemented?
Do you have the key flows for me to set this up?
I am brand new to MS365 so learning heaps.
Thanks!
Sep 25 2020 08:00 AM
Hi Rob,
I am new to Power Automate and Forms. I don't have Forms Pro. Would it be possible for you to outline the steps involved in creating 2 (or 3?) forms as you described here so that the following needs are met:
First, a request comes in a Form
It is assigned to someone
That person then fills the rest and saves/emails the Form
All responses are linked to a SP list.
Thank you.
Any help would be greatly appreciated.
Jul 24 2021 11:17 AM
Just need a clarity on your answer.
Can 2nd respondent edit the responses made by 1st respondent in the SharePoint file?
Jun 14 2022 08:45 AM
Can you please send me the flows to use and possibly screenshots of how to pass variables from Form A into Form B and how to send an email to the second user to the same survey to complete.
Hope this is ok
Thanks Brian
Jun 14 2022 08:52 AM
@BrianHarry1730 - I don't have any flows built for this. I was explaining how it could potentially be achieved.
Jun 14 2022 08:58 AM
Jun 14 2022 09:10 AM - edited Jun 14 2022 09:11 AM
@BrianHarry1730 I don't know about Customer Voice (the old Forms Pro), but with standard Forms there is no way to have variables.
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)
Jul 21 2022 08:55 AM
Hi @Megan_V_Walker
I have the Excel of FormA and FormB in a sharepoint
and as you mentioned, im trying to get the parameters of two fields from FormA, so i cant put that data in Form B, so i can create a relationship or conection with the two forms, and be able to do my graphs analysis
Sadly, i have not gone any further, and Im stuck, Im thinking to check powerapps or just do the survey in web via html
any suggestions?
Best Regards!
Mario Riestra
Jul 24 2022 12:16 AM
@MarioMagic there is no no ability to have a relationship between 2 forms. If your users are intenral then Power Apps is certainly a good option and can do what you want.
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)
Jul 25 2022 06:55 AM
Good Day! and Good Week @RobElliott
Some users are internal others are external, thats why i wanted the conection or relantionship between formA and formB, so i can know which user answer is related to what!
What i have read and check that powerapps can help as a type form to get the data,
Ive already done that, just checking if, it can insert a row on my excel via powerautomate, and we are in business , I hope, fingers cross
Jul 25 2022 07:36 AM
@MarioMagic Power Apps Portals (for external use) is expensive. It would be better and at no cost to have the 2 forms both saving to a SharePoint list or to an excel spreadsheet via a flow in Power Automate. That's easily do-able.
Rob
Los Gallardos
Microsoft Power Automate Community Super User