SharePoint Asked by DGoetz on December 2, 2021
I have a custom list that I need to create a Power Automate trigger to send an email alert similar the the "Alert me" option.
I want the alert to be sent to the assigned part whenever a new item is created or an existing item is modified. I have that part figured out but it is the alert that I am having trouble with. I can get an email to send a custom notification email but what I want it to send is below. Any ideas?
EDIT: Going to go about this a different way. Here is what I am thinking…
When a item is created or modified I receive an alert in my inbox. This is the OOTB alert, which is really nice because it provides great detail and identities changes of an item.
What I want to happen now is that alert be forwarded to the “assigned to” email address from the item. Like this…
Email received as SP alert > data pulled from the list / item (I imagine this will be done external of the actual email but via the list / item itself) > email forwarded to the “assigned to” email address
Seems pretty straight forward when I write it out but I can’t seem to find a way to pull the data needed from the list and apply that to an email already received then forward accordingly…
Second answer for the changed scenario:
to do this with a Flow, you can set up a rule to put the messages into a specific folder. Then use the email trigger "When an email arrives" and point it to that folder.
You cannot use the "Get Item" property to get the item, because the email alert does not give you the item ID, just the title. Since the title may not be unique, that might be a problem.
So, if (and only if) the email contains a field that is a unique identifier for the item, you can parse the email body text to extract the unique value. Then you can use the "Get items" (plural) action and use a oData filter in the Advanced settings to return only the desired item. From there, you can get its ID, then load the item with "Get Item" (singular) and you have all the item properties.
From the properties, get the person to send the email to and copy the trigger email body into the notification.
I have not tested this, but this is the logic of the flow. If the email does not contain anything that uniquely identifies the item, this approach will not work.
Answered by teylyn on December 2, 2021
The "Alert me" functionality has been in SharePoint for several versions, at least since WSS, i.e. 2003. This legacy functionality does not have an action in modern PowerAutomate.
You say you know how to send the email. That's the action you need. Just put all the field titles and their values into the email body.
Edit: to send to the assigned contact, just use that field in the To field of the email.
Answered by teylyn on December 2, 2021
2 Asked on January 6, 2022
1 Asked on January 6, 2022
1 Asked on January 6, 2022 by jes516
1 Asked on January 6, 2022 by ah-jamali
1 Asked on January 4, 2022
3 Asked on January 4, 2022 by default_noob_network
1 Asked on January 4, 2022 by j-choe
1 Asked on January 2, 2022
2 Asked on January 2, 2022 by rothrock
1 Asked on January 2, 2022 by drvr
1 Asked on January 2, 2022 by scott-davis
3 Asked on January 2, 2022 by lieptas
column formatting date time json formatting modern experience sharepoint online
0 Asked on January 2, 2022
1 Asked on December 31, 2021
development office 365 sandbox solution sharepoint online site logo
1 Asked on December 31, 2021 by okmqaz135
2 Asked on December 31, 2021 by kandace
2 Asked on December 31, 2021 by namwar-rizvi
microsoft teams modern team site pnp powershell rest sharepoint online
3 Asked on December 31, 2021
1 Asked on December 31, 2021 by ahmed-alsharkawy
1 Asked on December 31, 2021 by zombeezsp
calculated column calculated column formula date time modern experience sharepoint online
Get help from others!
© 2023 AnswerBun.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP