Hi Forum,
I'm hoping for some assistance with a relative noob to the Flow platform....i've created a couple of simple Flows before but I'm not pushing my knowledge a little further with attempting to integrate a Microsoft Form output into Excel. It's more complicated than I have designed previously in that the responses from the Form need to determine with a "Customer ID" is already present within the Excel worksheet and if so to update or ideally append the existing data.
I've found an existing solution on the forum which i used to design the initial condition checking on the Excel worksheet but having replicated the design my purposes I seem to generate errors....hoping someone on here can point me to the error of my ways.
This is the existing solution:
https://powerusers.microsoft.com/t5/Building-Flows/Form-Submission-Update-Row-in-Excel/td-p/286693
Below screenshots of my design and error messagesError
Flow Overview
Initial conditions
update/append

Report
All responses (
Answers (