Hi Barry,
Thank you for your reply.
I'm a Power Automate entry level user with no experience in Java Script.
I think my requirement has 3 parts:
Build an Azure SQL table with data from hundreds of excel files saved in SharePoint, each one with same columns.
Merge to that same table other hundreds of excel files with other columns. The two type of files has the date column as common field.
I have a Power Automate flow activated that saves 2 daily files I receive in my gmail account, in a SharePoint folder. The idea is to update the new SQL table with the new data on daily basis.
Can you please share some documentation that I can refer to complete the 3 tasks?
Thank you,