Forum Discussion
Can multiple users fill out the same form?
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.
- Form A
- Form B
- This form needs survey variables added to it that you can then use to capture the values from Form A. You can only have 13 variable though (15 including two standard ones, First Name and Last Name
- You can then use the variables and display them at the top of the survey. This might help to see what I am referring to in showing the variables at the top of the survey: https://meganvwalker.com/updating-records-from-responses-using-piped-variable-parameters/
Then this process:
- Form A is shared with whoever needs to complete it.
- A flow in Power Automate that is triggered when Form A is completed and the flow generates a survey invitation for Form B that is sent to someone. As part of the flow, you will need to get the responses from Form A, and then use the values from the responses and put them into the variables in the step where you create the survey invitation.
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
- RobElliottJul 24, 2022Silver Contributor
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)- MarioMagicJul 25, 2022Copper Contributor
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- RobElliottJul 25, 2022Silver Contributor
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