cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sumak
Helper II
Helper II

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
v-micsh-msft
Community Support
Community Support

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
v-micsh-msft
Community Support
Community Support

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.

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.

 

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
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (5,386)