Populate a Combobox with JSON array response from flow

(0) Share

Report

Posted on by 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.

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

AmeerJab 370 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
sathish804 18 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
AmeerJab 370 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
sathish804 18 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
AmeerJab 370 on at

Like (0)

Report
Copy link

Link copied!
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.

Was this reply helpful? Yes No
Verified answer

sathish804 18 on at

Like (1)

Report
Copy link

Link copied!

Figured it out!! Just made the collection like this

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

Was this reply helpful? Yes No