Showing results for 
Search instead for 
Did you mean: 
Level: Powered On

Joining arrays from excel and planner and keeping unique values


Im new to using flow and Im currently stuck on trying to create a flow.


I want a task to be created  whenever a row has been added to a table in my live excel worksheet.

I have got so far as to create the tasks on planner but every time my flow runs the tasks get duplicated again.


Thus, I believe it is required to join the array of tasks from planner and the array of rows from excel and filter out the duplicates and then create only the tasks that have not been added to planner.

Would this solution be possible? If not what would be a workaround to achieve the same results?

Thanks in advance.

Images below for reference of what I have done thus far.Capture.JPGCapture1.JPG

Community Support Team
Community Support Team

Re: Joining arrays from excel and planner and keeping unique values

Hi @Lehan,


Please input the @item()?['OrderID'] into the Title field:

Annotation 2019-11-25 102848.png


You can also use the syntax @item()?['value'] to extract other value of the excel, then append them into other fields of Create a task action.


Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources


Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!


Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!


Microsoft Learn

Learn how to build the business apps that you need.


Power Platform World Tour

Find out where you can attend!


Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors (Last 30 Days)
Users online (5,237)