Error on Sharepoint and OneDrive

(0) Share

Report

Posted on by Eric McKinney

173

Trying to do a simple attachment from email and save to OneDrive and I am getting this error:

Unable to process template language expressions in action 'Create_file' inputs at line '1' and column '2319': 'The template language function 'base64ToBinary' expects its parameter to be a string. The provided value is of type 'Null'. Please see https://aka.ms/logicexpressions#base64ToBinary for usage details.'.

In reality i am trying to do something far more comprehensive but in working backwards involving just going to onedrive and trying to eliminate variables this is the error i am getting. It was working fine as of two days ago. Just looking to see if anyone is having similar issue.

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (0)

Eric McKinney 173 on at

Like (0)

Report
Copy link

Link copied!

A little more information, I compared my failed flows to my succeeding flows from a couple days ago. I highlighted where it detects I have an attachment but it is making the content-bytes null where it expects a string. It clearly lists the size in the body below. I also tried sending from Webmail and Outlook. I tried PDF's, Word Docs, Excel files, nothing seems to be going through.

{
  "Id": "AAMkADk4YTg3YWFjLTgzZjUtNDNiYi04ZThmLTNmZDI0ZDllOTdlZgBGAAAAAADOLSqaAgzaQZDEWl2rvpWEBwB1SrX4n2BmTL1BH31CZ41OAAAG6HFhAACFXNhLr1eRSrPo7UifxpZKAAD3xM_rAAA=",
  "DateTimeReceived": "2018-03-06T23:51:36+00:00",
  "HasAttachment": true,
  "Subject": "test",
  "BodyPreview": "",
  "Importance": 1,
  "ConversationId": "AAQkADk4YTg3YWFjLTgzZjUtNDNiYi04ZThmLTNmZDI0ZDllOTdlZgAQADeJ4XWwhlBDs4blA0u9z14=",
  "IsRead": false,
  "IsHtml": true,
  "Body": "<html>\r\n<head>\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\">\r\n<meta content=\"text/html; charset=iso-8859-1\">\r\n<style type=\"text/css\" style=\"display:none\">\r\n\r\n</style>\r\n</head>\r\n<body dir=\"ltr\">\r\n<div id=\"divtagdefaultwrapper\" dir=\"ltr\" style=\"font-size:12pt; color:#000000; font-family:Calibri,Helvetica,sans-serif\">\r\n<p style=\"margin-top:0; margin-bottom:0\"><br>\r\n</p>\r\n</div>\r\n</body>\r\n</html>\r\n",

  "Attachments": [
    {
      "@odata.type": "#Microsoft.OutlookServices.FileAttachment",
      "Id": "AAMkADk4YTg3YWFjLTgzZjUtNDNiYi04ZThmLTNmZDI0ZDllOTdlZgBGAAAAAADOLSqaAgzaQZDEWl2rvpWEBwB1SrX4n2BmTL1BH31CZ41OAAAG6HFhAACFXNhLr1eRSrPo7UifxpZKAAD3xM_rAAABEgAQABLrfkWwJIlAkPLep_hf3EU=",
      "Name": "ColRoutes.xlsx",
      "ContentType": "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",
      "Size": 41231,
      "ContentBytes": null
    }
  ]
}

Apply to each
1s

ActionFailed. An action failed. N

Was this reply helpful? Yes No
Eric McKinney 173 on at

Like (0)

Report
Copy link

Link copied!

Troubleshooting 101: Check the most obvious, didn't have send attachments turned on. I assumed it was on by default.

Was this reply helpful? Yes No
v-yuazh-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @ emckinney81,

Could you please share a screenshot of the configuration of your flow?

I have made a test on my side, and don’t have the issue that you mentioned.
Please make sure you have set the “Has Attachment” field and the “Include Attachments” field to “Yes”.

If you set the “Has Attachment” field and the “Include Attachments” field to the default value “No”, the error would occur as you as screenshots below：
Or if you set the “Has Attachment” field to “Yes” and set the “Include Attachments” field to “No”，the error would occur as you as screenshots below：

The screenshot of my flow as below:

When an email with attachment arrives, the flow would run successfully as below:

Regards,
Alice Zhang

Was this reply helpful? Yes No