Ms Forms to Multiple Sharepoint Lists

[Anonymous]

Hi there Flow world! looking to expand on my knowledge. here is where i need some expertise.

• we manage multiple clients at multiple customers. i want to use one form across the client universe for our sales team
• i have built flow already that allows a sales rep to report an account call flow from ms form to a sp. so that is working fine. I want the sales rep to use one form universally 
• i want to build a flow using the ms form but one question decides which sp list the responses will flow too, all other questions in the form are the same. 

1. i know i will need multiple sp lists one per client for the responses to land in
2. the trigger question to direct thhis within the flow is:
   1. Choose the client name: Client 1, Client 2, Client 3.
3. When they choose any of the question response options client 1,2 or 3 in this question i want it to direct the form response to a dedicated s.p. for client 1 , client 2 or client 3. i can map the rest.

here is how i envision it.

• "When a new response is submitted"
• "Get Response Details"
• 'Create Item'

make sense?

[fchopo]

Hello @Anonymous 

I think you're on the right path. I attach an example where I do a similar task, creating an item in SharePoint lists depending on the equipment requested by an employee:

Hope it helps!

Ferran

[CFernandes]

Hi @Anonymous 

You can use the create different list for different client and then, in your PowerAutomate you can use the "switch" condition and create an item to respective in list.

Note: in Form I have a Choice Question with which you can select the client  

Form screenshot below

Power Automate solution below-

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

[CFernandes]

@fchopo  I just realized you replied with a similar solution 🙂 before I did...

I am glad that we are both on the same page..

[Anonymous]

Hi, this is great, i am a bit stuck 

• on the switch i cant see the dynamic option for 'choose client', it only gives me "list of responses' options. 
• after the switch i create a "create item" for each case option
• what do i use as the site address ? do i link it to the new sp specific to that client?

[fchopo]

Hello @Anonymous 

Could you share a screenshot of your flow? Surely it will help us to guide you.

Apart from that, yes, in each case option you will create an item in the specific sharepoint site you want to store that information.

Thanks!

Ferran

[Anonymous]

Hike this works 

 

 

 

 

[fchopo]

Hello @Anonymous 

You should remove the first "apply to each".

Please, have a look at the screenshots provided by @CFernandes and myself, where you will see that after the "When a response is submitted" action, we call the "get response details" without using an "apply to each".

Hope it helps!

Ferran

[Anonymous]

ok trying as we speak:)

[Anonymous]

bingo:) now......question 2. within the create item field do i link the each case to its respective list? ie: one to vita coco list , case 2 could be the next clients list etc etc

[Anonymous · Accepted solution]

1st case has flowed!! now trying the next one case 2....

[CFernandes]

@Anonymous I am glad that our Inputs helped you find a solution..

[fchopo · Accepted solution]

Hello @Anonymous 

Please, mark @CFernandes  posts or mine as accepted solutions, so it will help other community members to find and solve similar problems like yours.

Regards,

Ferran