cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sumak
Level: Powered On

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

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

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

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

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

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
Community Support Team
Community Support Team

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

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

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

sumak
Level: Powered On

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

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
Level: Powered On

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

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.

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors
Users Online
Currently online: 319 members 5,705 guests
Please welcome our newest community members: