question

user7878-0682 avatar image
0 Votes"
user7878-0682 asked user7878-0682 commented

Sharepoint: Compare two different lists with the same value

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?

office-sharepoint-online
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

EmilyDu-MSFT avatar image
0 Votes"
EmilyDu-MSFT answered user7878-0682 commented

@user7878-0682

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.png (7.1 KiB)
2.png (8.3 KiB)
3.png (37.6 KiB)
4.png (35.4 KiB)
5.png (4.8 KiB)
· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@user7878-0682

I’m checking how the things are going on about this issue. Whether the answer helps you?

If there is any problem with this issue, feel free to let me know.

0 Votes 0 ·

@user7878-0682

I am looking forward to your feedback if there is any update.

Please remember to update this thread if you have any progress.

Thank you for your understanding.

0 Votes 0 ·

Thank you, I was able to re-create the flow from your suggestion and that fits my need.

0 Votes 0 ·