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 / How to Show multi sele...
Power Apps
Unanswered

How to Show multi selected data in Data table in Canvas App

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Hi,

I have created collection on OnStart of App for Datatable.

ClearCollect(collectRTTest,
AddColumns('Table1' As _Tab1,
"Serial",LookUp('Table1,'Number' = _Tab1.'Number','Number'),
"Status",LookUp('Table1','Number' = _Tab1.'Number','Status'),
"Function",LookUp('Table2','Number' = _Tab1.'Number','Function'),
"Category",LookUp('Table2','Number' = _Tab1.'Number','Selected Areas'),

 

And this collection connected to Datatable and all items are displaying but Selected areas not displaying because these are multi items, In backend table column is like below

Selected Areas 

Safty,Quality,Plan

 

In datatable, In this column it is displaying like below

[Object],[Object],[Object] 

 

My Backend is Dataverse and here Number is primary key.

 

How to rectify this.

 

Thanks

Categories:
I have the same question (0)
  • MVP-Phipps Profile Picture
    3,521 Super User 2024 Season 1 on at

    In the data column itself can you try adding .value.

     

    Please Accept as Solution if it solves your question. Or just give it a Thumbs Up if it is helpful because this can help others.

    LinkedIn: https://www.linkedin.com/in/charlie-phipps-%F0%9F%91%A8%E2%80%8D%F0%9F%92%BB-91338715b/
    YouTube: https://www.youtube.com/channel/UChmFBGU1YKIU91sNMQ7buGg
    Twitter: https://twitter.com/phipps0218

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    i have tried value as well but not coming

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 316 Most Valuable Professional

#2
11manish Profile Picture

11manish 242

#3
Valantis Profile Picture

Valantis 198

Last 30 days Overall leaderboard