Power Automate

Read Excel Table Data from File Content (contentBytes) in Instant Cloud Flow

(0) Share

Report

Posted on by asit00

Hi everyone,

I’m working on an Instant Cloud Flow where the input parameter is a File content (Excel file).

When I manually trigger the flow, I want to upload an Excel file and then read the table data from that file.

At runtime, I have the following two dynamic values available:

contentBytes – the file content in base64 format

name – the file name (e.g., “Data.xlsx”)

Is it not possible to use it directly in Power Automate to read the table rows using the “List rows present in a table” action (without first manually storing the file in OneDrive or SharePoint).

Is there another option, or do I need to create the file and read its data temporarily?

Thanks in advance!

Categories:

Using connectors

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Suggested answer

Tomac 4,055 Moderator on at

Like (1)

Report
Copy link

Link copied!

@asit00 Your assumption is correct - you need to write the content to a file. The actions for Excel rely on the file being processed by the SharePoint/Azure back end, Power Automate doesn't read the Excel content directly.

Once you write the content to a file, you can use the Excel actions with dynamic pointers to work with that dynamic file and, if you don't need it stored after, then use Power Automate to delete that file.

Was this reply helpful? Yes No
Suggested answer

Daniel Bocklandt 5,151 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hey @asit00,

Sadly it is not possible to read the table rows directly since the content bytes are in Base64 as you mentioned yourself.

The easiest and most reliable way to do it is to save it temporarly into Onderive or Sharepoint and delte it afterwards again.

If this solved your problem, please mark it as Solved to help others find the solution faster.
If you found it helpful, consider giving it a Like to support each other in this community!

Thanks, and happy building!

Was this reply helpful? Yes No
Tomac 4,055 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hi @asit00

Are you still having trouble with this? If not, please remember to mark the comments that solved the issue as the answer, to help future people searching for a solution to this issue.

Was this reply helpful? Yes No