How can I get Power Automate to not try to find or resolve every single user from incoming emails?
I just want it to pass the email address without attempting to "find" the sender.
I am trying to create a SharePoint List item from incoming emails to a shared mailbox. It works well when the email comes from a resolvable user. But it tends to fail when it cannot resolve the user, such as source outside the organization.
I tried to fix the issue by changing the From field to the expression to make everything lower case, toLower(triggerBody()?['From']). In that way I preserve the source email address without invoking the From dynamic content function from the email, which seems to trigger an attempt to resolve the sender.
Still getting attempts to resolve / find the sender and I don't want that. I just want it to pass the email address without attempting to "find" the sender.
{
"statusCode": 400,
"headers": {
"Vary": "Origin",
"X-SharePointHealthScore": "3",
"X-MS-SPConnector": "1",
"X-SP-SERVERSTATE": "ReadOnly=0",
"DATASERVICEVERSION": "3.0",
"SPClientServiceRequestDuration": "195",
"X-DataBoundary": "None",
"X-1DSCollectorUrl": "https://mobile.events.data.microsoft.com/OneCollector/1.0/",
"X-AriaCollectorURL": "https://browser.pipe.aria.microsoft.com/Collector/3.0/",
"SPRequestGuid": "e258ca39-7ad3-4c5f-9f6a-4fe40c7fdf05",
"request-id": "e258ca39-7ad3-4c5f-9f6a-4fe40c7fdf05",
"MS-CV": "OcpY4tN6X0yfak/kDH/fBQ.0",
"Strict-Transport-Security": "max-age=31536000",
"X-FRAME-OPTIONS": "SAMEORIGIN",
"Content-Security-Policy": "frame-ancestors 'self' teams.microsoft.com *.teams.microsoft.com *.skype.com *.teams.microsoft.us local.teams.office.com *.powerapps.com *.yammer.com *.officeapps.live.com *.office.com *.stream.azure-test.net *.microsoftstream.com *.dynamics.com *.microsoft.com securebroker.sharepointonline.com;",
"MicrosoftSharePointTeamServices": "16.0.0.22810",
"X-Content-Type-Options": "nosniff",
"X-MS-InvokeApp": "1; RequireReadOnly",
"Timing-Allow-Origin": "*",
"x-ms-apihub-cached-response": "false",
"x-ms-apihub-obo": "true",
"Cache-Control": "max-age=0, private",
"Date": "Tue, 30 Aug 2022 13:19:11 GMT",
"P3P": "CP=\"ALL IND DSP COR ADM CONo CUR CUSo IVAo IVDo PSA PSD TAI TELo OUR SAMo CNT COM INT NAV ONL PHY PRE PUR UNI\"",
"X-AspNet-Version": "4.0.30319",
"X-Powered-By": "ASP.NET",
"Content-Length": "242",
"Content-Type": "application/json",
"Expires": "Mon, 15 Aug 2022 13:19:11 GMT",
"Last-Modified": "Tue, 30 Aug 2022 13:19:11 GMT"
},
"body": {
"status": 400,
"message": "The specified user hchl.fa.sender@workflow.mail.us2.cloud.oracle.com could not be found.\r\nclientRequestId: e258ca39-7ad3-4c5f-9f6a-4fe40c7fdf05\r\nserviceRequestId: e258ca39-7ad3-4c5f-9f6a-4fe40c7fdf05"
}
}
