You’re offline. This is a read only version of the page.
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?
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?
@dpoggemann Thanks, it works.
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)
#1
WarrenBelz
146,660
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,999
Most Valuable Professional
Share
Report
All responses (
Answers (