Populate a Combobox with JSON array response from flow

[sathish804]

Hi All,

Good day!!

I have a custom connector which resturns the AD roles in a JSON array. I created a flow to send this back to the power app.

Now I am trying to create a variable to hold these values to populate them in a combo box like this

But in Combobox when I am using the FetchedItems variable I am getting error that expected a table value.

Please advise what I am doing wrong here.

Thanks and regards,

Sathish.

[AmeerJab]

Can you check the datatype of the data your getting from power automate, as i think you're not getting a table type where i think that you're getting an array instead, mostly when i use custom connectors to get data as tables into power-apps the data should be in between {} not [].

[sathish804]

I dont think it need {} because when I put the array directly to the set variable step its able to populate the combobox. But I want to do it with the service.

[AmeerJab]

Yes in power apps it does work, but what i meant by the {} is that the data populated from power automate isn't a table type for power apps, to make sure, you can create a test table and then add the data to the table, or set the value in a set method in power automate to check the data type

[sathish804]

Sorry not sure on data type in power automate. I am just using response step to send the JSON array back to Power app.

[AmeerJab]

Hello,

so i was trying to remake your case here so please view below steps:

• I made an array that represent the AzureRoles you have

• i had the same response value you have 

• and below is the output in power apps

try to get your array to be represented as above, maybe by putting the value of your data in an array variable and send it through the response 

Regards.

[sathish804 · Accepted solution]

Figured it out!! Just made the collection like this 

ClearCollect(FetchedItems, FetchADRoles.Run().Value);