Reading an Excel file from OneDrive

Like (1) Share

Report

Posted on 23 Aug 2024 17:21:07 by CU23081708-4

Hello,

I am new to Power Automate and I am trying to read an excel file to get it's content from OneDrive using Power Automate. I used the Get File content and then used a compose statement with base64ToString(outputs('Get_file_content')?['body']?['$content']) to extract $content value from the Get File content output but I am getting an output in the following format. Any help is greatly appreciated. Thank you!!

Categories:

General

All responses (1)

Answers (1)

Verified answer

Michael E. Gernaey 42,549 Super User 2025 Season 1 on 23 Aug 2024 at 19:53:29

Like (0)

Report

Reading an Excel file from OneDrive

Hi,

If your content as an Excel Table wrapped around it, then use the List rows in a Table action for Excel and read the data, pointing to the file, and the Table in excel.

I've never seen anyone try to do it how you are and be successful.