Unanswered

Exception Message : The method or operation is not implemented.

(0) Share

Report

Posted on by Hemanth_k

I have tried to save the excel data into a Output Data-table Variable in PAD to pass it into another flow.

While doing that, I am facing the following exception. Attaching the image for your reference. Anyone can assist me on this

Thanks in advance.

Categories:

Power Automate Desktop

All responses (5)

Answers (0)

Sort by

ryule 929 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Is this literally failing on just a Wait action? Have you tried deleting it and readding?
Hemanth_k 4 on at

Like
a
(1)

Report
Copy link

Link copied!

@ryule It's not failing on wait action. Whatever the last action of the flow is, it's failing.
AbdulWahab 517 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Hemanth_k,

Can you please check the status of the sub-flow? Is it running?

If I answer your question then please mark it as verified.

Let me know if I can provide you with more details.

Thanks
Regards,
Abdul Wahab
Power Platform/Customer Engagement Developer/Lead/Solution Architecture/Project Manager
Direct/WhatsApp:+923323281237
E-mail: abdulwahabubit@outlook.com
Skype: abdul.wahabubit
Linkedin: https://www.linkedin.com/in/abdul-wahab-a5b8b011a/
kmckeon 17 on at

Like
a
(1)

Report
Copy link

Link copied!

@JoeF__ and I are having the same problem. It's the data table output variable that seems to be the issue.

Below I have a very simple process I've been troubleshooting on.
- Launch excel file
- Get first free column & Row
- Read the excel worksheet to a data table output variable
- Close the file.

All steps ran perfectly, my data is in the variable pane and the excel file closed. Then this error happens. It doesn't like the data table output variable.
JoeF__ 44 on at

Like
a
(0)

Report
Copy link

Link copied!

@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.