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
Solved! Go to 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
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogHi @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'.
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogThank 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
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogThanks for sharing this. here is the erros code i am getting:
and here are the screen shots of my Flow:
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
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogThe first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Announcing a new way to share your feedback with the Power Automate Team.
User | Count |
---|---|
79 | |
22 | |
17 | |
14 | |
13 |
User | Count |
---|---|
133 | |
33 | |
31 | |
31 | |
24 |