Error: The method or operation is not implemented.

[JoeF__]

Getting this recurring error for no apparent reason.
I have a desktop flow that pulls data from an excel sheet and parses in a certain way, then stores the data as a datatable in an output variable. (It's just a normal datatable with column headers:)

The flow works 100% fine, except it consistently fails on the last action, regardless of what that action is, with the following error:

System.NotImplementedException: The method or operation is not implemented.
   at Microsoft.Flow.RPA.Desktop.Robin.Engine.Types.TypeAdapters.TypeAdapter`1.ToSerializedValue()
   at Microsoft.Flow.RPA.Desktop.Robin.Engine.Types.TypeAdapters.DataTableAdapter.ToSerializedValue()
   at Microsoft.Flow.RPA.Desktop.Robin.Engine.Execution.Runner.TrySetFlowsOutputArguments(ICollection`1 outputVariables)

I know it isn't actually the final action causing the error, as wrapping the final action in an "On block error" doesn't cause any change.

I suspect it's an issue with using a datatable as an output variable, maybe the column headers are causing an issue.
I also can't run the flow from any other flows with the "Run desktop flow" action, it produces the same error:

System.NotImplementedException: The method or operation is not implemented.
   at Microsoft.Flow.RPA.Desktop.Robin.Engine.Types.TypeAdapters.TypeAdapter`1.ToSerializedValue()
   at Microsoft.Flow.RPA.Desktop.Robin.Engine.Types.TypeAdapters.DataTableAdapter.ToSerializedValue()
   at Microsoft.Flow.RPA.Desktop.Robin.Engine.Execution.Runner.TrySetFlowsOutputArguments(ICollection`1 outputVariables)

Is there a work-around for this or could there be a problem with my flow that I'm not recognising?

[kmckeon]

I'm having the exact same issue. Pulling data from an excel file into a data table output variable. The process runs to completion and then throws this error. I have other processes that do all the same things except the database output variable so I suspect that is the root of the problem but I can't seem to figure it out. 

A temporary work around would be to write the new data table into a temporary excel file and have your next process open it, read it, and then delete the temp file. It's not ideal but it would get the data from process A > process B

[JoeF__ · Accepted solution]

(Duplicate of other reply)
@kmckeon Work around found! (i think)

I believe PAD is throwing a tantrum because of datatypes. As soon as I enabled "get cell as text" it started working fine. My excel file only has text, datetimes, and phone numbers so I'm assuming one of those is causing the issue.

Option 1: Because I'm Australian, I use the superior date format of d/mm/yyyy HH:MM AM/PM, it's receiving "invalid" dates
Option 2: My file has phone numbers formatted with country codes that look like "+61000000000" and the plus sign is screwing it somehow.

[FabianoHallmann]

Hi,

I'm having the same issue. Despite the fact that i'm not using Excel as a data source.

I fill a datatable as the flow runs. it crashes When i call the other desktop flow and pass the datatable.

I've tried creating other flows and passing datatables as parameter and it worked.

[FabianoHallmann]

Thank you all,

As I read the previews answers I realized I was passing a reference to a file in the datatable cell (Files[0]). Once I specified the FullName property (Files[0].FullName) it Worked!