Unanswered

Read Excel Data based on cell range not on Table Structure

(0) Share

Report

Posted on by josephgamit

i want to create automate flow for reading and writing excel data but in flow i am not able to retrieve data because it only work with Table Structure without table it is not working provide me any solution for that i want to read write data based on cell range using power automate flow..

Categories:

General topics

I have the same question (0)

All responses (5)

Answers (0)

Yutao Huang Microsoft Employee on at

Like (0)

Report
Hi @josephgamit ,

Do you think you can insert a "Create table" action to convert the data range into a table before interacting with the data? Or is that you have to keep the non-table structure?

If it's the case that you have to keep the non-table structure, maybe you can give the new "Run script" action a try. Here are a few links that might be helpful to learn about the Run script action in Power Automate:
Announcing support for Office Scripts in the Excel Online (Business) connector
Run Office Scripts with Power Automate
Call scripts from a manual Power Automate flow
Pass data to scripts in an automatically-run Power Automate flow

In essence, the "Run script" action can run a script you have previously created inside Excel Online. In that script, you can read/write any cells you want.

Hope this helps!
Yutao

Was this reply helpful? Yes No
JoeBeckie 20 on at

Like (0)

Report

Hi does this solution work? has anyone tried it?

Was this reply helpful? Yes No
JacksonOng 51 on at

Like (1)

Report

Hi for my case, it doesn't work. I have an export from SSIS into excel. the SSIS file isn't formatted to table and the file is required to be read and push to another archive folder.

I cant put a script into the file. So I am still thinking if there is any possible solution to this.

Was this reply helpful? Yes No
Yutao Huang Microsoft Employee on at

Like (0)

Report

@JacksonOng - Office Script is actually not stored in the Excel workbook. It's stored on your OneDrive and you should be able to run the script against any workbook you have access to. You can write up a script to directly read values from cell ranges so you don't need to modify the original workbook to convert cells into tables.

Was this reply helpful? Yes No
JacksonOng 51 on at

Like (0)

Report

Hi Yutao, I managed to read the file already, I didnt know that create table function in power automate actually is used to format the excel file.

Thanks so much for your reply

I had refer to this. Hope it is useful to others to watch this video : https://www.youtube.com/watch?v=WbJHq2cTq4U

Was this reply helpful? Yes No