Answered

What is best way to combine data from custom objects?

(0) Share

Report

Posted on by Steve48

431

In my loop shown below I am getting data from Airtable. A loop is necessary because each API call returns a maximum of 100 rows of data. In each iteration I save the result into a custom object (ResponseAsCustomObject). I want to get all of the data into one data structure for further processing and data extraction after the loop. What is the best way to do that.

Categories:

Power Automate Desktop

I have the same question (0)

All responses (7)

Answers (1)

Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (0)

Report

Hi @Steve48

could you show me how each custom object response looks like ?

Was this reply helpful? Yes No
Steve48 431 on at

Like (0)

Report

Hi @Nived_Nambiar
Hope this helps

Was this reply helpful? Yes No
Verified answer

Agnius Bartninkas Most Valuable Professional on at

Like (0)

Report

Create a separate list for storing these. Let's say, call it %Records%. It can be empty at first (simply do a Create new list).

Then use Merge lists on it and merge %Records% with %ResponseAsCustomObject['Records']% in each iteration.

When you're done with all your loops, if you still want your records to be in a custom object for whatever reason, you can create a new one and add %Records% as a parameter to it. But if you're fine with just having it as a list, you'll already be there by just creating it and merging it.

-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.

I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.

Was this reply helpful? Yes No
Pavel_NaNoi 1,074 on at

Like (0)

Report

One quite easy way is to create a new list using the "Create new list" action at the very beginning (outside the loop), and then simply add each iteration of your offset to it in the loop via the "Add item to list" action, it will basically append every response into the list for each iteration until its done.

The most efficient way would be to somehow get the entire data in one go via the invoke, but obviously that depends on the API so eh.

Was this reply helpful? Yes No
Agnius Bartninkas Most Valuable Professional on at

Like (0)

Report

Using Add item to list with lists will result in a list of lists, which is not efficient at all. Using Merge lists would work better.

Was this reply helpful? Yes No
Pavel_NaNoi 1,074 on at

Like (0)

Report

Ah yes that's right, I forgot that its lists and not one item at a time which I'm used to. Thanks for the correction.

Was this reply helpful? Yes No
Steve48 431 on at

Like (1)

Report

Hi @Agnius
That was very helpful. It worked great. Thank you.
Steve

Was this reply helpful? Yes No