Populating a Form

[Scott_Hall]

I’d like to be able to populate a form with data from rows from another table whose selected column is set to a certain value. For instance: Any row from “service repair” table that has the value of “transfer station” in the [Status] column populates data from other columns in the service repair table into in a long text field in the form.

Is this possible?

Seems like a big ask but you guys are wizards so I thought I would give it a shot.

[LeventK]

@Scott_Hall

CONCATENATE(
	LIST(
		ANY(SELECT(Service Repair[Column1],[Status]="Transfer Station])),
		ANY(SELECT(Service Repair[Column2],[Status]="Transfer Station])),
		ANY(SELECT(Service Repair[Column3],[Status]="Transfer Station]))
	)
)

This will populate a LongText value of:
Column1Value , Column2Value , Column3Value

[Scott_Hall]

Thank you. I’ll see if I can get this to work.