CONCATENATE with Select and Text

[mendozacardinal]

I am trying to CONCATENATE with the SELECT Expression and Text. With the outcome of:

Name of Business Partner is Business Partner 

See below example:

CONCATENATE(Select(RELATIONSHIPS[Business Partner],[_THISROW].[Site/Location/Organization]=[Site/Location/Organization]),

"Name of Business Partner is   ",
)

[WillowMobileSys]

When you use SELECT(), it always returns items in the form of a LIST - even if it's only a single item.  If you are expecting only a single value, then you can wrap the SELECT() with an ANY()  function - which effectively selects the first value in the list.  Some App Creators use the INDEX() function.  An alternative approach is to use LOOKUP() which is designed to use critier to lookup a row and return a single value.

Additionally, in your CONCATENATE, the order of values is not correct.  Re-write the expression as below, and provide your expressions are accurate, you should get the text you wish:

CONCATENATE("Name of Business Partner is   ",
            ANY(
                Select(RELATIONSHIPS[Business Partner],[_THISROW].[Site/Location/Organization]=[Site/Location/Organization])
            )
)

[mendozacardinal]

Thanks. Now I get this following error: "Column Name 'Hospital President' in Schema 'GEOGRAPHY SITE_Schema' of Column Type 'Text' has an invalid data validation constraint '=CONCATENATE("Name of Business Partner is ", ANY( Select(RELATIONSHIPS[Business Partner],[_THISROW].[Site/Location/Organization]=[Site/Location/Organization]) ) )'."

[Tommy62]

CONCATENATE("Name des Geschäftspartners ist", ANY( Select(RELATIONSHIPS[Geschäftspartner],[_THISROW].[ Standort/Standort/Organisation]=[Standort/Standort/Organisation]) ) )

[WillowMobileSys]

Where, what column property,  are you inserting the CONCATENATE() expression into?   

Based on the error, it seems like you have placed it into the Valid_If property of the "Hospital President" column.  This would not be the correct place for such an expression.  

It also doesn't seem like the label you are creating belongs in a "Hospital President" column??  Maybe a description of what you are trying to achieve would help us point you in the right direction for your app.

NOTE:  Screenshots are tremendously helpful with error to provide complete context around the issue.