Answered

Prevent Selection of duplicate records in gallery

(0) Share

Report

Posted on by jjbring

I have a SharePoint List that I'm trying to take all comma-delimited string data from a field and put into a collection so I can try to find if I have any duplicates based on a certain combination.

SharePoint List:

Type	Status
Type 1,Type2,Type3	New
Type2,Type3	Final
Type 4	Final

I'd like to load all Types that have a Status of "Final" into a collection. Then in the app when a status is changed on a record to "Final" I want to pull all Types that have a Status of "Final" into the same collection. Then I need to check for duplicates in the collection to prevent saving back to SharePoint if there are any duplicate Types for the status of Final. For example if I change the first record above to Final the app should have duplicate Type2 and Type3 values in the collection and I shouldn't be able to save until the Type or Status column is changed so the Types are no longer duplicated for the Status of Final.

I tried a ForAll loop with a Split and that just splits the string into a table but I have 2 records in the collection with a table as the column. I'm not sure how I could split the string into 1 collection with rows for each value instead of putting them into tables within the collection. What I'm expecting to see on Start of the app is a collection with the following:

colFinalTypes

Type2

Type3

Type4

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Michael E. Gernaey 53,452 Super User 2025 Season 2 on at

Like (0)

Report
Hello,

One way to do it (and its just one way, there are many)

1. have a collection that you add everything (just add them all dups too)
2. have a secondary collection that you run this code
ClearCollect(myNewDistinctCollection, ForAll(Distinct(collectionWithDuplicates, ThisRecord), Value));

Now you use the myNewDistinctCollection wherever it is you wanted.

Was this reply helpful? Yes No
Michael E. Gernaey 53,452 Super User 2025 Season 2 on at

Like (0)

Report
Also you don't need to use a For All to split them. I would do a forall around the fact that you have many rows in SP, but I would just use

ClearCollect (collectionWithDuplicates,Split (myCommaSeparatedString,",")); or Collect(collectionWithDuplicates,Split (myCommaSeparatedString,","));

hope that helps

Was this reply helpful? Yes No
Verified answer

jjbring 9 on at

Like (0)

Report

Thanks for the reply. I ended up going in a different direction, but I was able to resolve this. In the OnChange event of my combobox I variables for each type (since there are only 5) to a count of the times they are used then I can check those variables count to show/hide the save button and also throw "notify" message for the user to know which type has more than one selected.

Example code for a couple types onChange property of the Combobox and dropdown fields:
Set(varType1RowCount,CountRows(Filter(Gallery1.AllItems,dd_Status.Selected.Value = "Final" && "Type 1" in cb_Type.SelectedItems)));
Set(varType2RowCount,CountRows(Filter(Gallery1.AllItems,dd_Status.Selected.Value = "Final" && "Type 2" in cb_Type.SelectedItems)));

Was this reply helpful? Yes No
Michael E. Gernaey 53,452 Super User 2025 Season 2 on at

Like (0)

Report

As the saying goes 🙂 whatever works.
But I would suggest changing to contect variables rather than global variables

Just a suggestion so its becomes a pattern.

Cheers

Was this reply helpful? Yes No