Showing results for 
Search instead for 
Did you mean: 
New Member

Forms to SharePoint condition with multiple choice response save to multiple SharePoint site


I have created Microsoft Form with multiple dropdown option (A,B,C,D,E,F,G,H,I,J).  I have 10(ten) SharePoint sites. when  response is submitted in form i want to save response in SharePoint site. If they select A it should save in A Site, If they select B is should save in B site. Please help me how to create power auto flow for this.



Solution Sage
Solution Sage

You can just concat your form response with the word ' Site'. 


So for example, create an expression of: 

   concat(FORMFIELD, ' Site'). 


Replace FORMFIELD with your dynamic content from a "Get response details" action, using the field you are storing your lettes (A, B, C, D,...) in. 


Her is an example: 


The expression here says: 

concat(outputs('Get_response_details')?['body/r743843e3aacc40308a8c75593a47ab11'],' site')



Thank you for your response. I am not expert and i am getting below error. Is there a way you can show me step-by-step process.




Have you selected a Form in the When a new response is submitted trigger?



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


Yes, I have selected my form(screenshot below). Do you think I have to create new form because I am not able to see Form ID? I am using same admin account.





Solution Sage
Solution Sage

That is weird you can find the form in "Whan a new response is submitted", yet you can't in "Get response details". I've had it before where I couldbn't select it in the first box before....but I got around it was to: 


1. Go to my form

2. Look in URL and copy formID (at the end of the url) 

Screenshot 2021-07-01 10.09.29 AM.png

3. Paste the ID into that field

What about response ID?  "Response ID" ?


Here is one flow that I have created yesterday and working . Adding all response to SharePoint list but I want only B response in SharePoint list when they select option " B" can you please tell me how and where what logic I have to add .





Helpful resources

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

MPA Licensing.jpg

Ask your licensing questions at the Power Automate AMA!

Join Priya Kodukula and the licensing team, super users and MVPs to find answers to your questions on Power Automate licensing.

Users online (3,249)