Send email confirming item created in SharePoint not working

[sudosaurus]

Hello,

I have built a flow where when an email is sent to a Shared Mailbox, the email is logged as an item in SharePoint.

The flow captures the following from the email:

From / Sender: SharePoint created by Field / Requester Field

Subject: Title Field in SharePOint
Body: Description Field in SharePoint

Once the item is created, my flow should also be sending an email from the same shared mailbox back to the user confirming receipt of their email - during testing, as per the below configuration, I am not receiving confirmation email.

[efialttes]

Hi

Did you already inspect Flow Execution to doublecheck if it attempted to send the email or failed in a previous step?

Also, which value are you using to fill 'To' on your notification email? 'Assigned to E...' column is not displayed and does not seem to be filled in when you Create your item. Does it provide a valid email address?

The problem I guess is that you have set a value for 'Selected fields' in your second request, with has probably an incorrect format.

Actually the only valid format is explained here:

Comma separated list of fields to select. Example: surname, department, jobTitle

...and you are inserting your own email address as input, which is invalid

According to Official Microsoft documentation, 'Get my profile' as is provides the following output, no need to fill 'Selected fields'.  So, you should get whatever value you need in your first request, and do not need to add a second request.

HTTP/1.1 200 OK
Content-type: application/json
Content-length: 491

{
  "businessPhones": [
       "businessPhones-value"
   ],
   "displayName": "displayName-value",
   "givenName": "givenName-value",
   "jobTitle": "jobTitle-value",
   "mail": "mail-value",
   "mobilePhone": "mobilePhone-value",
   "officeLocation": "officeLocation-value",
   "preferredLanguage": "preferredLanguage-value",
   "surname": "surname-value",
   "userPrincipalName": "userPrincipalName-value",
   "id": "id-value"
}

Hope this helps

[sudosaurus]

This fails on the second "Get My Profile V2".

BadRequest.

Outputs:

{

"error": {

"code": "BadRequest",

"message": "Parsing Select and Expand failed.",

"innerError": {

"request-id": "5f6f6f5f-5d1b-4f1a-9b2d-a6fe4f38743e",

"date": "2020-02-13T12:56:12"

}

}

}

Headers:

{

"request-id": "5f6f6f5f-5d1b-4f1a-9b2d-a6fe4f38743e",

"client-request-id": "5f6f6f5f-5d1b-4f1a-9b2d-a6fe4f38743e",

"x-ms-ags-diagnostic": "{\"ServerInfo\":{\"DataCenter\":\"UK South\",\"Slice\":\"SliceC\",\"Ring\":\"4\",\"ScaleUnit\":\"003\",\"RoleInstance\":\"AGSFE_IN_9\"}}",

"Strict-Transport-Security": "max-age=31536000",

"Timing-Allow-Origin": "*",

"x-ms-apihub-cached-response": "true",

"Cache-Control": "private",

"Date": "Thu, 13 Feb 2020 12:56:11 GMT",

"Content-Length": "229",

"Content-Type": "application/json"

}

Send an email from a shared mailbox V2 >>

ActionConditionFailed. The execution of template action 'Send_an_email_from_a_shared_mailbox_(V2)' is skipped: the 'runAfter' condition for action 'Get_my_profile_(V2)_2' is not satisfied. Expected status values 'Succeeded' and actual value 'Failed'.

[efialttes]

Hiagain

Well, we are close to find the issue

1.-Why do you use two 'Get my profile'? Both of them will provide same info, right?

2.- Does your first 'Get my profile' work? If so, did you considered removing the second 'Get my profile' and using the outputs of your first 'Get my profile' as input to your 'Send an email' instead?

Hope this helps

[ScottShearer]

@sudosaurus 

I agree with the comments made by @efialttes but would like to add that it looks like you really want profile info about the person who sent the email.  If so, then you probably want to use the Office 365 Get User profile action and configure it per my screen shot below.

[sudosaurus]

Having done this I am now getting an error of: Parsing Select and Expand Failed

Outputs

{

"error": {

"code": "BadRequest",

"message": "Parsing Select and Expand failed.",

"innerError": {

"request-id": "cc9e069b-7b4f-4147-9edb-7d7baa0cfbdb",

"date": "2020-02-13T14:09:28"

}

}

}

Headers

{

"request-id": "cc9e069b-7b4f-4147-9edb-7d7baa0cfbdb",

"client-request-id": "cc9e069b-7b4f-4147-9edb-7d7baa0cfbdb",

"x-ms-ags-diagnostic": "{\"ServerInfo\":{\"DataCenter\":\"UK South\",\"Slice\":\"SliceC\",\"Ring\":\"3\",\"ScaleUnit\":\"000\",\"RoleInstance\":\"AGSFE_IN_3\"}}",

"Strict-Transport-Security": "max-age=31536000",

"Timing-Allow-Origin": "*",

"x-ms-apihub-cached-response": "true",

"Cache-Control": "private",

"Date": "Thu, 13 Feb 2020 14:09:28 GMT",

"Content-Length": "229",

"Content-Type": "application/json"

}

[ScottShearer]

@sudosaurus 

If you are using a Get User Profile action and are saying that it is generating the error, please post a screen shot of that action in edit mode please.

[sudosaurus]

Here's the screenshot:

[sudosaurus · Accepted solution]

I have now stripped the "From" action out of the selected fields box and the email has now appeared in my inbox.

SOLVED.