Forum Discussion
ross_cartledge
Sep 29, 2023Copper Contributor
Power Automate - Send an Email Workflow
Hi.
I'm brand new to Power Automate Workflows and what i currently know is self taught from Google/YouTube however i have an issue that seems simple yet i can't find a solution
I have Sharepoint list which holds a lot of approx. 40 lines of data
Columns are a mixture if single line text, Choice, Person or Group and so on.
My requirement is for an email to be sent if either a new item has been created or an existing one has been updated.
To Do this
Trigger: When an item is created or modified
Action: Send an email (v2)
- To: Multiple Dynamic Fields, taken from a person or group field
- Subject: Nothing special but dynamic fields
- Body: Again, nothing special but dynamic fields
- From (Send as): A Shared/Group mailbox that i have access to send emails from
- cc: 2 specific email addresses
My problem is that it's hit or miss if the workflow runs or not (mostly not) and i can't work out why.
The only thing i can possibly think of is the dynamic fields that hold the email address, aren't mandatory fields and as such don't always have something in there. but other than i just about given up
Hoping i've put enough information on here so that somebody can help
3 Replies
Sort By
- msuser1815Copper ContributorIt sounds like what you are trying to accomplish is the same as List Alerts, more info here: https://support.microsoft.com/en-au/office/turn-notifications-on-for-list-and-list-item-changes-85ca9280-f4b1-485a-a49e-a593ffa62e39
- ross_cartledgeCopper ContributorThanks for the reply.
So Alerts defiantly look like a simpler solution, HOWEVER, one of my key requirements is the the notification/email that gets sent, will get the 'To' field from the sharepoint list item that has been updated, and will be different for every item.
Looking at the links you provided, it appears that i can only send an alert to a pre-defined set of people
- ross_cartledgeCopper ContributorI forgot to add. The error message i get is as below
The execution of template action 'Apply_to_each' failed: the result of the evaluation of 'foreach' expression '@{triggerOutputs()?['body/DW_x0020_Resources']};@{triggerOutputs()?['body/DW_x0020_Engagement_x0020_LEad/Email']}; @{triggerOutputs()?['body/Sales_x0020_Lead/Email']}; ' is of type 'String'. The result must be a valid array.