How to convert comma separated values into Multi Select choice column data type for SharePoint

[sayyedkohler]

Hi All,
I am trying to create Multi select Choice type column record in SharePoint online.
@Expiscornovus helped me to achieve this manually. Link here
But now My scenario is: I am having comma separated values(suppose: India, Bangladesh) in excel sheet and I need to convert those comma separated values in this format and then use that to create record :

[
  {
    "Value": "India"
  },
  {
    "Value": "Bangladesh"
  }
]

Thanks

[v-bofeng-msft · Accepted solution]

Hi @sayyedkohler :

I've made a test for your reference:

Best Regards,

Bof

[sayyedkohler]

Thank you very much @v-bofeng-msft .
You guys are doing great work and with sample flow, it was very easy for me to solve issue.