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

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Users online (4,342)