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 community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 411 Super User 2026 Season 2
Mohsin Ali 338
WarrenBelz 256 Most Valuable Professional
