Hi @rupa1 ,
Do you want to display multiple columns data in one column and display data in a data table?
Could you tell me:
1)those fields' data type?
2)if those fields are person type, whether those allow multiple value?
I suggest you use AddColumns function to add a new column with multiple fields' data.
1)If those fields are text type, you could set the data table's Items like this:
AddColumns(tablename,"newcolumn",field1&","&field2&","&field3&","&field4....)
2)If those fields are person type and not allow multiple value, you could set the data table's Items like this:
AddColumns(tablename,"newcolumn",field1.DisplayName&","&field2.DisplayName&","&field3.DisplayName&","&field4.DisplayName....)
3)If those fields are person type and allow multiple value, you could set the data table's Items like this:
AddColumns(tablename,"newcolumn",Concat(field1,DisplayName&",")&","&Concat(field2,DisplayName&",")&","&Concat(field3,DisplayName&",")&","&Concat(field4,DisplayName&",")...
)
Then the new added column will contain multiple columns data.
Best regards,