How to Compare Two Lists in Power Automate Without Apply to Each #PowerAutomate #efficiency

preview_player
Показать описание
In this tutorial, I'll guide you through a detailed demonstration of how to efficiently compare two SharePoint lists - a master list and a regional sales-based list. Learn how to identify and add any missing items from the regional sales list to the master list, comparing the two arrays without using the "Apply to each" action.

Intro (00:00): Begin your journey with an overview of what's to come.

The Lists to Compare (00:35): Understand the two SharePoint lists we'll be comparing and their importance.

Building the Flow (02:07): Learn how to build an efficient flow to handle the comparison and addition of missing items.

Primary ID Array via Select (03:02): Explore the creation of a Primary ID Array using the 'Select' function, an essential part of our flow.

Validating the Flow Output History (05:28): Dive into validating the flow output history, ensuring your flow is running as expected.

Creating Items (06:32): Discover the process of creating items in the master list from the regional sales list

New Designer Dynamic Value Bug? (07:37): Discuss a potential bug in the new designer dynamic value.

Validating Item 6 has been created (09:10): Verify the successful creation of a new item in the master list.

Running the Flow on some more items (09:37): Watch the flow in action on several more items, demonstrating its efficiency and scalability.

Outro (10:45): Wrap up the session with key takeaways and a look into what's next.

This tutorial is perfect for anyone dealing with large datasets, ensuring efficiency and preventing throttling or hitting API limits. Make sure to connect with me and subscribe to stay updated with more such useful tutorials!

Рекомендации по теме
Комментарии
Автор

Thanks for this! The apply to each control has become somewhat of a mortal enemy of mine ❌😂

extraktAI
Автор

Works great and really efficiently, but I would like to add that if your ID fields are values it doesn't want to give results in the filter, the workaround I used is just concatenating "ID" at the beginning of the value to have matching strings.

SpencerVinson-vz
Автор

THANK YOU! I have been working on this for 2 days and FINALLY have a reliable and efficient solution to update my excel tables.

aaragon
Автор

I have a flow that needed to look at a data source with ~4000 rows and compare it to another data source to see what had been added/removed. Worked OK using an apply to each but took about 40 minutes to run and had started to be unreliable (often failed). Your previous blog on this subject made me redesign the flow and it now takes 60 seconds and just doesn’t fail!! I think every flow I have with a select action has been influenced by a video from you, how you use that action never fails to amaze me!! Awesome work!

robofski
Автор

Your videos always help me take my flows to the next level. This is a great technique that I never would have thought of. Thanks for sharing!

morris
Автор

Another useful tutorial. You've got me not using "Apply to each" when I can do an expression. I recently do a flow to get all users from a SharePoint group, and at the end I did a Select for just the email and followed it by a Join with a semicolon--No Appy to each. You're a great teacher.

StephanOnisick
Автор

Great video. Your communication/teaching style is clear and easy to understand.

brettwoodward
Автор

Thank you very much for this video. Here you are using one condition to compare two list, if we need compare with 4 fields then what we meed to do with out apply to each action.

radhakishansharma
Автор

Awesome work, Damien. was very useful for my work today

shivabkumar
Автор

Will make flows so much more efficient and faster… thanks!

friendlyfriesen
Автор

Great video! Thank you! I work as an auditor and I send invoice confirmation requests by e-mail with an option for each item from a SharePoint list (Get Item). When the response is back, a new item is created on a separate result list. Some requests remain unresponded and now I know how they can be filtered using your method.

filipwinski
Автор

one of the biggest headache, thanks for your updated video :)

AlysonVeras
Автор

You are a genius. I thoroughly enjoy your videos. Thank you very much for your hard work.

adhuma
Автор

I really like how you explain things. I tried to use this to compare two lists as described but the final step I need is then to be able to delete a duplicate entry on one of the lists. So look at list 1, compare with list 2, if an item on list 1 appears on list 2, delete from list 2. Any help gratefully received.

accreditationquality
Автор

Dynamite! Thanks for another fantastic video. I´ll definitely apply this concept.

stefankirst
Автор

Thank you for the video, works great. Any chance you'd do one on comparing 2 lists on multi person fields?

davidclay
Автор

Thank you for this video. It definitely is way more efficient! Is there a way to look up 2 fields? Using your data if you want to look up Product Sold and Sales Person name and compare both fields in each list?

MarcusCrutchfield
Автор

Excellent as usual. Here you compare one field with that same field in another list. It would be quite interesting if you compare multiple fields, or even an entire record. Ever done that? I'm not directly seeing how I can specify multiple fields in the right side of the Filter array.

michelhegeraat
Автор

This is the video I was looking for comparing, however, I have two Dataverse tables in my situation instead of SharePoint but I am getting all the rows back from 2nd table including the matching ones. Any tips?

Salstravels
Автор

--- this is a great idea but my filter array output is still blank - I'm using this to find matching data across two Excel sheets and even though the input shows there's a match the filter array output is still embedded in a JSON as a blank array


{
"body": []
}

RiskManagement-exnl