cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ERG-IT-CW Advocate I
Advocate I

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

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.

2 REPLIES 2
Community Support
Community Support

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

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

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
ERG-IT-CW Advocate I
Advocate I

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

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.

Helpful resources

Announcements
firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Automate Community!

firstImage

Now Live: Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Community Summit North America

The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Users online (5,823)