- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-06-2025 11:33 AM
Hi All,
If you see the picture the record has two fields review date and status . Currently status is "in use" when review date is ahead of current date but status will be "retire" immediately when review date passes . Can we achieve it through flow designer ? Actually scheduled jobs are making the system slow so trying to achieve it through flow. In this picture when review date passes on 8th may the status will automatically updated to retire on the fly.
Thank you
Solved! Go to Solution.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-06-2025 01:29 PM - edited 05-06-2025 01:31 PM
1. Trigger type is scheduled, daily.
2. First action is Look up Records (plural) where Review Date is Yesterday.
3. For each item loop.
4. Update Record.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-06-2025 12:28 PM
In Flow designer, you could use "Wait for a Duration of Time" and set the duration type to be relative to the Review Date.... 1 second before

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-06-2025 12:32 PM
But I think the more efficient use of Flow Designer would be to query the table daily for records requiring review yesterday, and flipp all those to retire. Not instantaneous, but perhaps more efficient. Its still similar to a scheduled job, even if its configured in Flow Designer.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-06-2025 12:39 PM
Yes, that is the case . Flow should query the table on daily basis and change the status of those records which review date passed.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-06-2025 01:29 PM - edited 05-06-2025 01:31 PM
1. Trigger type is scheduled, daily.
2. First action is Look up Records (plural) where Review Date is Yesterday.
3. For each item loop.
4. Update Record.