Power Automate: Compare two lists and find what's missing
Aug 18, 2023 2:00 PM

Power Automate: Compare two lists and find what's missing

External YouTube Channel

In this video, you'll see how to use the power of Power Automate to compare two lists and find what's missing. This can be incredibly useful when you're wanting

In a video tutorial, the use of Power Automate to compare two lists is explained in order to find missing items. This tool is very beneficial when it comes to reminding people to add an item to a list within a specified time frame. The comparison employs arrays, with a demonstration of how to filter SharePoint list results. Moreover, the steps to obtain data from a list, compare it with another list, and see who hasn't included an item in the list are clearly outlined.

  • Introduction to Power Automate
  • Setting up the Backend list
  • Configuring the Trigger
  • Filtering the list
  • Gathering data for comparison
  • Getting Direct Reports
  • Pulling the users from your list
  • Using arrays to compare the lists
  • Sending reminders

More on Power Automate

Power Automate, previously known as Microsoft Flow, is an online workflow service that automates tasks across multiple applications and services. The tool helps businesses create workflows to automate repetitive processes, enabling them to focus on more strategic tasks. Power Automate can connect to various Microsoft and non-Microsoft services, such as SharePoint, Twitter, and more. With an easy-to-use interface, it can streamline administrative tasks, improve productivity, and enhance operational efficiency.

Learn about Power Automate: Compare two lists and find what's missing

Power Automate is a powerful tool that can be used to compare two lists and find what's missing. This can be especially useful for sending reminders to people if they forget to add an item to a list in a certain period of time. This comparison is made possible by using arrays. In this video, you will learn how to do date time magic to filter SharePoint list results, get the people from that list and compare it with another list of people to see who doesn't have an item in the list. You will also learn how to configure the trigger, get the data to compare, get direct reports, get users from your list, compare the lists (arrays), and send the notification. It is important to also learn more about variables in order to use Power Automate effectively.

 

More links on about Power Automate: Compare two lists and find what's missing

Compare 2 Sharepoint Lists and add missing Person
Feb 2, 2021 — Solved: I have two Sharepoint Lists, each with a Person column (an O365 user). I need to compare the two lists, and if a Person is missing from List.
List values missing in an array using Power Automate
Nov 6, 2022 — There's currently no expression in Power Automate to compare two arrays and find the missing values in the smaller array, but there's again ...
Compare Two Lists and Return Missing Items
Dec 7, 2022 — Compare Two Lists and Return Missing Items ... The second table is a list of what has been purchased and has 3 columns: ... Get Fabricated!!
Compare two arrays, tables or lists a lot faster in Power ...
Jan 27, 2022 — When you want to compare two arrays, lists or tables in Power Automate and you might end up with a very slow flow. In this post the speedy ...
Comparing 2 Sharepoint lists using Power Automate
Dec 8, 2020 — Using MS FLow/Power Automate, you can compare values in two list and update then add/update the 3rd list.
How to compare data in two Google sheets or columns
May 5, 2023 — Learn different ways of comparing data in two Google sheets or columns and identifying duplicate and unique records.
Compare Two Lists in Excel for Differences and Matches
May 3, 2019 — The formula counts the number of occurrances of each name in column A (notice the missing dollar before the row number in the $A2 reference).

Keywords

Power Automate, Variables, Date Time, SharePoint List, Compare Lists, Array Comparison