Pulling Forms responses to Lists

[DW22]

This query is quite similar to alexb11's yesterday.  Following that, I have checked there were no other rouge flows running and shut anything suspect off.

However,

I am trying to create a flow that will include taking new responses throughout the day until 3pm and use them to create an item on a SharePoint List.  (I'd even be happy if it could just take all responses as at 3pm, but it seems I need to use the 'when a new response is created' trigger to get the dynamic content for 'get response details'). This is the chunk of the flow failing.

• It seems that it will only take the first response and ignore the rest;
• I've tried putting this into a 'do until loop'.  With various tweaks I have gotten it to take the first response and populate the list with it several times (ignoring the subsequent responses) or, at one point, collecting all responses as they came in, but creating 4-5 fields in Lists for each response.

Grateful for any advice on how to get the section of the below flow to populate the List with each response once by 3pm, then move on to the next command.

[FLMike]

Hi @DW22 

I gotta say I'm more confused then when my wife explains "The Housewive of anywhere" shows...

1. Why are you sending an email before the blocking Trigger?

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?

You have a double layer loop, that uses get responses / user profile and Create item just 1 time. Why are they in a loop?

It shows there is some error, but I don't see the actions that have the errors can you share them.

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?

What will happen with replies that come in After 3? Are you just going to ignore them?

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.

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.

lol 

Cheers
If you like my answer, please Mark it as Resolved, and give it a thumbs up, so it can help others
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

[DW22]

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.

[FLMike · Accepted solution]

HI @DW22 

No the get response works great I am building a sample right now.

Flow 1: Recurring for Monday Email Link

You need to have a separate Recourring for the email and sending out the form link, from capturing results. Thats a big reason, as mentioned that its all bonkers

Flow 2: Getting responses.

I am going to give an example and then I am going to talk about the elephant in the room.

As you can see I do not get an Apply to each, which tells me you are picking the wrong property to fill the Response Id

Actually here is what we need to do. Before we start fixing, you need to start a whole new flow that only has the trigger for New Responses being submitted. Then add Get Response details like I did, set the properties and lets see what happens.

I only have one property from the Trigger so...i'd rather NOT try to debug the flow that is jacked up anyway.

Cheers
If you like my answer, please Mark it as Resolved, and give it a thumbs up, so it can help others
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

[DW22]

Thank you so much, Mike.  That makes sense and is a much clearer approach.  I do tend to get myself into unnecessarily complicated messes when new at things!