How to Create a Flow That Auto Populated Data From the Last Submitted Record

[beycos]

Hello Community,

I'm trying to design a Flow in ServiceNow that automates the following process:

1. When a user creates and submits a record , a new record is automatically created.
2. The new record should automatically populate all data from the last submitted record.
3. The user should be able to edit the new record, and after submitting it, another new record should be created, pre-filled with the updated data from the most recent submission.
4. This cycle should continue for every new submission.

I've successfully created a Flow with a Record Created trigger and a Create Record action, but I'm facing challenges ensuring is  Each new record pulls data only from the most recently submitted record.

Any help would be appreciated. 

Thank you in advance. 

Beyza 

[Hemanth M1 · Accepted solution]

Hi @beycos ,

Step 1: Your flow trigger should be when a record gets updated. Get the details of the updated record (to pre-fill).

Step 2: Use the Create Record action, using details from the trigger record (Step 1).

Make sure this doesn't end up in an infinite loop (set it to run once for an update).

\

[beycos]

I have one more question. When a new record is created in the X table, I want the most recently used record for each user to be auto-filled. There are multiple users, and I want each user's most recently filled fields to be auto-filled in the newly created record. Could you assist me with this? Thank you 

[beycos]

Thank you Hemanth. It worked .