Create List from Duplicates

(0) Share

Report

Posted on by 4wordsback

Hello,

I am trying to identify duplicates between 2 different lists and generate i drop list populated by these duplicates.

Example

I have Sharepoint List A that has in one column : RED, BLUE, GREEN, ORANGE, YELLOW, PURPLE,

In Sharepoint List B, i have a column with: GREEN, ORANGE, BLACK, WHITE

I want the dropdown to show only the items that are dupicated between the 2 lists (GREEN, ORANGE).

Any Ideas how i can accomplish this?

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

Sort by

CNT 10,921 Super User 2024 Season 1 on at

Like
a
(2)

Report
Copy link

Link copied!
@4wordsback An example, Place this in the onSelect of a Button,
ClearCollect(colColour1,{colour:"Red"},{colour:"Blue"},{colour:"Green"},{colour:"White"}); ClearCollect(colColour2,{colour:"Red"},{colour:"Green"}); Clear(colMatch); ForAll(colColour1, If(colour in colColour2.colour,Collect(colMatch,{matchFound:colour})))
The results in colMatch will be,

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(2)

Report
Copy link

Link copied!
@4wordsback

Consider the following formula:

With({ItemsA: ["RED", "BLUE", "GREEN", "ORANGE", "YELLOW", "PURPLE"], ItemsB: ["GREEN", "ORANGE", "BLACK", "WHITE"] }, Filter(ItemsA, Value in ItemsB.Value) )

This will produce a Table with Two Value - ORANGE and GREEN

I hope this is helpful for you.

Was this reply helpful? Yes No
Bilakanti 1,226 on at

Like
a
(1)

Report
Copy link

Link copied!

@4wordsback
You can iterate through each list and compare each row from List A in rows of List B. If equals then store in in another collection. Below is the screenshot for your reference.,

Was this reply helpful? Yes No
4wordsback 46 on at

Like
a
(0)

Report
Copy link

Link copied!

That did it! Thanks CNT!

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@4wordsback Go simple! Your app design proficiency will increase tremendously!

Was this reply helpful? Yes No
CNT 10,921 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@4wordsback Please remember to give a 👍 and accept the solution as it will help others in the future.

Was this reply helpful? Yes No