cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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 blog

Power Automate Video Tutorials

View solution in original post

6 REPLIES 6
Super User III
Super User III

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

Power Automate Video Tutorials
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 blog

Power 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 blog

Power Automate Video Tutorials

View solution in original post

Helpful resources

Announcements
Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

Microsoft Ignite

Microsoft Power Platform: 2021 Release Wave 1 Plan

Power Platform release plan for the 2021 release wave 1 describes all new features releasing from April through September 2021.

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Users online (73,571)