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

Notifications

Announcements

Community site session details

Community site session details

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

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 793 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 333 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard