Get Excel data using OneDrive for Business?

(0) Share

Report

Posted on by Dimani

Hello

Am trying to create a Power Automate flow to get data from an Excel file.

We have OneDrive for business connector, and we do not have Excel online connector. The OneDriver has get file content, but its documentation does not say how exactly to get the data out.

I noticed that there is "add dynamic content" on the lower right of the file name/path text box in the OneDrive object. Do I use this to extract data from the Excel file? The file has multiple rows (record). Can Power BI be setup to loop through them? Each record is meant to be a task that we want to create in the Planner.

Thanks,

Dimani

Categories:

Using flows

I have the same question (0)

All responses (3)

Answers (0)

Sort by

ScottShearer 25,290 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@Dimani

You'll need the Excel Online (OneDrive) connector to rea data from an Excel file. In addition, the data must be in a table.

The Excel Online (OneDrive) connector is standard - if you don't see it contact a Power Platform admin in your organization.

Was this reply helpful? Yes No
Dimani 15 on at

Like (0)

Report
Copy link

Link copied!

ScottShearer

Thanks for your reply. We do not have Excel Online in our M365 as mentioned in my original post. Therefore it does not matter when I ask our Power Platform admin.

Best regards,

Dimani

Was this reply helpful? Yes No
ScottShearer 25,290 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@Dimani

First, to the best of my knowledge the Excel connectors are part of Power Automate with all M365 tenants. If it isn't there the reason is that the connector has been disabled/removed by a Power Platform admin.

Second, without the Excel connector, I am unaware of any way of reading in Excel data in Power Automate.

Was this reply helpful? Yes No