cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
saad101
Regular Visitor

FLOW TO CREATE TASKS INSIDE MICROSOFT TEAMS PLANNER FROM SHAREPOINT

Hello Everyone, i am getting started to learn how share point, Microsoft flow and MS teams can work together. 

- I have a task to do where i have an excel workbook which is located in sharepoint site. i want to be able to create tasks inside Microsoft Teams (MST) EVERY TIME A NEW ROW IS ADDED to that excel file. I managed to create one flow which reads all the excel rows and creates a task in MST. which looks like this:Capture.PNGCapture2.PNG

 

 

Now the next step is to create tasks for only those items which are newly added. this is where i need help in creating an automated flow which will read the new item added and also create task for that item in MST.

 

 

Thanks in advance

 

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: FLOW TO CREATE TASKS INSIDE MICROSOFT TEAMS PLANNER FROM SHAREPOINT

Hi @saad101 

 

Thanks for your reply. Looks like you having error for creating task. I can see there are two date fields you are mapping. Remove both from the mapping and test again. If that works that means the date mappings are in wrong format. You may try this expression

 

formatDateTime('here map your field', 'yyyy-MM-dd')

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog

View solution in original post

6 REPLIES 6
Super User
Super User

Re: FLOW TO CREATE TASKS INSIDE MICROSOFT TEAMS PLANNER FROM SHAREPOINT

Hi @saad101 

 

Thanks for the post and screenshot. 

 

You are nearly there to achieve your requirement. Add a new column in your excel table called 'TaskCreated'. Set default value as No. In your List Row filter the rows against the new column (TaskCreated) value 'No'. Once you create the task update the excel sheet row to 'Yes'.



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
saad101
Regular Visitor

Re: FLOW TO CREATE TASKS INSIDE MICROSOFT TEAMS PLANNER FROM SHAREPOINT

Thank you for your suggestion but it doesn't work. when the flow ran it recreated all the tasks that were previously created

Super User
Super User

Re: FLOW TO CREATE TASKS INSIDE MICROSOFT TEAMS PLANNER FROM SHAREPOINT

Hi @saad101 

 

Could you post your screenshot of your flow?

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Super User
Super User

Re: FLOW TO CREATE TASKS INSIDE MICROSOFT TEAMS PLANNER FROM SHAREPOINT

Hi @saad101 , 

As suggested by @abm this should work. here is a sample for your reference 

 

PA1.png

saad101
Regular Visitor

Re: FLOW TO CREATE TASKS INSIDE MICROSOFT TEAMS PLANNER FROM SHAREPOINT

Thanks for sharing this. here is the erros code i am getting: Capture.PNG

and here are the screen shots of my Flow:

 

Capture2.PNGCapture3.PNGCapture4.PNGCapture5.PNG

 

 

Please Guide

 

Thanks

Super User
Super User

Re: FLOW TO CREATE TASKS INSIDE MICROSOFT TEAMS PLANNER FROM SHAREPOINT

Hi @saad101 

 

Thanks for your reply. Looks like you having error for creating task. I can see there are two date fields you are mapping. Remove both from the mapping and test again. If that works that means the date mappings are in wrong format. You may try this expression

 

formatDateTime('here map your field', 'yyyy-MM-dd')

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog

View solution in original post

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 (7,743)