How to apply the lookup column value when formatting the column by JSON

(0) Share

Report

Posted on by york

Hi Guys:

I have a list with lookup value, the lookup source is product name, the lookup value is the column "Product Name:Mic Assembly", and if the Inspection Type is "Mic Assembly", I hope the Workstaion Qty will be "9" as shown in the "Product Name:Mic Assembly" column.

But the expression below can't get the value, could you help check the reason? "[$ProductName:MicAssembly.lookupValue]" may be a mistake, but I don't know how to correct it.

All responses (1)

Answers (1)

Verified answer

Expiscornovus 31,113 on at

Like (0)

Report

Re: How to apply the lookup column value when formatting the column by JSON

Hi @york,

That is SharePoint Online column formatting, which is not directly related to Power Automate.

That being said, make sure you use the internal name of the field in the column formatting formula. You can find that name in the list settings.

https://elliskarim.com/2021/12/20/finding-the-internal-name-of-a-sharepoint-column/#method-1-column-settings

Below is an example in my dev environment