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

[Sonisoni77]

Hello,

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.

Thanks

[ccc333ab]

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')

[Sonisoni77]

Hello,

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.

[ScottShearer]

@Sonisoni77 

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

[Sonisoni77]

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.

[ccc333ab]

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 anyway....how I got around it was to: 

1. Go to my form

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

3. Paste the ID into that field

[Sonisoni77]

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 .