cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Jasong911
Level: Powered On

Get list items, de-duplicate "OwnerEmail" value, then email each owner?

Hi Friends,

 

I've retreived the list properties, and there are several owners who have multiple records. I want to send a single email to each owner, instead of each value.

 

Could you please help me understand how to create a string that returns "owner emails" then joins all of the duplicates?

 

I think I need to create an array, then filter on owner, then join the duplicates... but I don't entirely understand what that would/should look like.

 

any help would be much appreciated.

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support Team
Community Support Team

Re: Get list items, de-duplicate "OwnerEmail" value, then email each owner?

Hi @Jasong911 ,

First you need append the 'emails' to an arrary.

Then use the Union function to de-duplicate "OwnerEmail" value.

The expression in Compose action is:

union(variables('OwnerEmail'),variables('OwnerEmail'))

Capture18.PNGCapture19.PNGCapture20.PNG

Capture21.PNG

Best Regards,

Community Support Team _ Zhongys

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

2 REPLIES 2
Highlighted
Community Support Team
Community Support Team

Re: Get list items, de-duplicate "OwnerEmail" value, then email each owner?

Hi @Jasong911 ,

First you need append the 'emails' to an arrary.

Then use the Union function to de-duplicate "OwnerEmail" value.

The expression in Compose action is:

union(variables('OwnerEmail'),variables('OwnerEmail'))

Capture18.PNGCapture19.PNGCapture20.PNG

Capture21.PNG

Best Regards,

Community Support Team _ Zhongys

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Jasong911
Level: Powered On

Re: Get list items, de-duplicate "OwnerEmail" value, then email each owner?

Awesome!!! thank you!

>