web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / PowerApps - Issue disp...
Power Apps
Answered

PowerApps - Issue displaying a Collection (table within a table)

(0) ShareShare
ReportReport
Posted on by 18
I have a PowerAutomate flow that pulls the information into a collection called collectSP
 
I can view the collection within the View>Collections
 
But within the collectSP Collection is a table called bestMatches
 
TCMcNeill_7-1659023019224.png
 
But if I click into bestMatches I am able to view the data
 
TCMcNeill_8-1659023052263.png

 

When trying to display this collection in Canvas, I can get intellisense to pop up that it is recognizing the data
TCMcNeill_9-1659023084374.png

 

But when I select a specific field, I get an error message that there is a error in the formula.
TCMcNeill_10-1659023130256.png

 

Since this is populating the data type as a Table, I thought that I would be able to display the information in a table.
 
But in the table Control, I am getting the bestMatches table name as a field
 
TCMcNeill_11-1659023156765.png

 

But if I select the bestMatches table as a field, it will just show that there are objects inside.
 
TCMcNeill_12-1659023173297.png

 

And I get the error message in the table that it was expecting a text value.
 
TCMcNeill_13-1659023197093.png
 
Does anyone know how to access the table within a table scenario?
 
Thanks,
Tom
Categories:
I have the same question (0)
  • Verified answer
    DavidZoon Profile Picture
    738 Most Valuable Professional on at

    Hello,

     

    Try this syntax :

    First(collectSP.bestMatches)

    Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily.

  • Verified answer
    TCMcNeill Profile Picture
    18 on at

    Hi @DavidZoon,

     

    I wasn't able to use just First(collectSP.bestMatches).

     

    But when I changed it to a table to First(collectSP.bestMatches).bestMatches 

     

    I was then able to access the data in the table with individual fields

     

    TCMcNeill_1-1659027543311.png

     

    Thank you!

     

    -Tom

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
Vish WR Profile Picture

Vish WR 610

#2
Haque Profile Picture

Haque 317

#3
WarrenBelz Profile Picture

WarrenBelz 315 Most Valuable Professional

Last 30 days Overall leaderboard