Power Automate flow for MS form that updates resubmitted responses within an Excel spreadsheet

Question

Apologies if this question has been asked before, I am relatively new to using Power Automate. I have created a flow for a Microsoft Form response to be added to a table in an Excel spreadsheet which works fine.

I would like to give respondents the ability to save and resubmit their responses and I would like these updates to be updated within the Excel spreadsheet.

I have created an automated cloud flow that is triggered when a new response is submitted with the following trigger and actions:

When a response is submitted

Get response details

Delay (to ensure passing of full data, just in case)

List rows present in a table

Filter array (filter query Response Id)

Condition: if true, update a row, if false, add a row.

This doesn’t work automatically as technically it isn’t a new form being submitted but works perfectly when tested with a recent trigger – so when it is force ran. I have tried other triggers such as ‘Manual trigger’ or ‘Occurrence’ and scheduling it, but these triggers don’t have direct access to Response Id, presumably as they are not MS form connectors. I am quite stuck and have not been able to find a solution that fits what I need.

Thank you for any advice or help – it would need to be reasonably plainly and simply explained for me to follow (to my embarrassment).

Answer 1

Hi,

This question is not supported in Q&A. For further assistance, please re-post here: Power Automate.