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
Solved! Go to Solution.
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,
Thanks for your prompt reply, how can we get a similar list as in SharePoint? (screenshot below)
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
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
User | Count |
---|---|
184 | |
95 | |
62 | |
59 | |
58 |
User | Count |
---|---|
246 | |
165 | |
91 | |
76 | |
70 |