I am creating planner tasks from an excel spreadsheet so that i can book in certain events. This part is working well enough, except that it will duplicate each line of the list if i leave it running and will also continue to spam the test inbox i have set up for the mail i am also sending when the planner task is raised.
Is there a simple way to avoid duplication when making a flow to create planner tasks?
Please post a screen shot of your Flow. That will be a big help to those who would like to assist.
This is something i picked up from a tutorial but i can't get it to work. In the video the idea is that you filter out the value of the title if it matches what you are trying to add but i don't get how to do this as the title is not simply a combination of excel cells but also text and a date that is converted from excel
OK - I'll need just a little more information:
Thanks for the advice on future posts, i will make sure to do this. As for now the info you have asked for is below.
https://www.youtube.com/watch?v=kQMTcNCyPps
Test1 expression is: length(outputs('List_tasks')?['body/value'])
User | Count |
---|---|
101 | |
36 | |
29 | |
25 | |
16 |
User | Count |
---|---|
133 | |
54 | |
53 | |
37 | |
26 |