Power Platform Community Forum Thread Details

Hi!

I am currently using the 'List rows present in a table' block with a filter on e-mail.

The trigger block is 'When a new response is submitted'.

The problem I am encountering is that the List returned by 'List rows present in a table' sometimes does not include the recently submitted response!

I was thinking the excel needs time to actually put the new response in the excel, so I added a delay block with 3 minutes delay before Listing Excel rows.

The problem keeps occurring... The excel File has about 10-30 rows.

The blocks in between are some Initializations of variables. (irrelevant to this problem).

Where the function in between '' :

trim(outputs('Get_response_details')?['body/responder'])
 
Again: the entire flow works, but sometimes just doesnt see the newly submitted form in the excel file it fills.

Any solutions or work-arounds?
 
Kind regards,

Categories:

Building flows

Hmm

So.. this is probably related to the same issue many people find, which is, unless you Open the file (actually open it), it doesn't always appear refreshed. I cannot tell you how many people have this issue, some go through the process of using PAD just to open it to refresh it first.

however, if I might ask a question, just to see if there is another way to help you, but since you trigger on a new response, if the response isn't in the list, you have the details right there in the flow to use.

or secondarily would it make more sense to store the submitted responses in SharePoint, so you don't have this issue? You could store it in SharePoint, then have a Flow that triggers on added or modified items and then iterate through all the items.

The other thing is... you may also run into situations where multiple people are posting at the same time. With all of them writing to the same file... its not a great option to try to list all the rows each time because you could be doing the same things multiple times across multiple people.

Just some thoughts.