Unable to set-up Copy Rows Workflow, because of system generate columns



I wanted to create a workflow, that copies a data to other sheet (destination sheet) whenever a new row is added in source sheet. However, I do have some system generated columns like Added By, Date added, Updated By, Updated Date. The destination sheet was also formatted and designed as a same way as source sheet. I have even tried renaming the system generated columns differently in destination sheet. Can someone please help me with this?



Best Answer

  • John_Foster
    John_Foster ✭✭✭✭✭✭
    Answer ✓

    Hi @Mounika,

    I had a similar problem, to get around it, I created a blank sheet and created the automation to copy the rows across to it. Once copied I then amended the rows in the destination sheet as required.

    Hope this helps.