
Hi Everyone! Been trying to resolve this issue for a while:
I've been trying to pass a DataTable or a List, both extracted from Excel into another Desktop Flow as input variables. I trialed two different approaches, but it did not work out well in both instances. For clarity, let's call the original parent flow as "Parent Flow", and the flow targeted by "Run Desktop Flow" as the "Child Flow":
First scenario: attempting to pass DataTable as input variable into "Child Flow".
Parent Flow's input datatype: DataTable (extracted from Excel)
Child Flow's input datatype: DataTable (specified below)
Result:
Other details:
Oddly enough, this error did not occur when I created an empty DataTable in the Parent Flow before passing it to the Child Flow.
Second scenario: attempting to pass List as input variable into "Child Flow". ** SOLVED - See end of message **
Parent Flow's input datatype: List of Text Values (extracted from Excel)
Child Flow's input datatype: List (apparently this is a List of General Values - the error later shows this)
Result:
Other Details:
I've looked around to see if I can
a) Have the list extracted from Excel in Parent Flow be a List of General Values (haven't managed to do this)
b) Have the input list in Child Flow be a List of Text Values > I tried setting default value as a string, but it did not work
Not sure if anyone has the same issues as I faced - I'll update if I find any temporary workaround too.
====================================================
20220805 1346 GMT+8 Updates - Re Second Instance > Sorry, I realised that I was not enclosing one of my input variables with "% %" - my bad! The only outstanding issue that I am troubleshooting is the First Scenario where it says "The method or operation is not implemented" when I tried to pass a DataTable extracted from Excel into a Child Flow.