Announcements
I am creating a new Formula type column (Total Seeds) in a table and want to use column (No of Seeds) from another table in the formula but unable to use it.How to write formula for another table's column?
Hi @javeriatabassum
The related table must be in a Many:1 relationship (i.e. a Lookup column on your current table). See example here where I am referencing the Owning User and selecting a field from that table:
Only specific column types can be created (https://learn.microsoft.com/en-us/power-apps/teams/formula-columns#data-types)
@dpoggemann Thanks, it works.
I have a situation in Dataverse where I need a calculated column on Table A, where Table A is the "One" and Table B is the "Many." Table A has 5 records with 5 different Work Order IDs, and Table B has over 100 records, with those same Work Order IDs spread among many records, some records have the same ID. For each Work Order in Table A, I want a column to filter table B to the current record's Work Order, then sum up the values from a Completed column (numeric, just 0 or 1 values) in Table B. Is this possible?
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.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 505
WarrenBelz 502 Most Valuable Professional
Haque 324
