How to copy and update field value of one table to another table using flow designer

[Nivetha23jay]

Hi everyone 

I have a requirement where I have to copy field value of one table to another table via flow

Example:

There are two tables, table 1: alm_hardware and table 2:sn_intune_device, both have similar serial number, now I have to copy enrolled date from table 2 to table 1 using flow designer 

[GlideFather]

Hi @Nivetha23jay,

the right solution is depending whether you want to do it as a one-timer, meaning you copy the values from one table's field to another table's field, that could be done easily by a fix script but that would match the data as of today any data changes - updates in the original field and/or creating completely new records will not be updated.

If you want to have this 1:1 at all times you will need to do the one-time script as a starting point and then to ensure to be automatically handled in future - that could be done by a scheduled job, business rule, flow designer, ... it depends on what is the exacrt expectation from this.

Please let me know more details as this could be done in many ways