Dynamics Community Forum Thread Details

Add Options Dynamically in Choice Attribute

Hi All,

Please help me with below situation. I want to fetch some options from an external API and then put those options in an attribute(datatype is Choice) in a Custom Table(in Power Apps).

Fetching Options from External API is not a problem, it is working fine. I'm not sure how to add these options in that attribute via Cloud Flow/PowerAutomate?

Note: I don't want to add these options manually.

<Details>
1. Suppose external API is - 'https://myclient.com/b2bapi/options/city'
2. Response from external API will be -

{
    "data": [
        {
            "name": "Delhi",
            "id": 1412
        },
        {
            "name": "Jaipur",
            "id": 1553
        },
        {
            "name": "Bhopal",
            "id": 1414
        },
        {
            "name": "Hyderabad",
            "id": 1537
        },
        {
            "name": "Surat",
            "id": 1411
        }
  ]
}

3. Add these City Options in 'EmpCity' attribute via Cloud Flow/PowerAutomate.