Formula Field as Lookup Value

[eunha]

Hello! I'm trying to set my formula field (concatenating two strings) as a lookup values for my list-string field, however, it seems that the formula field is missing in the dropdown options. Is that possible?

[GoodBoy]

Yes. Convert first your formula into VARCHAR. For example:

CONVERT(VARCHAR(255), [@field:Field1] + ' ' + [@field:Field2])

 

[GoodBoy]

Additionally, you may refer to this article about SQL Convert: https://www.sqlshack.com/sql-convert-function/ 

[Tubby]

Just want to share another forum post that is similar to this question. I have provided another approach/possible solution there:
 

 

[eunha]

OMG! That worked! Thank you so much!