cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
emckinney81
Level 8

Error on Sharepoint and OneDrive

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. 

3 REPLIES 3
emckinney81
Level 8

Re: Error on Sharepoint and OneDrive

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\np\r\n\t{margin-top:0;\r\n\tmargin-bottom:0}\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
    }
  ]
}
 
ActionFailed. An action failed. N
emckinney81
Level 8

Re: Error on Sharepoint and OneDrive

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

Community Support Team
Community Support Team

Re: Error on Sharepoint and OneDrive

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:

1.png

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:

 2.png

The screenshot of my flow as below:

 3.png

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

 4.png

 

Regards,
Alice Zhang

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors (Last 30 Days)
Users online (4,668)