Address composite column

(0) Share

Report

Posted on by psreek

323

Hi,

We added the

The Address 1 column in dataverse is shown as a Internal Extent Data format.

Wanted to check how we can add a comma between Address Line 1, Address Line 2 and Address Line 3. Also, what is the way to create such custom composite fields.

Regards,

Prathyoo

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (0)

Fubar 8,321 Super User 2025 Season 2 on at

Like (0)

Report

Re: Address composite column

The Address Composite is provided as is you cannot change its format. (you can append to the end of its components e.g. if address1_line_1 contains data append a comma - this will then show in the Address Composite).

The Address Composite is not a format that is available as a datatype, if you want to build something yourself you would create a new field that is a Text Area or Multiline and the use either a Plugin, Workflow, or Flow to populate your new field.

Was this reply helpful? Yes No
SpoTechGeek 63 on at

Like (0)

Report
Re: Address composite column

Hi @prathyoo
You could use an fx Formula type column, then use regular formulas to concatenate. Here's an example:
Concatenate('Address 1: Name', Char(10), 'Address 1: Line 1', Char(10), 'Address 1: Line 2', Char(10), 'Address 1: Line 3', Char(10), 'Address 1: City', ", ", 'Address 1: State', ", ", 'Address 1: Postal Code', Char(10), 'Address 1: Country')
You can add commas anywhere you like by including ", "

Was this reply helpful? Yes No