Update excel file in multiple folder when a new Form is submitted
I have multiple folders in my Sharepoint which in each folder contains an excel file name "Response.xlsx" that record responses submitted in Forms as below. The folder name is based on "Estate" value in the Microsoft Forms.
I manage to create a Flow to update the Response.xlsx file as below:
Ultimately, what I want is for the Flow to update the excel file in multiple folders which is created based on "Estate" value in the Form. I tried to replace File in the "Add a row into a table action" from /MHH_EST/Ldg D/Response.xlsx into /MHH_EST/Estate/Response.xlsx but I stuck there.
Any recommendation on how should I change my "Add a row into a table" to make it responsive based on "Estate" value chosen by user in the Forms?