Solved: Re: 'Test Connection Failed' on Send Email (ShareP...

Anonymous · ‎10-07-2019

Getting 'Test Connection failed' when trying to fix the connection for Send Email. For every other connection in my flow it connects using the same account. The account is site administrator for the site in question.

The field Send As is being used. Does this mean that the account used to connect to SP needs to be given permissions on the mailbox that it is trying to send from?

Help please!

Regards,

C

Anonymous · ‎10-10-2019

Hi Pstork1,

This has been resolved. The issue was that the mailbox used as in the 'Send Email' step and and the account used to create the Flow both had their licenses changed. We still don't know how this happened.

For the account used to create the flow:

We changed licence from O365 A1 for Students to O365 A1 for Faculty (all apps including Flow for O365 enabled)

For the mailbox used in the 'Send Email' step we used an Office 365 'Connection' (this was the one that needed fixing as it showed an error about REST API in red), by changing the license to:

Licence is O365 A1 for Faculty (but limited applications enabled as this was setup just for SharePoint access, Flow enabled today)

This allowed me to 'fix' the connection.
I then had problems with the trigger. It was using the fixed connector but still was showing 'error with trigger' until I made a copy of the flow and the copy didn't show this error. I disabled the old one and have been happy since.

I think this was one heck of a faff. A bit more info trickled down to the Flow creator account would be better when this kind of thing happens. The error handling is pretty naff on Flow.

I hope this helps someone else with a similar or identical issue.

View solution in original post

Pstork1 · ‎10-07-2019

That is exactly what it means. To put a different user in the FROM box on an email in Flow requires that theuser running the Flow have Send As permission for the mailbox being used in the FROM. The site admin will need Send As permission for any account added in the FROM box.

-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Anonymous · ‎10-09-2019

Hi Pstork1,

Just had my admin add Send As permission on the mailbox being used in the From and it still says 'Test Connection Failed' for the Send Email stage used in the Flow.

Any ideas?

Regards,

C

Pstork1 · ‎10-09-2019

Are you saying that the admin added your account with Send as permission to that mailbox? And the connector is using your account for the connection? If so, I would remove and re-add the email action in the Flow. They can sometimes be tricky about picking up on security changes.

-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Anonymous · ‎10-09-2019

Hi PStork1,

If I remove the Send Email step and then re-add a new one, even before I type anything in it says Test Connection failed. I've fixed all the connections elsewhere in the flow and fixed all the connections on the connection list.

Pstork1 · ‎10-09-2019

Not sure what else to suggest. Definately a permissions issue on the connector though. Is the mailbox being used in Exchange Online or on-premises? This connector won't work with on-premises Exchange.

-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Anonymous · ‎10-09-2019

Hi, It's SharePoint Online.

Pstork1 · ‎10-09-2019

Understood, but is your organization in a hybrid environment that uses Exchange on-premises or fully Office 365? SharePoint doesn't have a capacity to send email. It uses the Exchange setup for the mailbox you are specifying. It matters where that mailbox is.

-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Anonymous · ‎10-09-2019

Can you tell me what type of connector it should be to be able to use Send Email. Office 365? If I try to add that Connector it says:

Which can't be correct because the flows were working up until the 2nd October, (7 days ago).

Anonymous · ‎10-09-2019

Hi - no it's not a hybrid setup it's completely Office 365, SharePoint Online. Exchange Online not hybrid.

Anonymous · ‎10-09-2019

PStork1,

Do you know what type of license is needed for this mailbox? At the moment it's a standard 'student' one.

Thanks for your attention and help so far.

REgards,

C

Pstork1 · ‎10-09-2019

Sorry, no idea. If you've been given send as permission you could try hooking up to the mailbox and sending an email. If that doesn't work its something about the mailbox.

-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Anonymous · ‎10-10-2019

Hi Pstork1,

This has been resolved. The issue was that the mailbox used as in the 'Send Email' step and and the account used to create the Flow both had their licenses changed. We still don't know how this happened.

For the account used to create the flow:

We changed licence from O365 A1 for Students to O365 A1 for Faculty (all apps including Flow for O365 enabled)

For the mailbox used in the 'Send Email' step we used an Office 365 'Connection' (this was the one that needed fixing as it showed an error about REST API in red), by changing the license to:

Licence is O365 A1 for Faculty (but limited applications enabled as this was setup just for SharePoint access, Flow enabled today)

This allowed me to 'fix' the connection.
I then had problems with the trigger. It was using the fixed connector but still was showing 'error with trigger' until I made a copy of the flow and the copy didn't show this error. I disabled the old one and have been happy since.

I think this was one heck of a faff. A bit more info trickled down to the Flow creator account would be better when this kind of thing happens. The error handling is pretty naff on Flow.

I hope this helps someone else with a similar or identical issue.

Pstork1 · ‎10-10-2019

Glad you got it resolved.

-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.