Answered

Many Sharepoint List

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I have created a form and one question in the form is location so based on that question I have various list so when the form is submitted if the user selects Brampton i need to create item in Brampton list and if user choose "Calgary" then responses submitted need to be created in Calgary list, Can i do that in one flow?

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

MarconettiMarco 3,812 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hello @Anonymous ,
you can use the "Switch" control, like below:
In the "On" field, please put the specific Forms question, and in the "Equals" for each switch, put the value you're expecting.
So, if for instance the user put "Calgary", the flow will follow the "Calgary" switch.

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

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Thank you Marco, I have tried this method but I have like 15 locations and i wanted to ask if there is any other method to do this?

Was this reply helpful? Yes No
Verified answer

MarconettiMarco 3,812 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hello @Anonymous ,
an alternative method could be to:
1. Initialize a String variable and put the specific question got from the trigger
2. Then, in the SharePoint "Create item" action, put the variable in the "List Name" field using the custom value.
3. After doing that, an "Item" field will be shown in the "Create item" action, in which you have to put the JSON with all the necessary properties (fields and related values) that must have the item.

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

Was this reply helpful? Yes No
MarconettiMarco 3,812 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hello @Anonymous ,
If I have answered your question, please mark the post as Solved, so that the Community is aware of.

BR,
Marco

Was this reply helpful? Yes No