I’m expecting Request C to be called multiple times, because Y has multiple items. I suspect my issue is related to X, but I don’t know how to say “For each item in Y, call Request C, and pass X every time”
Other notes
if I stick a log on Y, I can see it iterate as many times as I expect. But Request C is always called only once, for the first iteration
Request C is successful, but after the first iteration, the entire Flow is stuck
So, grab stuff from a source site, add it to a destination site, then go back and grab details from the source site, and add it to the new thing you created on the destination site.
Reading through and trying to recreate a simplified version of this flow on my own, I believe the issue is that you’re using two For Blocks which will operate asynchronously and lead to unexpected results. In your second screenshot, you can place a collect block after you’ve created the SQL reports request. This will wait until the first For Block finishes before continuing.
Another (potential) issue is in that second screenshot request, the token port looks like it isn’t connected to any value.