Power Platform Community Forum Thread Details

I'm trying to create a supply request flow, in which our stores can request supplies through a MS Form and we can save the Item and Quantity in a SQL table. I have been successful in obtaining the items and quantities in their own array using a select function, but now I need to create a row for each item and quantity. Here's a screenshot of the Select function and current array:

For each item and quantity, I want to create a new row in a SQL table as show below:

Any help would be awesome!

Categories:

Building flows

Hi @abyars

After your select, use an Apply to each Action, with the input as the output (aka body) of the Select

This will loop you through each set of data

Then use a SQL Action to add a row, using the item()['Item'] and item()['Quantity'] values

You said SQL, but this could mean any back end so I dont know which exact SQL version you mean.

But if its SQL Server you would use this action

If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others

Cheers

Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey