Sharepoint: Compare two different lists with the same value

Question

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?

Answer 1

@user7878

Here're steps:

1.Create FullName list, then create FullName folder with some items in it.

2.Create WorkerName list, then create WorkerName folder with some items in it.

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).

---

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.