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.
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
Thank you. I’ll see if I can get this to work.
User | Count |
---|---|
37 | |
25 | |
21 | |
20 | |
16 |