Unanswered

Cannot connect to Excel Sheet in Teams file

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi, I am working on my first Flow, in which I am trying to keep track of new Planner tasks in an Excel sheet. When I try to connect to the Excel File, in the Microsoft Teams files, i can't choose from any Elements in the Dropdown Menu. I have already formated a table in my Excel Sheet but that didn't change anything.

Please help.

Categories:

Using connectors

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Here is a screenshot of my problem and another screenshot from a test flow i did. Might the 1st error be a result of the error in the 2nd screenshot of being denied to access the excel file in the teams folder?

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Second Screenshot:

Was this reply helpful? Yes No
Pstork1 69,205 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

I might be missing something due to the language difference, but the Excel connector is specific to OneDrive for Business. If you are trying to use it on a Teams site it won't work. I know the addresses for the Team sites show in the list, but I think that's because MS is using a standardized component to get that list of sites. At one time there were trhee excel connectors, a regular one that worked with SharePoint, one for OneDrive for Business, and one for OneDrive. I don't see the regular one as available anymore, only the ones for OneDrive and OneDrive for Business.

Was this reply helpful? Yes No