cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Dhinesh28R
Post Prodigy
Post Prodigy

Avoid Duplicates

Hi,

In my app am sending mail. In that mail i have a CC.

For Cc i did condition checking,

Concatenate(Concat(M_name.Value,ThisRecord.Value,";"),";",_emailSenderscc)

 

 for this condition am getting result like "Dinesh@test.com;Dinesh@test.com;Dinesh@test.com;"

so i need to avoid duplicates.

 

How to do remove Duplicates?

 

Thanks,

Dhinesh

 

1 ACCEPTED SOLUTION

Accepted Solutions
v-xiaochen-msft
Community Support
Community Support

Hi @Dhinesh28R ,

 

Are there duplicate emails in the Senderscc variable?

 

Please try this :

If(Concat(M_name.Value,ThisRecord.Value,";") = Senderscc, Concat(Distinct(Split(Senderscc,";"),Result),Result,";"),
Concat(Distinct(Split(Concatenate(Concat(M_name.Value,ThisRecord.Value,";"),";",Senderscc),";"),Result),Result,";")
)

 

Best Regards,
Wearsky
If my post helps, then please consider Accept it as the solution to help others. Thanks.

View solution in original post

6 REPLIES 6
v-xiaochen-msft
Community Support
Community Support

Hi @Dhinesh28R ,

 

I suggest you use the Distinct() function.

So, you could try this formula:

Concatenate(Concat(Distinct(M_name,Value),ThisRecord.Result,";"),";",_emailSenderscc)

 

Best Regards,
Wearsky
If my post helps, then please consider Accept it as the solution to help others. Thanks.

HI @v-xiaochen-msft,

Thanks for your reply man.

This time also am getting duplicates like "Dinesh@test.com;Dinesh@test.com;".

I need to avoid a duplicate.

 

Thanks,

Dhinesh

v-xiaochen-msft
Community Support
Community Support

Hi @Dhinesh28R ,

 

Could you tell me:

What's _emailSenderscc?

 

I am a little confused about your formula, is this the whole formula? 

 

Best Regards,
Wearsky

Hi @v-xiaochen-msft ,

 

If(Concat(M_name.Value,ThisRecord.Value,";") = Senderscc,Senderscc,Concatenate(Concat(M_name.Value,ThisRecord.Value,";"),";",Senderscc))

 

This is a whole formula man.

 

Here What i did means am sending mail to users with cc .. Here i need to avoid in CC. That's y am using this formula.

 

SenderCC is a Variable.

 

Thanks,

Dhinesh

 

v-xiaochen-msft
Community Support
Community Support

Hi @Dhinesh28R ,

 

Are there duplicate emails in the Senderscc variable?

 

Please try this :

If(Concat(M_name.Value,ThisRecord.Value,";") = Senderscc, Concat(Distinct(Split(Senderscc,";"),Result),Result,";"),
Concat(Distinct(Split(Concatenate(Concat(M_name.Value,ThisRecord.Value,";"),";",Senderscc),";"),Result),Result,";")
)

 

Best Regards,
Wearsky
If my post helps, then please consider Accept it as the solution to help others. Thanks.

View solution in original post

Hi @v-xiaochen-msft ,

 

There is no duplicates value in Sendercc man.

Now its working fine man. Thanks for your reply man.

 

Thanks,

Dhinesh

 

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (4,085)