cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
hajekj
MVP

Weird behavior of SQL connector with on-premise data gateway

Hi, so we are hitting a very weird behavior when using the SQL connector in combination with on-premise data gateway.

 

When a Flow executes a stored procedure (select item by ID from table) we usually get a single response (since the ID is primary key etc.). However we noticed that in some situations, where the flow is triggered at the nearly same time (with different IDs) the result of the stored procedure is returned with 2 or more results (they all have different ID, only one has the correct one). So my question is, whether this is expected behavior and why is it happening?

 

So far, we are thinking that it is due to the use of stored procedure, that the result is just "batched" together when the answer is read by Flow by the data gateway. Is there any way to prevent this? We tried checking the logs of on-prem data gateway, but it didn't have any indication to why this might be happening.

2 REPLIES 2
v-yamao-msft
Community Support
Community Support

Hi @hajekj ,

 

Could you show me more details on how is your stored procedure configured?

 

And a screenshot of your flow would be helpful for me to reproduce this issue.

 

I am looking forward to your reply.

 

Best regards,

Mabel

 

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi @v-yamao-msft ,

Here, you can see the flow snipped that uses the procedure. The condition inside the loop was added after the thing @hajekj described happened, as a precussion. 

 

Kus flow.PNG

 

And here is the stored procedure.

 

stored procedure.PNG

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

May UG Leader Call Carousel 768x460.png

June User Group Leader Call

Join us on June 28 for our monthly User Group leader call!

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Power Automate Designer Feedback_carousel.jpg

Help make Flow Design easier

Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!

Top Solution Authors
Users online (3,361)