Design Assumptions:
Master List:
It has a column, for example, SupplierNames which is a choice or multi-select column where you select one or more suppliers.
Other columns, for example, ActionDetails for the details of the action.
Supplier Lists:
Each supplier has separate lists, for example, SupplierA List, SupplierB List, etc.
Have similar structure to the master list, with columns to hold the action details.
Steps in Building the Flow:
1. Trigger: When an item is created or modified
Action: Have the master SharePoint list with the trigger When an item is created or modified.
2. Get the Supplier Names
Action: Use the Get item action to retrieve the item details from the master list.
Parse the SupplierNames field (multi-select choices) to determine the suppliers for which the action applies.
3. Apply to Each: Loop through the Supplier Names
Action: Use the Apply to Each action, looping through the SupplierNames field.
4. Conditional Logic or Dynamic List Name Assignment
Option 1: Conditional Logic
Add a Condition for each supplier name (e.g., SupplierA, SupplierB, etc.).
Inside each condition:
Use the Create item action to create a new item in the corresponding supplier list.
Option 2: Dynamic List Name Generation
Assuming that the names of your supplier lists are similar to SupplierA List and SupplierB List, then you can dynamically generate the name.
Use an expression similar to the following one, that is, concat('https://<YourTenant>.sharepoint.com/sites/<SiteName>/', variables('SupplierName'), ' List') in the Site Address/List Name field of the Create item action.
5. Populate Supplier List with Action Details
For each iteration of the loop, use the Create item action:
Map fields from the master list to the corresponding columns in the supplier list.
6. (Optional) Update the Master List
Once all supplier lists have been updated successfully, you can update the master list item to indicate completion or status, for example, "Action Distributed".
