Comparing old People value with New value to email new additions

(0) Share

Report

Posted on by MC-22011849-0

I have built an intake tool with various functions.

I have this contributor field, which is a column in a SP list used to hold the request data.

It is a people field allowing multiple selection.

My problem is that when a new person is added to this field, I want to send them an email to make them aware that they have been added. I’m trying to achieve that in Power Automate

I am able to get the current value of this field, but I am struggling to get the previous value and limiting it to the email value only.

Then I know to get the column data from the previous version

but I'm not sure where to go from there. I would need to get only the email value and compare it with the current value to remove all matching values. Is there a way I can do that?

Thanks!

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

NsL Coder 475 Super User 2025 Season 2 on at

Like (0)

Report

I don't know if there is a better option, but you can use apply to each (new) email, filter array on (old) emails = (new) email. if length(filter array body) = 0, then (new) email is appended to another array or string variable. after the apply to each, you can then use this variable to send email.

Was this reply helpful? Yes No
Chriddle 8,436 Super User 2025 Season 2 on at

Like (0)

Report
Get all versions (or the latest 2 versions)

Filter the Person column of the latest version for items that are not in this column in the version before.

Filter array

My Persons column is called 'Contacts'

From:

first(body('Send_an_HTTP_request_to_SharePoint')['d/results'])['Contacts']['results']

Filter:

coalesce( body('Send_an_HTTP_request_to_SharePoint')?['d/results']?[1]?['Contacts']?['results'], json('[]') )

does not contain

item()

Was this reply helpful? Yes No