Skip to main content

Hi,

 

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?

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

 

Thanks for the quick reply Mark!

I will try and implement this. :)

Terms & ConditionsCookie settings