Make a Powerpoint with table from SP list with Automate

[Fer]

Hi! I have a SharePoint list with different tasks assigned to each team. I want to create a presentation that includes a slide for each team, featuring a table with all the tasks apply to them.

This is basically the data from the list:

I already made a flow in Power Automate but it gives every task in the list, and doesnt split them.

Thanks in advance.

[Petr (Petr Bushuev)]

Hello @Fer,

Please check out my example:

1. This is my PPTX template. I created a slide for each team and want to add a table with tasks for them.
   Team.pptx (37.4 KB)
   
   

and the SharePoint list:

2. To do this I need to have a JSON structure like this one:

{
  "Team1Tasks": [
    {
      "value": "team1task1"
    },
    {
      "value": "team1task2"
    }
  ],
  "Team2Tasks": [
    {
      "value": "team2task1"
    },
    {
      "value": "team2task2"
    }
  ],
  "Team3Tasks": [
    {
      "value": "team3task1"
    },
    {
      "value": "team3task2"
    }
  ]
}

3. To achieve the structure in Power Automate, I need to use variables. This is my flow:

As you can see, I created 3 array variables to collect tasks for each team. Then I added the Switch option to append tasks depending on the Team name: if the team is Team1 => append to array Team1Tasks, etc.

Also, please click the buttons in the Plumsail action to add the variables:

4. Then I run the flow

5. And get the result.

TeamTaskProcess - result.pptx (47.7 KB)

6. If you want to get the Teams names dynamically from the SharePoint list, you'll need to create more complex JSON and arrays.

Best regards,
Petr
Plumsail team