1.when a new item is saved onto to sharepoint list
2. read some specific values from that row
3. open connection to an excel file (on a different sharepoint site)
4. create a new row
5. enter values from step 2 into specific columns in row from step 4
I can do every (steps 1 & 2, i have done in another flow and step 4&5 i think i can figure out) step above except Step 3. I am having trouble no matter where i store that excel file. Tried local file, one drive and excel buisness. None of them are working for me. Can someone please post an example if they have it? Or give me detailed instruction to connect to use excel connector?
Thanks your reply. I am trying to use Excel online (Business). But i am having trouble accessing the file no matter which folder its under. I tried main "Dcouments" folder under sharepoint site, another custom folder and sub folder as well. IS there a way to specify a custom value for wither the Document library path or the file path?