cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Simmo86
Helper II
Helper II

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

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

5 REPLIES 5
Serbay
Resolver I
Resolver I

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

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
Helper II
Helper II

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
Resolver I
Resolver I

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
Helper II
Helper II

Hi Serbay, 

 

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

 

Thanks,

 

Alex

Helpful resources

Announcements
MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Power automate tips 768x460 v2.png

Restore a Deleted Flow

Did you know that you could restore a deleted flow? Check out this helpful article.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Users online (3,090)