Reading an Excel file from OneDrive

(1) Share

Report

Posted on 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 (0)

Suggested answer

FLMike 23,361 on at

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.