Answered

Can I create multiple collections from one connector response having different nested arrays?

(1) Share

Report

Posted on by aec2018 Microsoft Employee

I'm trying to populate a few different dropdowns from an API response. Instead of making two different calls, is it possible to create two collections if the response has two different arrays? For example:

{
 itemList1: ["foo", "bar"],
 itemList2: ["baz", "qux"
}

Right now, I can do ClearCollect(itemList1Options, APICall(apiCallHere).itemList1) to to assign the first array. But I can only figure out to how to save the second array to a collection by making a whole new call and using .itemList2 to extract it. How can I do this in just one call?

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

Verified answer

iAm_ManCat 18,256 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @aec2018

You could set the response as a variable and then reference the variable sub-properties 🙂

Set(gblAPIResponse, APICall(apiCallHere)); ClearCollect(itemList1Options, gblAPIResponse.itemList1); ClearCollect(itemList2Options, gblAPIResponse.itemList2); ClearCollect(itemList3Options, gblAPIResponse.itemList3);

Cheers,
aec2018 Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Wow. I swear I tried that before and it didn't work but I'm realizing now it's because this was when I didn't know I had to provide a strict schema to my custom connector for my PowerApp to recognize nested objects in the response. This makes perfect sense and saves me a bunch of separate API calls. Thanks!
iAm_ManCat 18,256 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Glad I could help!