Import excel column as an item in SharePoint list

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 forma...

SharePoint Online

michalkornet
Sep 27, 2024
Hi JoelGDucharme, I hope that I understsood the problem correctly. We can create a flow with the following actions:

Initialize Object: type object Value {}
Apply for each: @{outputs('Get_tables')?['body/value']}
Set reset Object: Value {}

Apply to each row: @{outputs('List_rows_present_in_a_table')?['body/value']}
Compose: @{addProperty(variables('Object'),items('Apply_to_each_row')?['Numéro de compte'],items('Apply_to_each_row')?['Colonne2'])}
Set variable : @{outputs('Compose')}

In Compose 2 you can check the result @{variables('Object')}
which in my case is:
{
  "4160": "4000",
  "4310": "",
  "4351": "1500",
  "4353": "",
  "4450": "",
  "4460": "",
  "4512": "",
  "4530": "",
  "4541": "",
  "4550": "",
  "4560": "",
  "4650": "",
  "4651": "",
  "5210": "0",
  "5310": "10",
  "5311": "0",
  "5320": "0",
  "5321": "0",
  "5331": "0",
  "5332": "300",
  "5334": "421",
  "5335": "207,01",
  "5350": "483,94",
  "5354": "0",
  "5356": "3 034,15",
  "5415": "0",
  "5420": "167,72"
}