Getting information from excel file in onedrive for business without a defined table

[Simmo86]

Is it possible to get information from an excel file in onedrive for business without a defined 'table'? I have an excel file in onedrive for business that gets overwritten every morning so I can't define a 'table' in it. I am trying to get the information to run flows such as birthday emails etc. but I am struggling to get the data without the 'table'. Also, not sure whether this is a factor but the sheet name of the document also changes daily. 

Any help would be greatly appreciated.

Many thanks in advance,

Alex

[Serbay]

Hi,
Yes, it is possible to extract data even without having tables from excel with the usage of office script. Could you please tell me more about the next actions? What would like to do after extraction? Then I can share the solution with you.

Regards,
Serbay

[Simmo86]

Hi, thanks for coming back to me. 

It's a list of client data and date of birth and email are two separate columns so I am trying to build a scheduled flow to match the date of birth column with today's date to automate a birthday email.

Thanks, 

Alex

[Simmo86]

Hi @Serbay 

Did this help at all? I am still struggling with this. I have an excel spreadsheet in one drive that is overwritten every morning (so can't define a table) and I want to build a flow that sends an email to all the clients who have their birthday on their birthday. The spreadsheet has Name, Email Address and Date of Birth.

Many thanks in advance,

Alex

[Serbay]

Hi @Simmo86, 
You can write a script that creates a table from plain data. Then you can use excel actions to iterate between rows to get the required data.
Even the solution can be done only using a single script as well. It may be faster and contains fewer API calls for each flow run.

[Simmo86]

Hi Serbay, 

Thank you for this. Can you please explain how we could do this? 

Thanks,

Alex