Showing results for 
Search instead for 
Did you mean: 
Advocate I
Advocate I

Calling API into a Collection via Flows

Hi everyone!


I am following a Youtube Video on connecting my API datasource that throws in a json file:

{"d":{"results":[{"__metadata": {"type":"xs_odata_bdq.CV_SRA_MaterialMaster.MaterialMasterType","uri":"https://zpahdhbq6001:32416/xs_odata_bdq/CV_SRA_MaterialMaster.xsodata/MaterialMaster('4239298741005401')"},"GENERATED_KEY":"XXXXX","MaterialCode":"#N/A","MaterialDescription_EN":"XXXXX","PrincipalCode":"XXXXXX","PrincipalName":"XXXXXX ","DrugRegistrationNumber":"","ABCIndicator":"A"}]}}

Now I want to pull down the data into a collection or atleast display it into a label in PowerApps. The base record includes 460,000+++ records and I'm using the HTTPS request to pull down the only matching record to avoid unecessary calls.  


I'm using the current Flow:

This is the current FlowThis is the current Flow

And I store the response into a collection in PowerApps:


Now whenever I run the flow, it succeeds but it doesnt give results on my PA Collections. But on the Flows Test pane, the values are being returned and is being received.


Would really appreciate everyone's help!

Helpful resources


Demo-Extravaganza 2020

Check out these cool Power Apps & vote on your favorite!


Robotic Process Automation

Let's talk about the solution provided by Microsoft for Robotic Process Automation (RPA)


Community Highlights

Check out whats happening in Power Apps


Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

Top Solution Authors
Top Kudoed Authors
Users online (9,527)