Refresh/ClearCollect delay with SQL Server stored procedures?

Like (0) Share

Report

Posted on 21 Sep 2020 20:43:00 by farhandsome

175

Hello all,

Having an issue with refreshing data.

I have a DatePicker app that allows a user to input certain dates and then use these to update dates in a SQL server database. Sometimes, these dates can update hundreds, if not thousands of dates so I am calling a stored procedure via Microsoft Flow from the app in order to facilitate this update.

However, after I call this stored proc, I refresh the data and then re-do my ClearCollect to update the collection that the gallery is feeding from. It looks like the ClearCollect is not picking up on the changes made by the stored proc. Anyone else having these issues? I've tried to add a delay between the stored proc and the refresh via a timer, but that didn't fix the issue.

Categories:

Connecting to Data

General Questions

I have the same question (0)

All responses (2)

Answers (0)

PaulD1 2,914 on 21 Sep 2020 at 21:29:01

Like (1)

Report
Re: Refresh/ClearCollect delay with SQL Server stored procedures?

If you have not already, maybe try the following:

Have the Flow return a value to Power Apps and set a variable to that value - this should force Power Apps to wait for the Flow to complete (return the value) before continuing with other commands. You may also need to have your Stored Proc return a value to Flow to ensure that Flow is waiting for the Stored Proc to complete before moving to the next step.

Use Performance Monitor to try to determine whether your Refresh is actually firing and returning records and whether it is firing before or after your Flow has completed.

Was this reply helpful? Yes No
farhandsome 175 on 22 Sep 2020 at 13:15:53

Like (0)

Report

Re: Refresh/ClearCollect delay with SQL Server stored procedures?

Great idea. I was using the timer control to hard-code a value, but returning a value should force the app to follow the correct sequence.. I'll give it a try.

Was this reply helpful? Yes No