Data Table to list multiple values in a column reading a lookup field from SharePoint

[Laik]

Hi everyone, 

I am using Data Table in PowerApps to filter records from a SharePoint List and one of the field in SP is a Lookup field with multiple values. I am able to see these multiple values in Data Table, however, it is in one row separated by a "; ". I want to have these multiple values one below another in the same record. I have used the following function in Text:

Concat(ThisItem.'Signatories',Concatenate(Value, "; ",Char(10)))

In short, how can I get the name (Ahmad A...) after "; " onto the next line, as I have more than one name in this column.

Regards.

Laik

[CNT]

@Laik 

Normally you will use Char(13) to go to a new line in controls like labels as seen below,

But this will not work in a datatable,

To get this type of functionality you have to use a gallery with a label as seen below,

[Laik]

Thanks for your prompt reply, how can we get a similar list as in SharePoint? (screenshot below)

[CNT · Accepted solution]

@Laik 

• As I had mentioned you need to use a Vertical Gallery.
• Set the Items property of the Gallery to the name of the SharePoint List.
• Add Labels for each column and set the Text property to ThisItem.ColumnName.
• For the LookUp column you'll have, Concat(ThisItem.'Signatories',Value & Char(13))

[Laik]

Dear Champ, 

Thank you for the solution, however, just wondering, is there any better way to get a Column Header as in Data Table to attach with each column?

Kind regards.

Laik