Reference lookup field to get a value from the related table

(0) Share

Report

Posted on by MM-26090746-0

Hi All,

I thought this would be relatively simple but struggling as keeping errors. I have a lookup field in a table [Quotes] which retrieves vehicle type from table [Vehicles]. I'm trying to use the lookup field to retrieve the cost of this vehicle type from the [Vehicles] table to use in a subsequent calculation. I've tried using a formula column with [Vehicles].[Cost] using the table name or [Type].[Cost] using the lookup field name, but get invalid syntax error. Also tried calculated column, but get the same issue. Am I using the wrong syntax, is my lookup set incorrectly or is it not possible?

Thanks in advance

Categories:

Power Platform integration

I have the same question (0)

All responses (1)

Answers (0)

André Arnaud de Cal... 298,274 Super User 2025 Season 2 on at

Like (0)

Report

Reference lookup field to get a value from the related table

Hi,

Can you tell in what exact product you are trying the formula column? Maybe you can add a screenshot to illustrate to us what you are doing.

Was this reply helpful? Yes No