Sharepoint: Compare two different lists with the same value

user7878 61 Reputation points
2021-09-17T01:19:48.97+00:00

I'm using sharepoint, power automate, to compare two different lists together. One is FullName in one folder and another is WorkerName in another folder. I want to get the lists from these two folders and compare those two fields. Is this possible?

SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
10,052 questions
0 comments No comments
{count} votes

Accepted answer
  1. Emily Du-MSFT 43,181 Reputation points Microsoft Vendor
    2021-09-17T09:18:57.397+00:00

    @user7878

    Here're steps:

    1.Create FullName list, then create FullName folder with some items in it.
    133079-1.png
    2.Create WorkerName list, then create WorkerName folder with some items in it.
    133084-2.png
    3.Create the flow as following pictures show. If Title of items in the FullName list is equal to Title of items in the WorkerName list, the flow will create duplicate items in the another list (Result list).
    133085-3.png
    133121-4.png
    133122-5.png


    If an Answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful