Nested Collections

(1) Share

Report

Posted on by christian12

204

Hi Guys,

I have a collection with a few nested collections inside and want to extract the nested collection and overwrite the existing collection.

I can access the data by using the below formula

First(First(First(LookUP_Types).LookupTables).TableData).Ratio

Although I just want the collection to be my table data.

Is this possible?

Any help is greatly appreciated.

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

poweractivate 11,078 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
@christian12
Try this:
First(First(LookUP_Types).LookupTables).TableData
Do you get an error when you use the above or does it work?

Was this reply helpful? Yes No
poweractivate 11,078 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@christian12
Test with a brand new Collection because it may not be possible to overwrite the existing Collection, since the schema might be inferred on the Collection when the value is first set - so when you try to overwrite same Collection with some other random value with very different schema, there may be some error.

For example if Collection A has this schema [{Title: "A" Name: "B"}] and then you overwrite same Collection A with [{ Quantity: 3, Purchased: true}] there might be some error in doing this, whereas it might accept the overwrite when using something like [{Title: "C" Name: "D"}].

If there's no error you can do it, but if there's an error, try using a brand new Collection to test if it works with the Table Data.

Was this reply helpful? Yes No
christian12 204 on at

Like (0)

Report
Copy link

Link copied!

Yes I thought this was the case. I dont want to create so many collections.

I'm happy to let it as a nested collection.

My other question is how would I use say the items within the nested collection for a dropdown.

LookUP_Types>LookupTables>TableData> Column "Ratio"

Unsure on how to write this formula.

Thanks again

Was this reply helpful? Yes No