Hi @Vedant28 ,
in this case you can use a power automate flow to update the records,
first you list the whole dataverse table, then you create an apply to each action.
inside the loop you should create 4 switch action and set 4 paths, one for each old choice column value.
then inside the switch action you create and update row and you update the new choice column according to your table.
If my response resolved your issue, please feel free to mark it as the solution by clicking "Accept as solution." This helps others find the answer more easily. If you found the content helpful in any other way, a "Thumbs Up" would be greatly appreciated. Thank you!
