Forum Discussion
Sharepoint list power automate. Send email to form creator with column data.
Christoffer160 In "Send an Email" action, under "To" field, you can select the people column from SharePoint using dynamic content.
For example:
- Click on "Add dynamic content":
- Then you will be able to select column names from SharePoint like:
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
Thank you for your response!
How do I connect the email trigger to send the mail to who is listed in a specific column? This can be different people.
Christoffer160 In "Send an Email" action, under "To" field, you can select the people column from SharePoint using dynamic content.
For example:
- Click on "Add dynamic content":
- Then you will be able to select column names from SharePoint like:
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
- Thank you! I didn´t see that before.
Now I have another issue, I suspect that its connected to our organization and rights but I might as well put it up here too, if you have any ideas.
The Form is available to anyone in the organization and the List is only available to the ones in the group, as intended. So the List gathers datainput from the Form.
The issue is: The flow that is setup works only when I use Names of people that is group members to this List. If I choose some other person from the organization that´s outside of the list owners group, the flow fails.
It says: "status": 400,
"message": "The specified user Mouse, Mickey could not be found.\r\nclientRequestId: 33f64db4-1a01-4efd-93dc-98f670201a1b\r\nserviceRequestId: 33f64db4-1a01-4efd-93dc-98f670201a1b"}
However, if I use the same person and directly edit the list item and not using the form, it will find the user, which I find odd. If it was a rights issue, I figure I wouldnt be able to find it at all.