Can the process action refresh table be used in a system flow?

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