Hi All
Im relativley new to power automate.
Im trying to setup a flow by which there is an existing excel sheet with staff names and emails and a "Responded" Column
All the fields in this column are set to "NO" and when the staff member answers yes on the final question on my microsoft form it will change this column to "YES"
I have the form setup just fine. and as far as i can tell.
The flow saves fine with no errors.
However when i try it out the field dosent update and when i check the flow it says its failed.
to troubleshoot i changed the update Row action to "Add a Row into Table"
This works with no issues i can see the blank row added and can see the Flow has succeded.
Any ideas what i may be missing?