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.
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:
Have you selected a Form in the When a new response is submitted trigger?
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.
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
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 .
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Read the latest about new experiences and capabilities in the Power Automate product blog.
If you are a small business ISV/Reseller, share your thoughts with our research team.
The AI Builder team invite you to ask questions and provide helpful answers at our next AMA.