I have created a standard Microsoft Form with various options to mirror a paper New Starter Form - has questions about Name, role, equipment needed etc.
I have previously created a similar form and used Power Automate to Email the Form content to various recipients using the in-built "Form processing to email and SharePoint" template. In flows I set my own office365 account as the connector for all mail and sharepoint services.
Now when I test the flow(or do a dummy run with data in the form)(using the same account as the flow connector), the form data gets pulled in fine but the email will not send. The rather unhelpful error message is "unauthorised" and there isn't any further diagnostics info.
This has previously (within the last six months) worked without issue and the only factors that are different are:
a) security defaults enabled on the account
b) I am not an admin on the Office365 tenant that I am using
c) MFA enabled
To troubleshoot the issue, I created a test Office 365 tenancy without the issues of admin control or MFA; it still has the security defaults enabled. Re-testing the same thing from there produces the same results as in failure to send.
This leads me to the conclusion that:
- Security defaults may be the issue
- Something else has been recently enabled on the 365 account that has broken the functionality
- there is something I am not aware of in regard to the automate process
Anyone have any suggestions?
Additional information is that it makes no difference whether security defaults is on or off.
Also, I noticed that it seems to be using Sendgrid for the mail sending which I don't recall it used before. Anyone know of any reasons why Sendgrid might block the email sending or if it requires any particular permissions to work?
WarrenBelz
146,594
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
65,928
Most Valuable Professional