Presentation of CONCATENATE() Query

[MauriceWhelan]

Hi.

I am using the following expression to CONCATENATE values from 2 columns
CONCATENATE(
SELECT(MHE_Vehicle_Checklist_Issues_Master[Failed Check],[Record ID]=[_THISROW].[Record ID]),
": ",
SELECT(MHE_Vehicle_Checklist_Issues_Master[Description],[Record ID]=[_THISROW].[Record ID]))

The presentation of the result is (based on 3 values being returned for each column)
[Failed Check] value,[Failed Check] value,[Failed Check] value,
[Description] value, [Description] value, [Description] value.

Is there a way that I can amend the expression so that the presentation comes out as
[Failed Check]: [Description], [Failed Check]: [Description], [Failed Check]: [Description]

Hope this makes sense.

Thank you.

[LeventK · Accepted solution]

The best approach might be to create a VC in that MHE_Vehicle_Checklist_Issues_Master table

[Failed Check]&": "&[Description]

And list this VC’s values:

SELECT(MHE_Vehicle_Checklist_Issues_Master[VirtualColumn],[Record ID]=[_THISROW].[Record ID])

[MauriceWhelan]

Thanks so much @LeventK. I will test your suggestion.

[MauriceWhelan]

Hi @LeventK.

Your suggestion worked perfectly, thank you again.

[LeventK]

You’re welcome.

[MultiTech]

MauriceWhelan:

[Record ID]=[_THISROW].[Record ID]

Would you benefit from connecting things using references???

help.appsheet.com

References Between Tables

Learn about references, when to create them, and how to use them so your data makes sense.