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

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 blogPower Automate Video Tutorials

View solution in original post

6 REPLIES 6
abm
Super User
Super User

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 blogPower Automate Video Tutorials
saad101
Regular Visitor

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

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 blogPower Automate Video Tutorials

Hi @saad101 , 

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

 

PA1.png

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

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 blogPower Automate Video Tutorials

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Users online (2,696)