I have a huge excel file with a bunch of tabs that I would like to convert into one SharePoint List through PowerAutomate so that the list is always up to date.

All worksheets have the same format. The first column will be the sharepoint columns and the “Colonne2” will be a new item for each of the worksheet. I don’t need the “Colonne1” in the SharePoint List.

Here is an example of one worksheet:

Numéro de compteColonne1Colonne24160Subventions total40004310Billeterie 4351Parrainages   Commandites15004353Ventes souvenirs 4450Revenus divers 4541Membres ou cartes d’adhésion 4512Prélèvements 4530Dons 4560Ventes à commission d’oeuvres artistique 4460Ventes boutique 4550Intérêts 4650Transferts de garderie codé comme paie de DNSSAB 4651Transfert de garderie pour événements culturels 5210Sous contractuel05310Transportation105311Per Diem   nourriture bénévoles et artistes05320Cachets hors Ontario05321Cachets artistes Ontario05331Hébergement   Artistes Conférenciers05332Techniciens3005334Équipements de programmation   Locations et Achats4215335Location   lieux, permis de terrain, etc.207,015350Publicité483,945354Relations publiques (réseautage)05356Achats matériaux   prix3 034,155415Sécurité05420Traiteurs et nourritures pour vendre au public167,72

Any ideas how to do this? I want to use PowerAutomate so that the SharePoint list is always current but also gives me the history of each project. I guess I could copy the colums and paste as horizontal on each worksheet, but then the Excel will be clunky. Each worksheet is a project and we will be adding projects all the time.

​I have a huge excel file with a bunch of tabs that I would like to convert into one SharePoint List through PowerAutomate so that the list is always up to date. All worksheets have the same format. The first column will be the sharepoint columns and the “Colonne2” will be a new item for each of the worksheet. I don’t need the “Colonne1” in the SharePoint List. Here is an example of one worksheet:Numéro de compteColonne1Colonne24160Subventions total40004310Billeterie 4351Parrainages   Commandites15004353Ventes souvenirs 4450Revenus divers 4541Membres ou cartes d’adhésion 4512Prélèvements 4530Dons 4560Ventes à commission d’oeuvres artistique 4460Ventes boutique 4550Intérêts 4650Transferts de garderie codé comme paie de DNSSAB 4651Transfert de garderie pour événements culturels 5210Sous contractuel05310Transportation105311Per Diem   nourriture bénévoles et artistes05320Cachets hors Ontario05321Cachets artistes Ontario05331Hébergement   Artistes Conférenciers05332Techniciens3005334Équipements de programmation   Locations et Achats4215335Location   lieux, permis de terrain, etc.207,015350Publicité483,945354Relations publiques (réseautage)05356Achats matériaux   prix3 034,155415Sécurité05420Traiteurs et nourritures pour vendre au public167,72 Any ideas how to do this? I want to use PowerAutomate so that the SharePoint list is always current but also gives me the history of each project. I guess I could copy the colums and paste as horizontal on each worksheet, but then the Excel will be clunky. Each worksheet is a project and we will be adding projects all the time.  Read More

​