Answered

Error with the message 'The Error exists on Form'. 'Execute SQL statement' action of Power Automate Desktop version# 2.37.123.23280.

(0) Share

Report

Posted on by Hiroumi

Dear All,

After PAD update version#2.37.123.23280 was installed, The 'Execute SQL statement' action wouldn't be available to save with this error when I clicked the SAVE button. Even without changing the SQL statement, this error happens when I click the SAVE button.

SQL statement should be correct because this PAD flow completes without error as before the PAD update. Therefore, SQL statements in the 'Execute SQL statement' action are no problem.

Also, I have added a new 'Execute SQL statement' with the same SQL statement, and then this was saved and executed normally.

But, once opened by clicking the EDIT button it was not available to save with this error by clicking the SAVE button even if the statement was changed or not.

Please let me know what should I do to avoid this error.

Thanks.

Categories:

Power Automate Desktop

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Verified answer

Agnius Bartninkas Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

It would be a lot easier for us to comment on this if you translated the error to English.

But your description sounds a lot like a bug, especially if you can create a new Execute SQL statement action, but cannot save modifications.

I would suggest reporting this as a bug to MS support.

-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.

I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.

Was this reply helpful? Yes No
Hiroumi 13 on at

Like
a
(0)

Report
Copy link

Link copied!

The error message in English is "The Error exists on Form" which I translated into English.

Unfortunately, I'm unsure of the precise error message in the English environment.
Also, how to switch to the English language the PAD is not sure.

Was this reply helpful? Yes No
Agnius Bartninkas Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

You might have a syntax error if you're using the percentage symbol somewhere literally. Or you might have some variables accessed incorrectly. Can you share the entire SQL query?

In order to change the language of PAD, you actually need to change the input language on Windows. See this tutorial: https://www.youtube.com/watch?v=l2zpRkUBk0o&ab_channel=AndersJensen

-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.

I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.

Was this reply helpful? Yes No
Hiroumi 13 on at

Like
a
(1)

Report
Copy link

Link copied!

The on-going status as of today.
I have asked MS support for this issue. They replied that it would take several days for the solution, maybe in November. I will post when I have any replies from MS support.

Was this reply helpful? Yes No
Hiroumi 13 on at

Like
a
(0)

Report
Copy link

Link copied!

After a few days, the form error stopped occurring even though I hadn't applied any updates.
MSsupport guys said that they supposed this error had happened with my temporary environment problem.

However, they didn't answer clearly what's "environment" is and why "temporary".
Anyway, my PAD environment has returned to normal.

Thanks

Was this reply helpful? Yes No