web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Removing Opposite Sign...

Power Apps

Answered

Removing Opposite Sign ( positive and negative ) duplicates from a Collection

(0) Share

Report

Report

Posted on by omkarb26011

47

Hi All,

I have a usecase where I am getting the Excel data into a Powerapps collection

Now I want to remove records which have opposite Sign Amounts (Number) for same email ID

Thanks

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

v-yujincui-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @omkarb26011 ,

I have made a test for your reference.
1. Here is my collection(col_email)
2. Add a Button Control and apply the following formula on its OnSelect property as:
Collect(t1,Filter(col_email,"-" in Text(C2)).C2);Collect(t1,Substitute(Filter(col_email,"-" in Text(C2)).C2,"-",""))
3. Add a Button Control Control and apply the following formula on its OnSelect property as:
RemoveIf(col_email,C2 in Trim(t1.C2));

Best Regards,
Charlie Choi
omkarb26011 47 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-yujincui-msft
This Does work but it also removes the other records with same Eid

Join the conversation