Forum Discussion

JoelGDucharme's avatar
JoelGDucharme
Brass Contributor
Sep 26, 2024
Solved

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...
  • michalkornet's avatar
    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"
    }

     

     

Resources