FLOW TO CREATE TASKS INSIDE MICROSOFT TEAMS PLANNER FROM SHAREPOINT

[saad101]

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:

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

[abm]

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'.

[saad101]

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

[abm]

Hi @saad101 

Could you post your screenshot of your flow?

Thanks

[DeepakS]

Hi @saad101 , 

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

[saad101]

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

and here are the screen shots of my Flow:

Please Guide

Thanks

[abm · Accepted solution]

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