Multiple Form responses (from Excel) to one Sharepoint list

%3CLINGO-SUB%20id%3D%22lingo-sub-1761198%22%20slang%3D%22en-US%22%3EMultiple%20Form%20responses%20(from%20Excel)%20to%20one%20Sharepoint%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1761198%22%20slang%3D%22en-US%22%3E%3CP%3EHi%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECould%20anyone%20help%20with%20this%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20using%20MS%20Forms%20and%20generating%20a%20QR%20Code%20as%20a%20track%20and%20trace.%26nbsp%3B%20I%20have%20a%20form%20for%20each%20room%2C%20staff%20scan%20the%20QR%20Code%20they%20click%20Enter%20or%20Exit.%26nbsp%3B%20The%20form%20record%20user%20name%20email%20time%20and%20whether%20they%20entered%20or%20exited.%26nbsp%3B%20The%20form%20is%20named%20by%20the%20room%20number.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20to%20combine%20and%20append%20all%20the%20form%20responses%20into%20one%20Excel%20sheet%20or%20sharepoint%20list%20and%20pull%20in%20the%20file%20name%20(which%20is%20the%20room%20number)%20also.%26nbsp%3B%20I%20have%20tried%20a%20flow%20nut%20it%20is%20proving%20quite%20difficult.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20anyone%20advise%20please.%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1761198%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EForms%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20Forms%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPower%20Automate%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1766989%22%20slang%3D%22en-US%22%3ERE%3A%20Multiple%20Form%20responses%20(from%20Excel)%20to%20one%20Sharepoint%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1766989%22%20slang%3D%22en-US%22%3ESeems%20like%20you%20created%20different%20forms%20for%20diff%20rooms%20with%20different%20individual%20QR%20code.%20On%20what%20basis%20would%20you%20like%20to%20merge%20these%20forms%20in%20one%20single%20excel%3F%20for%20example%2C%20on%20basis%20of%20the%20same%20responder%20list%20(seems%20like%20the%20receivers%20could%20be%20different%20people%20in%20diff%20rooms%3F)%2C%20the%20selected%20forms%20ID%3F%20(then%20the%20forms%20should%20be%20identical).%20Happy%20to%20discuss%20more.%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

Hi

 

Could anyone help with this?

 

I am using MS Forms and generating a QR Code as a track and trace.  I have a form for each room, staff scan the QR Code they click Enter or Exit.  The form record user name email time and whether they entered or exited.  The form is named by the room number.

 

I want to combine and append all the form responses into one Excel sheet or sharepoint list and pull in the file name (which is the room number) also.  I have tried a flow nut it is proving quite difficult.

 

Can anyone advise please.

Thanks

2 Replies
Highlighted
Seems like you created different forms for diff rooms with different individual QR code. On what basis would you like to merge these forms in one single excel? for example, on basis of the same responder list (seems like the receivers could be different people in diff rooms?), the selected forms ID? (then the forms should be identical). Happy to discuss more.
Highlighted

@Tinker_Bell as you have multiple forms you would need to have multiple flows in Power Automate, one each for when the form for that room is submitted. This is because you can only have a single trigger in your flow. All the flows can save the responses to the same SharePoint list but there's no way to get round having multiple flows.

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User.
If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.