Answered

Read / write on an excel file on Teams (Shared Point)

Like (0) Share

Report

Posted on 3 Feb 2022 18:41:49 by aleksvp

I need to use as a datasource for my App an excel file that is on Teams, which, as far as I understand is acctually hosted on SharePoint.

I know that there is a (complicated) way to read it from SharePoint (explained in this POST), but I also need to be able to write back to it.

I'm not the owner but I have full access to the file. One thing I've tried was to share it with me so it would appear in OneDrive (so I can access through OneDriveForBusiness). But, the shared files do not appear using OneDriveForBussiness conector.

Can anyone help me out with this?

Tks!

Categories:

Dataflows

Connecting to Data

Connectors

All responses (5)

Answers (1)

aleksvp 55 on 04 Feb 2022 at 12:33:13

Like (0)

Report

Re: Read / write on an excel file on Teams (Shared Point)

Tks
aleksvp 55 on 04 Feb 2022 at 12:33:03

Like (0)

Report

Re: Read / write on an excel file on Teams (Shared Point)

Just to make things clear for whoever reads the solution above: the solution is to create a flow using Microsoft Flow, which can be done directly from https://make.powerapps.com/, in the left bar there is the icon to create flows.
Chose New Flow -> Instant Cloud Flow -> PowerApps -> New Step -> Excel Online.
Verified answer

thekhristy_ 38 on 03 Feb 2022 at 20:24:46

Like (1)

Report

Re: Read / write on an excel file on Teams (Shared Point)

I see - I've updated the screenshot to help you out. You can actually browse your SharePoint Site straight from the Excel actions:
aleksvp 55 on 03 Feb 2022 at 19:37:21

Like (0)

Report

Re: Read / write on an excel file on Teams (Shared Point)

But how?
I've tried using SharePoint connector.
Using flows like the post I've mentioned?
thekhristy_ 38 on 03 Feb 2022 at 19:30:21

Like (0)

Report

Re: Read / write on an excel file on Teams (Shared Point)

Hi, I know you want to ODFB but the Update using SharePoint is actually quite straightforward as well: