hi i have a formula for lookup value but the result is'nt I expected,
here is my formula
but result return like a code of lookup value like this:
I want to ask how can i get text of lookup value in this case
Like
Hello Mai,
You need to also read lookup object itself so to get lookup record name and use this name instead since when you read lookup field value from some edit page record you will get an ID of this lookup record instead of lookup record name. So simply add one more "Read data" element (called "Read data 2" for example) in your process (right after your existing "Read data 1" element) and read data from the object which represents "PIC" lookup on the edit page of the object you read in your "Read data 1" element. Once done please modify your formula and remove "Read data 1" part from it and "Read data 2" directly from your new "Read data" element and choose "Name" field there. As a result you will get lookup record name instead of ID.
Best regards,
Oscar
hi oscar
I have try but it seems not work, can you help me find out
here is my formula:
[#Read data 1.First item of resulting collection.Lead#] + " [PIC of Lead Has Changed To] " + [#Read data 2.First item of resulting collection.PIC#]
but it's not work
Mai,
Please read what I've wrote in my previous response once again. You need to read data directly from lookup object. You are currently reading the value from lead edit page and get PIC lookup record ID, but to get PIC lookup record Name you need to also read PIC lookup object itself and get record name from there. You are not doing it in your process and in your formula so that's why you are getting record ID instead of Name in formula result. Please add another Read data element and read data directly from lookup object and use this data in your process.
Best regards,
Oscar