Hi @Gelos
I tried to reproduce your request with a table in Power Apps:
ClearCollect(
colDuplicates,
Table(
{country:"India",Did:1,dname:"Admin",Bname:"Sales",amt:100},
{country:"India",Did:1,dname:"Admin",Bname:"Sales",amt:200},
{country:"US",Did:2,dname:"Admin",Bname:"IT",amt:100},
{country:"Germany",Did:2,dname:"Admin",Bname:"IT",amt:200},
{country:"Germany",Did:2,dname:"Admin",Bname:"IT",amt:100}
)
)
In this table are some duplicates and some single items but with similar values. I used a Temp Table to drop the "amt" column and only get the distinct values, afterwards I create my result table using an "addcolumns" and lookup to get the information from the source:
ClearCollect(
colTemp,
ForAll(
Distinct(
DropColumns(
colDuplicates,
"amt"
),
ThisRecord
),
ThisRecord.Result
)
);
ClearCollect(
colUnique,
AddColumns(
colTemp,
"amt",
LookUp(
colDuplicates,
Bname = colTemp[@Bname] &&
Did = colTemp[@Did] &&
country = colTemp[@country] &&
dname = colTemp[@dname],
amt
)
)
)
Maybe you could also combine this into one formula without a temp table, but this is easier to understand. My result looks like this:
Hope this helps you!
Best regards
Marvin
If you like this post, give a Thumbs up. If it solved your request, Mark it as a Solution to enable other users to find it.
