cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Lehan
Level: Powered On

Joining arrays from excel and planner and keeping unique values

Hi,

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

1 REPLY 1
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

Announcements
thirdimage

Power Automate Community User Group Member Badge

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

firstImage

Incoming: New and improved badges!

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

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

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