Power Automate flow to create Planner items from NXT actions results in duplicates

Options
Nicole Holt
Nicole Holt
Tenth Anniversary Kudos 3 Name Dropper Participant
in SKY Developer General Discussions

Hi all, hoping for some insight: we have a Power Automate flow designed to create items in MS Planner based on actions saved in NXT (with the hope that this will help with project management for our grants process). The flow works, but it seems to be cycling through the action list twice, as we were getting duplicate entries in Planner.

I tried to correct for the loop by adding a custom field to NXT records that only allows 1 per record before the Planner item is added, but now Power Automate is listing the flow as “failed,” even though it is adding that one Planner item. Are there any tips on how to halt this duplication problem?

29f5a7eaa206fbeafd6d4d5f405458d3-huge-im
1st half of flow


6fa6663249ce7e47328380ab33473ed6-huge-im
2nd half of flow

Tagged:

Comments

  • Ben Regier
    Ben Regier
    Sixth Anniversary Kudos 3 Name Dropper Participant

    It looks like you have a loop within a loop going on, which would probably explain the duplicates. I can't see your screenshots well enough to make an suggestions on how to avoid that, though - is it possible to upload higher quality images?

  • Nicole Holt
    Nicole Holt
    Tenth Anniversary Kudos 3 Name Dropper Participant

    Thanks for looking at this, @Ben Regier ! Below are hopefully better images of the flow for the first set of conditions (this repeats for different months, as the team that requested this prefers to work with monthly planner boards).

    57dee7734632d0f1f534c7560c75d72e-origina

    b7fc34d5e1911d97ce9def385ec3261e-origina
    441af39ca81b7d45fc8715d3583e21a9-origina

    a337ec906ff0eda31d45073af584ec31-origina

    7f92b4d74aecea3d837667b751e814fd-origina
  • Nicole Holt
    Nicole Holt
    Tenth Anniversary Kudos 3 Name Dropper Participant

    This is so funny. I took all the screenshots, went to make coffee and though about your message, and now it seems like I get it ?. I think I know how to fix it--by combining the conditions? I'm going to give it a try after lunch. Thanks so much

  • Ben Regier
    Ben Regier
    Sixth Anniversary Kudos 3 Name Dropper Participant

    Yes, sounds like you're on the right track! Combining your conditions or using a Filter Array action instead of a condition should help.

    Let us know how it goes.

  • Nicole Holt
    Nicole Holt
    Tenth Anniversary Kudos 3 Name Dropper Participant

    Yes! It worked. Thanks for helping me think through this!

Categories