cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Sienna
Level 10

BUG REPORT: Timer issue when patching to SQL

Just tried to patch multiple rows into SQL server. I have set timer to

 

OnStart

Patch('testeTable', testColumn:"test" & Text(countTimer)); UpdateContext({countTimer: countTimer+1})

 

OnSelect

UpdateContext({countTimer: 0})

 

Repeat

counterTimer < 100

 

However the timer stoped when counterTimer variable exceeded 280 value

 

I know this worked with collections before

1 REPLY 1
Sienna
Level 10

Re: BUG REPORT: Timer issue when patching to SQL

Lesson learned.... Do not use timer to patch straight to SQL. Collect multiple lines with timer to collection and then patch the collection to SQL.

Still wish to know if this is a bug or by design of PA

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors
Users Online
Currently online: 173 members 5,519 guests
Please welcome our newest community members: