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
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
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
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.
Hi Serbay,
Thank you for this. Can you please explain how we could do this?
Thanks,
Alex
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Did you know that you could restore a deleted flow? Check out this helpful article.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
User | Count |
---|---|
32 | |
32 | |
25 | |
24 | |
21 |
User | Count |
---|---|
64 | |
56 | |
44 | |
37 | |
29 |