Skip to main content

Notifications

Power Apps - Building Power Apps
Unanswered

Nested Collections

(1) ShareShare
ReportReport
Posted on by 178

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:
  • christian12 Profile Picture
    christian12 178 on at
    Re: Nested Collections

    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

     

  • poweractivate Profile Picture
    poweractivate 11,078 on at
    Re: Nested Collections

    @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.

  • poweractivate Profile Picture
    poweractivate 11,078 on at
    Re: Nested Collections

    @christian12 

    Try this:

    First(First(LookUP_Types).LookupTables).TableData

     Do you get an error when you use the above or does it work?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,567

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,907

Leaderboard