You’re offline. This is a read only version of the page.
90
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 |
Take a look at this post in the power automate forum about mapping multi-select choices. You'll have to define your own mapping but the method to write to the multi-select choice in dataverse is the same.
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 |
this is master data. now i am trying to split the old data in to new choice colmn
Your multi-select is basically an array of data, you can iterate through that array of options and then write that to the new field, or concatenate them all together into a single string with a delimiter.
Are you running into issues iterating through the multi-select?
#1
WarrenBelz
770
Most Valuable Professional
#2
stampcoin
494
#3
MS.Ragavendar
399
Share
Report
All responses (
Answers (
