+5Hi,
Is it allowed to use a refresh table inside a system flow. When I use it, it do not seem to refresh the table.
I have a task to send email on → email table, after the task is pressed (it updates value for system flow),a system flow triggers and sends the email. The status in the table do not change unless manually refreshed. What can be the solution for this issue?
Best answer by Mark Jongeling
Hi Rucha,
Refresh table is not a System flow process action I'm afraid.
You can utilize Auto-refresh combined with Change detection to refresh a subject based on logic. F.e., refresh every 5 seconds, Change detection in place that does not let the subject refresh until the column Status is equal to Approved and the last refresh is not greater than the update_date_time in UTC. Note that this works with UTC time
or in code:
if exists (select 1
from sales_order o
where o.status = 'approved'
and o.update_date_time >= @last_refresh_utc)
begin
-- Perform a refresh
set @refresh_data = 1
end
-- Else do not automatically refresh
+23Hi Rucha,
Refresh table is not a System flow process action I'm afraid.
You can utilize Auto-refresh combined with Change detection to refresh a subject based on logic. F.e., refresh every 5 seconds, Change detection in place that does not let the subject refresh until the column Status is equal to Approved and the last refresh is not greater than the update_date_time in UTC. Note that this works with UTC time
or in code:
if exists (select 1
from sales_order o
where o.status = 'approved'
and o.update_date_time >= @last_refresh_utc)
begin
-- Perform a refresh
set @refresh_data = 1
end
-- Else do not automatically refresh
+5Thanks for the quick reply Mark!
I will try and implement this. :)
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.