web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / SharePoint List calcul...
Power Apps
Answered

SharePoint List calculated column formula using a Lookup column reference

(0) ShareShare
ReportReport
Posted on by jasenpeters 8

Given:

A SharePoint List (SPL) called Contractors with the following columns:

ContractorID // Display name of the default ID column

ContractorName

 

Another SPL called Reports with the following columns:

ReportID // Display name of the default ID column

ReportNumber // Calculated column

Contractor_ID // Lookup column referring to the ContractorID column of the Contractors SPL

 

The calculated column, ReportNumber, would have a formula similar to:

= [ReportID] & "-" & Contractor_ID

Question:

Does SharePoint Lists support the use of a Lookup column in the formula of a calculated column?

If so, I need help on the proper syntax for the formula. (The formula above is not working)

 

Thanks in Advance

Categories:
Power Apps Pro Dev & ISV
I have the same question (0)
  • Verified answer
    v-xiaochen-msft Profile Picture
    v-xiaochen-msft Microsoft Employee on at

    Hi @jasenpeters ,

     

    This seems to be a sharepoint question.

    I suggest you post the question to sharepoint forum.

     

    In addition, at my knowledge,  calculated column can't use a Lookup column reference.

    vxiaochenmsft_0-1637555402685.png

    For your information.

     

    As a workaround, you could use flow to get the value of lookup column and update the string column instead of calculated column.

     

    Best Regards,

    Wearsky

  • macoson Profile Picture
    macoson 2 on at

    Being able to link tables through lookup values is a fundamental feature in any relational database, and it's something we can easily do in Excel. However, it seems we're still unable to use calculated values from different lists in SharePoint. Is there any indication that Microsoft plans to introduce this capability, or have they decided against it?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the February Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 531 Most Valuable Professional

#2
Haque Profile Picture

Haque 261

#3
Kalathiya Profile Picture

Kalathiya 221 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Auto-Populate field Power Pages
Gallery Tabs - Show or Hide Tabs based on Field Value
How to patch multiple records at once
Enable Copilot for end users in model-driven apps
Question for everyone : How are you using Create Text GPT in AI Builder?
Community content - sample components, blogs etc. - Link to this page (http://aka.ms/PCFdemos)
Welcome to the Power Apps forum!

Product updates

Microsoft Power Platform Community release plans