hi Expert
I have a dataverse table which have follwing criteria
1 Old choice column with multi select value
| Case ID | Deatils |
| CaseAB12 | Corona, Flu, Runny Nose |
| CASE ON13 | Wheelchair, CS Issue, Fever,Refund,branch |
| CASE ON14 | Corona, Diarrohea,Credit, Aplogy, operation |
old choice field multi select
| Old Frame multi Select |
| Corona |
| Flu |
| Runny Nose |
| fever |
| Diarrohea |
| credit |
| Draft |
| Wheelchair |
| reflux |
| CS issue |
| Operation |
| branch |
| Mainatinenece |
| Others |
2.
new choice column are as below
these are 4 different choice column in datavverse
| New Frame multi Select (Choice 1) | Reason (only if Runnynose or Fever or Corona Select) its uni select Choice 2 | Nature of business Choice 3 | Decision Choice 4 |
| Runny Nose | Cash | Compensation | operation |
| fever | Diarrohea | reimbursement | knock Ons |
| Corona | Operation | refund | |
| reflux | branch | apology | |
| CS | Nurse | acc charge | |
| Vomiting | Medical Emergency | | |
| Credit | Doc absesnce | | |
| Flu | govt | | |
| Wheelchair | Hazard | | |
requirement:
i am trying to create a one time flow that will split the value of old details column into based on the choice select
| Case ID | Old Details | New Details | Nature of Claim | Cause | Decision |
| CaseAB12 | Corona, Flu, Runny Nose | Denied, Delay, Cancellation | | | |
| CASE ON13 | Wheelchair, CS Issue, Fever,Refund,branch | WheelCHair, fever, CS | | branch | |
| CASE ON14 | Corona, Diarrohea,Credit, Aplogy, operation | Corona, Credit | Refund | Diarrohea | Operation |
