Logic App Create Table

Question

Hello,

need pls help with this:

i got a lot of different xlsx files and im using a logic app with the excel connector to create tables in the xlsx files. The create table wants a A1 notation but the files arent allways the same so i need a solution how to set the table range exactle where the data rows collumns end. I hope you can help me. kind regards

Answer 1

Hi @clouddataquest ,

Welcome to Microsoft Q&A Platform. Thank you for the question.

In this case personally I would suggest you to go with Azure Function approach and write a function and then load the data in table.

You can refer below Microsoft Documents to get some help,

https://stackoverflow.com/questions/43171845/download-an-excel-file-and-read-content-with-azure-functions

Regards,
Kamlesh Kumar
BizTalk Techie

Please don't forget to click on or upvote button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is How

Want a reminder to come back and check responses? Here is how to subscribe to a Notification

If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators