Microsoft Teams - Linking multiple form responses to update the same line in Excel or Sharepoint

%3CLINGO-SUB%20id%3D%22lingo-sub-1455263%22%20slang%3D%22en-US%22%3EMicrosoft%20Teams%20-%20Linking%20multiple%20form%20responses%20to%20update%20the%20same%20line%20in%20Excel%20or%20Sharepoint%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1455263%22%20slang%3D%22en-US%22%3E%3CP%3EHey%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPretty%20new%20to%20MSFORMS%20and%20POWER%20AUTOMATE%20(start%20of%20every%20query%20ever)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20hoping%20someone%20can%20help%2Fexplain%20how%20I%20would%20be%20able%20use%20multiple%20MSForms%20via%20Power%20Automate%20to%20add%2Fupdate%20the%20same%20table%20line%20in%20sharepoint%20(preferred)%20or%20Excel.%20To%20monitor%20a%20process%20and%20update%20information%20all%20to%20the%20same%20line.%20I%20have%20been%20unable%20to%20find%20any%20howto's%20online%20so%20far.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1455263%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3Eadd%20to%20sharepoint%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Eadding%20to%20excel%20table%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20Forms%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMSForms%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPower%20Automate%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1456072%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Teams%20-%20Linking%20multiple%20form%20responses%20to%20update%20the%20same%20line%20in%20Excel%20or%20Sharepoint%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1456072%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F695850%22%20target%3D%22_blank%22%3E%40Nomis2020%3C%2FA%3E%26nbsp%3Byou%20won't%20be%20able%20to%20do%20this%20with%20a%20single%20flow%20in%20Power%20Automate%20as%20every%20form%20requires%20its%20own%20flow.%20But%20once%20you've%20got%20a%20flow%20for%20each%20form%20then%20each%20flow%20can%20update%20an%20item%20in%20SharePoint%20providing%20you%20have%20some%20method%20of%20knowing%20which%20item%20to%20update.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3E%3CFONT%20size%3D%222%22%20color%3D%22%23333399%22%3EMicrosoft%20Power%20Automate%20Community%20Super%20User%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hey,

 

Pretty new to MSFORMS and POWER AUTOMATE (start of every query ever)

 

I am hoping someone can help/explain how I would be able use multiple MSForms via Power Automate to add/update the same table line in sharepoint (preferred) or Excel. To monitor a process and update information all to the same line. I have been unable to find any howto's online so far.

 

Thanks in advance

2 Replies

@Nomis2020 you won't be able to do this with a single flow in Power Automate as every form requires its own flow. But once you've got a flow for each form then each flow can update an item in SharePoint providing you have some method of knowing which item to update.

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User

I@Rob Elliott Would you be able to show how with screenshots? i'm trying to get Form a (used by worker) to trigger Form b to be filled (by management). Would i be able to do that with this format?