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!!
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.
Was this reply helpful?YesNo
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
8
Share
Report
All responses (
Answers (
