Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Populate a Combobox with JSON array response from flow

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,




Accepted Solutions

Figured it out!! Just made the collection like this 


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

View solution in original post

Resolver I
Resolver I

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 [].

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.




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

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






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 




Figured it out!! Just made the collection like this 


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

Helpful resources

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on June 15, 2022 at 8am PDT.

PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.


New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

Top Solution Authors
Top Kudoed Authors
Users online (3,877)