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

Nicole Holt

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?

1st half of flow

2nd half of flow

Ben Regier

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

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

Nicole Holt

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

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

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