Hello Mike!
I gotta say I'm more confused then when my wife explains "The Housewive of anywhere" shows...
I have a queue of 'new' box sets waiting for binge from 2000 onwards...I might have to add this on : )
1. Why are you sending an email before the blocking Trigger? This is to send out an email at 7:30 am each Monday with a link to the Form to a team for them to fill out.
2. I'll skip the Do Until for now, but why do you have an apply to each. What exactly are you trying to do? When I add the 'List of response details' dynamic content generated by the 'When a new response is submitted' trigger to the 'Get response details' action (which for whatever reason, I've convinced myself I have to do), when it is inside a 'Do until' control, then PowerAutomate automatically puts the 'Get response details' action within an 'apply to each' loop. I can't seem to stop this.
You have a double layer loop, that uses get responses / user profile and Create item just 1 time. Why are they in a loop? The apply to each loop just adds itself as noted above. With respect to 'do until' I added that because the flow seemed to only take the first response then move on to the rest of the actions otherwise (please see below).
It shows there is some error, but I don't see the actions that have the errors can you share them.
All pictured below. I've not finished this iteration of the flow, as it was again stuck on the 'get responses'. In completion (and isolation) the rest of the flow seems to extract the Lists items to an email and send it out fine.
Are you saying you essentially want a Recurring flow that runs at 3PM to grab all the response, loop through them and write them to SharePoint?
Or
That you want to keep capturing them in real-time but ONLY up until 3PM of that day?
I would prefer the former, but don't seem to be able to do a 'Get response detail' without using the trigger to generate the dynamic content. Ultimately, it would not matter as long as each response was captured once in Lists by the time the 3pm email went out. I've been flipping between the two responses because one did not pick up subsequent responses and the other sometimes did and sometimes didn't, but either way listed the responses multiple times.
What will happen with replies that come in After 3? Are you just going to ignore them?
Yes. Then ensure the Lists fields are deleted before the next week's run.
You cannot do what I think you are trying to do. A single flow will not do that. Trigger flows are intended to run 1 time for every response. they are not intended to be run 1 time, but keep running forever and capture them all.
Ok. So essentially a 'Get response details' sequence does not interact well with other actions in a flow? Then, I suppose turning the caution you noted in the other thread on its head and actually ensuring that there are 3 flows running concurrently (i.e. Morning email automation; Put responses to Lists automation; and Take Lists fields to email and send automation) as long as timings are properly set, might do the job? If that is the case, I think I'm good to go as the parts seemed to work in isolation when I tested them each before trying to integrate them.
Each response will trigger this. Then get written to SharePoint if thats what you want.
If you want to stop collecting them at 3, then put a Conditional Expression ON the trigger that essentially says that the Time is less than 3PM of today.
Since I cant see the whole flow and I truly dont understand what you are doing, I am gonna have to wait for some answers and not guess, wait I guess I did guess. Please see below, but I think you've guessed right and I think your response on your other thread (to take it apart and run concurrently) might be the way to go if it is impossible for a flow to run as combined below.
