the field is multiselect field and i have altotal of 1700 records that inclides all and not blank cases are there and this change would only require to the active cases, for closed it should remain same.
Would you mind if you can demonstrate.
issue i have is like the old column had multiple choice value, only trying to replace the old with the new one
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!
WarrenBelz
146,524
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
65,906
Most Valuable Professional