Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Apps - Power Apps Pro Dev & ISV
Answered

Formula column using a column from a related table?

(0) ShareShare
ReportReport
Posted on by 280
Hello everyone,
 
Question for two tables in the Dataverse. 
 
So, I have this table, 'Person'. Each person has a Region.
Like these columns:
Person: Jim
Region: Europe
Target: 1000
January: Target * 'Region Target %'
 
I've created a relationship with another table, 'Region Target', using the Region.
This table has these columns:
Region: Europe
January: 0.05
February: 0.1
etc.
 
Now, how do I create the Person's January formula using the 0.05 value in January in the Region table?
 
Big thanks in advance!!!
 
  • Verified answer
    AliceW Profile Picture
    280 on at
    Formula column using a column from a related table?
    Ha, I figured it out! Just type the name of the related table, then a '.', then select the column!

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

Quick Links

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 791 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 410

#3
mmbr1606 Profile Picture

mmbr1606 275 Super User 2025 Season 1