When a list is updated, update an excel table in a dynamic excel file

%3CLINGO-SUB%20id%3D%22lingo-sub-2692142%22%20slang%3D%22en-US%22%3EWhen%20a%20list%20is%20updated%2C%20update%20an%20excel%20table%20in%20a%20dynamic%20excel%20file%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2692142%22%20slang%3D%22en-US%22%3E%3CP%20class%3D%22_1qeIAgB0cPwnLhDF9XSiJM%22%3EHi%20all%2C%3C%2FP%3E%3CP%20class%3D%22_1qeIAgB0cPwnLhDF9XSiJM%22%3EI%20have%20a%20list%20where%20the%20first%20column%20is%20also%20the%20name%20of%20an%20excel%20file%20in%20a%20sharepoint%20folder%20(minus%20the%20.xlxs).%20When%20a%20row%20is%20added%20to%20the%20list%20or%20is%20updated%2C%20i%20would%20like%20the%20remaining%20columns%20to%20be%20added%20or%20updated%20to%20a%20table%20in%20the%20corresponding%20excel%20file.%26nbsp%3B%3C%2FP%3E%3CP%20class%3D%22_1qeIAgB0cPwnLhDF9XSiJM%22%3E%26nbsp%3B%3C%2FP%3E%3CP%20class%3D%22_1qeIAgB0cPwnLhDF9XSiJM%22%3EI%20thought%20something%20like%20this%20might%20be%20a%20good%20starting%20point%20but%20it%20just%20keeps%20running%20when%20i%20test%20it%20and%20doesn't%20complete.%20Can%20someone%20help%20me%20out%20with%20this%3F%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Capture.PNG%22%20style%3D%22width%3A%20433px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F306245i06FBA984A2AABCE0%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Capture.PNG%22%20alt%3D%22Capture.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2692142%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Flow%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2702336%22%20slang%3D%22en-US%22%3ERe%3A%20When%20a%20list%20is%20updated%2C%20update%20an%20excel%20table%20in%20a%20dynamic%20excel%20file%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2702336%22%20slang%3D%22en-US%22%3E114%20views%20but%20no%20replies.%20Is%20anyone%20able%20to%20help%20with%20this%20please%3F%3C%2FLINGO-BODY%3E
Occasional Contributor

Hi all,

I have a list where the first column is also the name of an excel file in a sharepoint folder (minus the .xlxs). When a row is added to the list or is updated, i would like the remaining columns to be added or updated to a table in the corresponding excel file. 

 

I thought something like this might be a good starting point but it just keeps running when i test it and doesn't complete. Can someone help me out with this?

Capture.PNG

1 Reply
114 views but no replies. Is anyone able to help with this please?