Hi,
Problem statement:
I want an email to be sent to a shared mailbox, whenever someone is added to the "assignee" (column type: people) column in a sharepoint list.
Current Flow:
CheckAssignee: Checks whether there is a name in the "Assignee" column in the sharepoint list (in already-existing entries, because we don't assign entries at the time of creation but later)
GetItems: I read I had to add this here to get content of all columns in the sharepoint list.
Send an Email to a shared mailbox: Sends the email. I put "AssigneeEmail" in "To" because that column is a "People" one, therefore containing a name rather than an email.
ISSUE:
Doesn't work. It sends emails to people already assigned. I have mistakenly sent 100+ emails. I thought the above would only send notifications to FUTURE Assignee additions, not the already-existing ones.
And I also don't want any email notification sent if a column is changed other than the "Assignee" one.
Could someone please help me to change the flow to ensure only future changes in the "Assignee" column are taken into account and the existing ones are not bothered?
Thanks a lot
