Unanswered

Crate Planner tasks from multiple Excel files in a SharePoint folder

(0) Share

Report

Posted on by CU24031401-0

I am struggling having Power Automate go through multiple excel files in a SharePoint folder and create Microsoft Planner tasks in one plan with planner buckets per file that reflect results back to the excel sheets they came from as the planner tasks are updated. I'm struggling with the retrieving information from each file when I "List Rows Present In A Table" when using the File" /dynamic "Folder Path". This workflow will work when selecting an individual file but not when trying to use the dynamic expression.

The excel files will both have 2 sheets. One for "TasksTable" and one for "ResponsiblesTable" (used for a look up table based on a column on "TasksTable"). Tables will be titled the same on every file for Power Automate to query.

The goal is to:
1. Create Planner tasks from "TasksTable" in a single Planner plan, with buckets named based on the "Bucket" column (e.g., "25-099" from a file like "Bid25-099.xlsx").
2. Update the Excel files with Planner task IDs and reflect task progress back to Excel when updated in Planner.

There are many more steps to create the workflow required but I can't get to them if the work process won't progress past this.

Any suggestions? Is this possible or will the List rows only work on one excel file?

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Anastasia 22 on at

Like (0)

Report

Hi,

Please try the following:

In "Apply to each" after the "Get files (properties only)" use @{outputs('Get_files_(properties_only)')?['body/value']} for iterations.

_____________________

Next go the "Get tables" step for getting the Table names dynamically. "Location" and "Document Library" can be either static or dynamical value.
File is a dynamical value: @{items('Apply_to_each')?['{FullPath}']}

_____________________

Next you can add the "List rows present in a table" and the "For each" step will be applied automatically when using the proper configuration values.
File: @{items('Apply_to_each')?['{FullPath}']}
Table: @{item()?['name']}

From the produced output you can make the next required steps. But make sure you perform them inside the loop, to keep all the dependencies.

Was this reply helpful? Yes No
ScottShearer 25,270 Most Valuable Professional on at

Like (0)

Report

@CU24031401-0

Can you tell me if your requirement is for a one time population of Planner tasks or do you you want to do this on a recurring basis and just add new entries after the initial run?

Was this reply helpful? Yes No