Flow to use a list, when item added, will update fields in an excel sheet

[sumak]

Here is what i am trying to do:

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

[v-micsh-msft · Accepted solution]

Hi,

There is no need to open the Excel connection.

There are threee kind of Excel connectors.

If your file stored under OneDrive for Business or SharePoint library, then choose:

Excel Online (Business)

For Personal OneDrive account, choose

Excel Online(OneDrive)

You could just add the Excel connector, then sign-in with your account.

Regards,

Michael

[sumak]

Hi,

Even when i have the file under Documents folder, when i try to access it with "Add a row into a table" action, its not listed. See attached.

Thanks for your help.

[sumak]

Hi,

(Looks like my earlier reply did not get posted).

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?

Thanks.