Getting Error when record Form responses to SharePoint: No row was found with Id

[Anonymous]

Hello there,

So I'm trying to record Form responses into a SharePoint list using PowerAutomate, I decided to go with the template "Record form responses in a SharePoint" and I added a new Excel action called "Get a row" since I want to record in my SP list, the "Start Time" and "Completion Time" which using only the template is not possible, so I have to take those columns out of the Excel that contains all responses, so I have this Flow:

I added a delay of 15 seconds so Get a row action has time to take the ID out of the Excel File, but that didn't work, the problem exists when 2 people submit the form at the same time and that could be usual since my form has 3 questions and is been used constantly by 5 people in my company, so if they submit the form almost at the same time I get this:

I really appreciate if anybody can help me with this, thank you in advance.

[365-Assist]

You shouldn't need the Excel file. The actions Get Response Details (Forms) that was in the original template will give all the columns you need for the SharePoint List.

I created a video that may help you. It uses Dataverse but similar Power Automate Flow can be used for SharePoint (8:30 mark).  Creating a Complaints DB with MS Forms, Model Driven Power Apps (Dataverse) and Power Automate - You...

---------------------------------------------------
Please Accept as Solution if it solves your question. Or just give it a Thumbs Up if it is helpful as can help others.

Subscribe: https://www.youtube.com/channel/UCFpvUlpx84FuIPOdInGKMTw
Twitter: https://twitter.com/assist_365

Regards
Darren Lutchner - 365 Assist

[edgarsimoes]

Hello, @Anonymous 

First, I think you should need the "get response details" after the trigger action, if you just needed the submission timestamp:

Secondly, I would recommend to try use "List rows present in a table" action and not "Get a row" action, like this:

And this will filter you new row and get your required fields.

Please, be sure to turn on the pagination option on the action settings, in order, to search in all your forms rows.

Please 'Thumbs Up' the posts that helped you and 'Accept as Solution' if my post answered your question.

Happy automating,

Edgar Simões

[Anonymous]

Thank you for your help, however, besides the submission timestamp, I need the "Start time" which only is possible to get from the Excel with the answers. I tried to use List rows present in tables but that didn't work. I created another Flow but it takes too much time every time it runs:

I don't know if there's an alternative, ideally I want to get "Start time" so whenever an employee starts the Form, and Submission time, to calculate the time they spend answering the Form, that's all I need.

[ChadVKealey · Accepted solution]

Many of the templates around working with form responses have an "apply to each loop". That may have been required at one point in time, but it no longer is. I would clear the value from the "Key value" field in your "Get a row" action, then move that action OUTSIDE OF (below) the apply to each and also delete the Apply to each (the delay isn't/shouldn't be needed either). Then, in the Key value field, enter the "Response ID" from the trigger. This will get the row correctly. Just remember that Excel stores those dates as numbers and they'll be in UTC. If you just want to get the time in between (how long they spent on the form), it doesn't really matter, but if you need to know the exact time that they started and finished in your local time, you'll need to convert the time zone.

[edgarsimoes]

Hello again,

About the flow I would try what @ChadVKealey  said. The only thing I wanted to remind is that Microsoft Forms has an native feature to calculate the Average time that you're seeking for.

[edgarsimoes]

Have you seen my last message?

-Edgar

[ChadVKealey]

@edgarsimoes , it doesn't look like that "elapsed time" is present in the spreadsheet or response details, so getting it programmatically (e.g.: in a flow) requires a bit of math. I assume it's the same math used to render the data on that page ([completion time] - [start time]).

[Anonymous]

Hello, I tried to follow your steps, but when I enter the Key value "Response ID" the apply to each loop is added automatically, I'm not able to remove that apply to each loop, I tried by storing the Response ID in a variable, but I'm still getting the same error, "Row with ID:"XX was not found"

[ChadVKealey]

OK, that template you started with uses the old Forms trigger, which (after some testing I can confirm) produces an output of the "List of responses" (hence the need for the loop). I would suggest you delete the trigger and re-add it, which will use the current version of it which produces a single response (rather than a list). 

[ChadVKealey]

@Anonymous , here's a short video on how to delete and re-add the Forms trigger in that template: https://youtu.be/6GopBPzyS_k

[Anonymous]

Thank you very much, it worked, I had to add a delay though, so the Flow can have time to look for the ID in the Excel file, but I changed the Flow like you said and it worked! I appreciate your help