Skip to main content

Notifications

Power Automate - Using Connectors
Answered

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

(0) ShareShare
ReportReport
Posted on by 75

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

djworsdell_0-1691469708263.png


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!

  • Sja855 Profile Picture
    Sja855 61 on at
    Re: Snowflake "Convert result set" returns 'System.FormatException' error

    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!

  • Verified answer
    djworsdell Profile Picture
    djworsdell 75 on at
    Re: Snowflake "Convert result set" returns 'System.FormatException' error

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,508

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,839

Leaderboard

Featured topics