Hi @Kmayes your expression seems strange in a way that you are in your collection you are adding both the items from the source into the collection, as well as the items from the collection itself. So in some items in the ForAll loop you will be adding back to the collections items that have already been collected. That doesn't sound right, and will cause duplicates:
Clear(collection);
ForAll(
["value1", "value2", "value3", "value4", "value5"],
Collect(
collection,
Filter(SOURCE, 'COLUMN NAME' = Value),
Filter(
SortByColumns(
collection, // Do you want to add the items from 'collection' into 'collection'?
"ID",
SortOrder.Descending),
ID > 0
)
)
);
If you only want to add items to the collection from SOURCE that have the column name equal to the value from ForAll and the ID greater than 0, then you can use something like the expression below:
Clear(collection);
ForAll(
["value1", "value2", "value3", "value4", "value5"],
Collect(
collection,
Filter(
SOURCE,
And(
'COLUMN NAME' = Value,
ID > 0
)
)
)
);
Hope this helps!
