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

Like (0) Share

Report

Posted on 2 Aug 2022 05:04:16 by Community Power Pla...

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:

Using Apps Using Formulas

I have the same question (0)

All responses (2)

Answers (0)

MVP-Phipps 3,494 Super User 2024 Season 1 on 02 Aug 2022 at 06:23:14

Like (0)

Report

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

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

Was this reply helpful? Yes No
Community Power Pla... on 02 Aug 2022 at 09:25:35

Like (0)

Report

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

i have tried value as well but not coming

Was this reply helpful? Yes No