Answered

Cannot Read Excel On OneDrive for Business

(1) Share

Report

Posted on by MarcRohde

109

I am trying to create a flow to get a row from an Excel file in OneDrive for Business. The connection let's me browse to the spreadsheet but I can't get it to recognize the table. I have a single tab in the sheet I'm expecting to see.

I have tried in multiple browsers as well as the Android app and get the same results on each.

I assume I have a connection if I can browse the folders to select the file.

Categories:

Using connectors

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

chandbhu Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi,

The problem could be that excel sheet does not contain a table.
Please open Excel file and highlight the data you want to access and select "Insert"->"Table" and save the file.
You should be able to see the newly created table from the Get Rows card for OneDrive for Business.

Thank
Chandra

Was this reply helpful? Yes No
MarcRohde 109 on at

Like (0)

Report
Copy link

Link copied!

This is exactly what I needed! I was assuming a table was the same as a tab.

Was this reply helpful? Yes No
Mrizan 4 on at

Like (0)

Report
Copy link

Link copied!

It defines the name "Table1" by default

Was this reply helpful? Yes No