Sending automated email when a new item is created using powerapps app.

(0) Share

Report

Posted on by RyanJ1

108

Hello,

I am trying to create a flow to send a new email when a new item is created in my power apps app. My data source is a SharePoint List (List1). I've used a couple templates provided, but when I test, the auto-generated email isn't sent. This is currently what I'm working with:

The only real stipulation is I need the email "To" line to allow multiple recipients.

Any assistance would be greatly appreciated.

Regards,

RyanJ1

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

Sort by

HenWang Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @RyanJ1 ,

Inside the power automate flow, there is limitation that only one trigger can exist in one single flow.

Here in your flow, there are two triggers, and this is not allowed because there would be time out issue for it. In you case, please delete the first power apps trigger and keep the second trigger to make this flow work.

Because after you create item in SP, the second trigger will fire and trigger the flow.

BR,
Hen Wang

Was this reply helpful? Yes No
RyanJ1 108 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @HenWang,
When I deleted the powerapps trigger, I now receive an error that states "Should at least contain one trigger and one action." However, I have another flow without a powerapps trigger, but I am still having issues with that one as well. When I run a test with either of my flows, no error occurs. However, I am not receiving an email in my inbox. Below is my flow without the powerapps trigger (I used a template provided):

Was this reply helpful? Yes No
HenWang Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @RyanJ1 ,

About this error, it should not show up and I guess it could be because it's a template.

You mentioned that there is no error during the flow run, and can you check the flow run history details and check the send an email action's input and output to confirm where did the email go?

Also, after checking, please try to add a semicolon between the concat expression and the AssignedtoEmail dynamic content here, not sure whether this will fix the problem, if no, just change it back

BR,
Hen Wang

Was this reply helpful? Yes No
RyanJ1 108 on at

Like
a
(0)

Report
Copy link

Link copied!
@HenWang ,

I modified the email recipient "To" portion as follows:
concat(triggerBody()?['AssignedTo0'])
However, now I receive the following error:

Body
{ "status": 400, "message": "One or more recipients are invalid.\r\nclientRequestId: d3b6655a-b9e1-41c9-8f00-377e2d6b1892\r\nserviceRequestId: b8c141d7-5852-958a-915e-610e31d47ba6", "error": { "message": "One or more recipients are invalid.", "code": "ErrorInvalidRecipients", "originalMessage": "At least one recipient is not valid., Recipient '{\"@odata.type\":\"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser\"' is not resolved. All recipients must be resolved before a message can be submitted." }, "source": "office365-usdde.azconn-usdde.p.azurewebsites.us" }

Was this reply helpful? Yes No
RyanJ1 108 on at

Like
a
(0)

Report
Copy link

Link copied!

@HenWang
I resolved the sending issue i was having earlier. However, when I try to send to multiple recipients, I noticed that my app was set to "allow multiple selections" but my SharePoint List was not. When I made that adjustment in my sharepoint list, it threw an error in my "Assigned To" (recipient) form datacard:
error: "Expected Record value. The property on this control expects Record values. The rule produces Table values which are incompatible."
Current datacard formulas are as follows:
Default: ThisItem.'Assigned to' (throwing error)
DataField: "AssignedTo0"
and the "Assigned To" combo box formulas are:
Items: Choices('G4 Task Tracker List'.'Assigned to')

Once this is resolved, will my flow work to send to multiple recipients as is?:

Was this reply helpful? Yes No
RyanJ1 108 on at

Like
a
(1)

Report
Copy link

Link copied!

@HenWang

I figured out a solution through VERY extensive trial and error.

Thanks for your help!

Was this reply helpful? Yes No