Forum Discussion
Sharepoint List Lookup question
Hi I have a Sharepoint list which uses columnn "sfg" as a look up, it then returns "sfglifecycle" for instance. I want to add a calculated column that references uses the figure that's been r...
You can't reference a lookup column in a calculated column formula. However you could use a flow in Power Automate to update the item with the sfgLifecycle x 10 value. An example of this is below and the x10 column is a number column:
Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Principal Consultant Power Platform, WSP Global (and classic 1967 Morris Traveller driver)