How to get the result of API in dropdown

[Saurabh-704]

Hello All!

I have created one application in which I have integrated API with it. In this application I have taken one Textbox named as subID and second I have taken dropdown. 

Now what API is doing that as soon as I am passing subID it will get me the list of colleges. So what I want is, I want to get the list of that colleges in that dropdown format. So how can I achieve this thing?

Can someone please help me with this?!

Thanks in advance!

[rsaikrishna]

@Saurabh-704 

What is the format the API is returning the colleges. If you can get all the values in the form of a Table or Collection, you can bind it to the drop down Items property.

Please provide additional details to look into it.

Regards

Krishna Rachakonda

If this reply helped you to solve the issue, please mark the post as Accepted Solution. Marking this post as Accepted Solution, will help many other users to use this post to solve same or similar issue without re-posting the issue in the group. Saves a lot of time for everyone.

[Saurabh-704]

Thank you @rsaikrishna for your reply. I am getting result in JSON format. I am getting "ID" as well as "Collage name" in JSON format, but I only want to show College name in dropdown. 

[rsaikrishna]

@Saurabh-704 

Thats great. 

You can use Json function in Power Apps.

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-json

Get all the values from JSON to a collection and bind the collection to drop down.

Regards

Krishna Rachakonda

If this reply helped you to solve the issue, please mark the post as Accepted Solution. Marking this post as Accepted Solution, will help many other users to use this post to solve same or similar issue without re-posting the issue in the group. Saves a lot of time for everyone.