This is a common requirement. The key is to take the single form response, convert the members field into an array, and then loop through it to create multiple SharePoint items.
1. Convert members to an array
Forms does not return a real array for multi-select questions, so you need to convert it first.
If using a multi-select question:
json(outputs('Get_response_details')?['body/YourQuestion'])
If using comma-separated text:
split(outputs('Get_response_details')?['body/YourQuestion'], ',')
Replace YourQuestion with your actual field from Get response details.
2. Loop and create items
Add an Apply to each and pass the output from the step above
Inside the loop, add Create item (SharePoint)
For the member field, use:
trim(item())
Map common fields like date, item, and approver directly from the form response
Example
If the form has:
- Members: A, B, C
- Item: Laptop
The flow will create 3 SharePoint items, one for each person, all with the same item details.
This ensures clean data and avoids the common issue where Forms data cannot be looped directly.
✅ If this answer helped resolve your issue, please mark it as Accepted so it can help others with the same problem.
👍 Feel free to Like the post if you found it useful.
Share
Report
All responses (
Answers (
2,191
