Answered

Snowflake "Convert result set" returns 'System.FormatException' error

(0) Share

Report

Posted on by djworsdell

Hi all - attempting to use the Snowflake connector in Power Automate as follows...

When I attempt to run/test the above flow, I receive the following error in the "Convert result set rows from array to objects" step after ~15 minutes and 2x re-tries...

System.FormatException:System.FormatException: Input string was not in a correct format.
 at System.Number.ThrowOverflowOrFormatException(ParsingStatus status, TypeCode type)
 at System.Int64.Parse(String s)
 at Microsoft.PowerPlatform.ConnectorPlatform.CustomCodeConnector.CSharpScript.InProcess.Script.ConvertToObjects()

Has anyone seen something similar before, and are aware of how to resolve the issue? This error looks similar to this recent post last month. Thanks in advance!

Categories:

Using connectors

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

djworsdell 75 on at

Like (0)

Report
Copy link

Link copied!

Update: for those who stumble across this thread in the future, I've found that the Snowflake (Preview) connector as of August 2023 seems to cut off the response of 'SQL Statement Execution' when returning large data sets. Your milage might vary, although I found this was around ~200 rows with ~70 columns.

The solution was to pass through one or more filters from Power Apps into the SQL statement prior to execution to reduce the number of rows which are to be returned. Once filtered down to a more manageable level of data, the Snowflake (Preview) connector runs in 2 - 3 seconds without problem.

Hopefully this is addressed in future versions of the connector! Doesn't seem to be too much conversation about Snowflake in the Power Platform community at this point in time.

Was this reply helpful? Yes No
Sja855 61 on at

Like (0)

Report
Copy link

Link copied!

Hello @djworsdell

I also had same issue, my aim is to pull the existing data which is 100 rows and 10 columns from Snowflake and display it in the gallery. but ended facing the same issue. are there any workarounds to fix this issue at least now?

Thanks in Advance!

Was this reply helpful? Yes No