Upon updating Excel file in Sharepoint, update/add tasks in Planner per row?

[ERG-IT-CW]

Hi,

I am looking to create a Flow which does the following:

1. An asset list (on an Excel Spreadsheet with an ODBC link to our SQL database) is reuploaded/updated to a Sharepoint. (NOTE: This was done as a ringfence/sense of security was requested)
2. Once this happens each row in the spreadsheet is added as a task in Planner.
3. If a task already exists for that row, the task is updated with new details.

Is this possible? Are there better ways in which I can use Planner to update the status of an asset (Working, In Repair, etc.)?

Thanks in advance.

[v-bacao-msft]

Hi @ERG-IT-CW,

Could you provide more explanation about your needs?

From the information you provided, I probably sorted it into:

1. When the Excel file is updated, you need to update the corresponding Excel file on SharePoint library. This needs to consider which behavior is used as a trigger of the flow, update the Excel file or update the SharePoint library document. "When an item is created or modified" is available
2. Use the information in the excel file as the fill content of Create a task action. Here you need to determine what to use as the task title. This is important for judging whether the task exists. I don't know what the specific details of your Excel are. Because the current Create a task action can be configured with limited content. Could you provide more details about it?
3. The third step you could use the list tasks action to list all the tasks, then check if it already exists, the existing ones will be updated, and if they do not exist, a new task will be created.

It would be helpful if you could post more details and we would provide a proper workaround for you.

Best Regards,

Barry

[ERG-IT-CW]

Hi @v-bacao-msft,

Thank you for responding.

Basically, our needs are we have an asset list as a spreadsheet that will be updated with 3 statuses:

Functioning

In Repair

To Be Replaced

This spreadsheet is saved in a Sharepoint. Whenever this spreadsheet is updated it must reflect in Planner.

It also needs to work the opposite way - someone moves a task in Planner form Functioning to In Repair, it must reflect in the spreadsheet too.

The spreadsheet is only here as a ringfence to our SQL database (as the offline/non-Sharepoint Excel file as a link to an Assets table)

I know my other option would be to just have a direct link to our SQL Server which updates the Asset table's status (Functioning/In Repair/To Be Replaced), so I guess we just need confidence in the security of Flow working with our on-premises SQL database.