Look up column to return bold text and different colour for certain values in Modern SharePoint list

Question

Look up column to return bold text and different colour for certain values in Modern SharePoint list

Harry N Nomikos 1,336

Hi Team

I've created a look up column to return the below text values and the existing JSON formula has line break integrated in. What I want to achieve is having the below values in bold; please see below

Business Metro: Low
R&A: Low
BDSB: Low
Private Wealth: Low
Business Lending: None
Merchant Servicing: None

Can I have rating show in a different colour based on the table below

User's image

Here's the existing JSON formula, can you please amend to reflect the above requirements;

{

"$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",

"elmType": "div",

"txtContent": "=replaceAll([$GRACE_x0020_ID_x003a_Comms_x00200], ',', '\n')"

}

Thanks team
Harry

RaytheonXie_MSFT 40,486 Reputation points Microsoft External Staff

2024-12-18T02:53:15.81+00:00

Hi @Harry N Nomikos,

I am currently doing some research on this issue, will let you know as soon as possible

Accepted answer

0 additional answers

Your answer

RaytheonXie_MSFT 40,486 Reputation points Microsoft External Staff

2024-12-18T02:53:15.81+00:00

Hi @Harry N Nomikos,

I am currently doing some research on this issue, will let you know as soon as possible

Answer 1

RaytheonXie_MSFT 40,486 Microsoft External Staff

Hi @Harry N Nomikos,

Per my test, you could use following json to display different colour based on lookup value

{
 "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
"elmType": "div",
"debugMode": true,
"txtContent": "@currentField.lookupValue",
"style": {
"color": "=if(@currentField.lookupValue == 'Low', 'green', if(@currentField.lookupValue == 'Medium', 'orange', if(@currentField.lookupValue == 'High', 'red', if(@currentField.lookupValue == 'Unknown', '', if(@currentField.lookupValue == 'None', 'blue', '')))))"
 }
}

And here is the test result

User's image

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Harry N Nomikos 1,336 Reputation points

2024-12-18T09:53:37.64+00:00

Hi @RaytheonXie_MSFT

Thanks for your response.

Below is how the current lookup column returns the values

My expected results are below;

These values need to be in bold text

Business Metro:
R&A:
BDSB:
Private Wealth:
Business Lending:
Merchant Servicing:

Can you amend my existing JSON which includes line breaks to factor in the Bold text and colour values based on impacts

{

"$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",

"elmType": "div",

"txtContent": "=replaceAll([$GRACE_x0020_ID_x003a_Comms_x00200], ',', '\n')"

}

Cheers,
Harry
RaytheonXie_MSFT 40,486 Reputation points Microsoft External Staff

2024-12-19T01:57:08.5366667+00:00

Hi @Harry N Nomikos,

As far as I know, there is no such function to apply different css style in one cell. The json will apply to the whole div by "elmType": "div" in column fomating. And these values are all in a same div. So when we apply bold text or color to them, the whole div will apply same css.

I feel regretful to inform you that it turns out to be a by-design one. It is highly recommended that you can raise a new ticket on customers’ feedback. And I will vote the ticket for you. Thanks for your understanding.
RaytheonXie_MSFT 40,486 Reputation points Microsoft External Staff

2024-12-20T05:45:39.9066667+00:00

Hi @Harry N Nomikos,Have you raise a new ticket on feedback? You could post the link on current ticket, and we will vote up for you. Thanks for your understanding.
RaytheonXie_MSFT 40,486 Reputation points Microsoft External Staff

2024-12-23T01:09:59.3866667+00:00

Hi @Harry N Nomikos,

Would you tell me whether your issue has been resolved or have any update? If you have any questions or progress, you can contact me in time.

Share via

Look up column to return bold text and different colour for certain values in Modern SharePoint list

0 additional answers

Your answer