Copy Data from 1 column to another in the same dataverse table
I imported a column into a new table that had email address data. However, I didn't set up the column as an email data type and it defaulted to Text data type. Now when I am trying to send emails via a model driven app, it says that now email is available because I don't have the data in the email column.
Is there anyway I can move/copy all the data from 1 column Email Address (Type Text) to another Email Address (Type Email) in a dataverse table?